AppGini Community Forums

(+1) It would be even more flexible to have a PHP-hook for lookups which would allow us to return any array of { id, text } -entries with completely free options for sorting, filtering etc.. Having this, we could even fetch any items from remote web API's or any other local or remote data provider, ...

Perhaps this can help: https://bigprof.com/appgini/m2a But, honestly speaking, I did not use it for years now. For me it has always been easier to start a new project from scratch, then add required tables and fields manually, and, if necessary at all, import and convert data from old database table...

Hi, just send your ordernumber by email to [email protected]

I will check your licenses and then send download links for all purchased products within you 1-year-free-updates period.

Fortunately, AppGini ships with the awesome Moment.JS library (https://momentjs.com/) which helps us on date-/datetime-formatting and -conversion between formats (database format/UI/locales). Additionally the moment.js functions are tested extremely good and very readable. They will work in most cul...

Examples can be found in the docs for calculated fields, mentioned above. The rest is pure SQL and requires some SQL-knowledge plus your specific table names, column names and relations (lookup-configuration). Example: Tables Projects projects -id -name -... Tasks tasks -id -project_id -project_name...

According to the docs about calculated fields I have given to you before (https://bigprof.com/appgini/help/calculated-fields) there is no need for an update-SQL-command but for a SQL-SELECT statement, more precisely: for a SQL-SELECT statement returning exactly one value. That one value will be set ...

Post your table names, column names and lookup definition here. Then we can help you writing the SQL command.

https://bigprof.com/appgini/help/calculated-fields

Create a new field, set as readonly, on tab calculated field put sql command. That's all.

By default it will always be the primary key of the master table. That's the way it was designed.

If you need data inside the table, not only the keys, you can, for example, add more readonly columns and configure them as calculated fields, automatically filled with the master's data.

Just from my experience: if there are problems with German Umlaute or other special characters during file-processing, first check encoding! It takes just 2 seconds and can save hours of search.

what are the steps for syncing the Appgini Calandar Plugin with Google Calendar To my knowledge the plugin accesses data of the table/tables you have configured. The question should rather be: how can you synchronize appointments from the Google calendar with your database tables. And that should b...

I the CSV file encoded properly? Utf8?

What do you think is better in terms of usability: toggle buttons in "button"-style or in "link"-style? Button chrome_5c8KxFMTA5.png Link chrome_HuGqBFCPVi.png Here you can find the poll on twitter: https://twitter.com/bizzworxx/status/1633356597022924801?s=20 Or just write me your opinion directly ...

Pro-Tip If you declare the (Javascript) DV -variable in hooks/header-extras.php already, you don't have to declare it in every DV. <!-- file: hooks/header-extras.php --> <script> var DV = AppGiniHelper.DV; </script> DV will be available automatically in each hooks/TABLENAME-dv.js : // file: hooks/T...

var ACTION = AppGiniField('ActionR').getValue(); Arghhh, I have just seen why your original code did not work. I have missed that before :? You can still use the "old" constructor, but this requires a "new" keyword: Wrong var ACTION = AppGiniField('ActionR').getValue(); Right var ACTION = new AppGi...

var ACTION = AppGiniField('ActionR').getValue(); If ActionR -field is a lookup (which I cannot see from your bugreport), remember that .getValue() returns an object , having id and text , not a simple type value. Check return value in console: var field = AppGiniHelper.DV.getField("FIELDNAME"); var...

Does the syntax changed in the new version ?

No, but I recommend using... ...instead, which should be a little more performant if you use the field more often in the same script.

By the way:
If you send your order number to me by email, within your 1-year-free-updates period I can send the latest version to you. There have been some improvements to .getValue() function recently.

Can you please give me more details: Datatype settings of that field "ActionR" Does the problem occur in readonly- or in edit-mode ? What is the expected result and what is the actual return value ? Is it on load or later on? For lazy-loaded fields (like lookups) you will have to wait for them. Are ...

Hopefully helpful information I know this thread is about URLs in Javascript . But just in case someone needs to find out and work with paths in PHP , there are some helpful AppGini-PHP-functions in incFunctions.php : application_uri() application_url() For example if your app in located in a subdi...

document.location.href = "../index.php?signOut=1"; If your page is located in root-directory of your app (actually your sub-directory), what about just using " index.php " (without " ../ "): document.location.href = 'index.php?signOut=1'; ../MYINSTALLATIONDIRECTORY/ Caution If you want to move your...

Basic knowledge about element selectors in HTML will help you identifying addressable elements in any of your HTML pages. About selectors https://www.digitalocean.com/community/tutorials/how-to-select-html-elements-using-id-class-and-attribute-selectors-in-css Having identified an element's selector...

change the color of the fonts and make them bold in the detail view Ugly and useless example showing basic CSS styling. This should give you a starting point. Code <!-- file: hooks/header-extras.php --> <style> .detail_view label { color: orange; font-weight: bold; /* more */ font-style: italic; bo...

I would like to briefly introduce a new feature that will most likely be included in the next version of the AppGini Helper Javascript Library. Similar to toggling columns in Table View, users (!) will be able to hide and show fields in Detail View with next version. To keep the functionality of our...

I think I did not get the business case: The field is NOT required If the answer is optional... hide the NONE option ... and, at the same time, the answer has to be either yes or no , ... then what shall the user select if he/she doesn't want to answer the optional question? In other words: If requi...