AppGini Community Forums

please ignore. issue rectify.. update incCommon.php

Appgini 5.97 SELECT `trial_recfertiliser`.`id` as 'id', IF( CHAR_LENGTH(`trial1`.`trial_code`), CONCAT_WS('', `trial1`.`trial_code`), '' ) as 'trial_id', IF( CHAR_LENGTH(`fertiliser_conversion`.`fertiliser_name`), CONCAT_WS('', `fertiliser_conversion`.`fertiliser_name`), '' ) as 'fertiliser_name' FR...

How to code the button color so that the button color based on certain conditional value?

eg. if query_value >0, then color = green, otherwise, red.

Button is currently generated using jquery.

May I ask whether you have resolved it? Can you share the workarounds?

May I know where to place the update_calc_fields function so that the calculated field will be auto-calculated after every csv import?

The code works. Thank you pböttcher

How to change the text color of drop-down options?

I would like to change the background of option list with different color as shown below. Trying to use the code as shown below, but nothing seems to have changed in appearance.. Is my selector correct? https://i.imgur.com/cVTxpxr.jpeg Code placed in tablename-dv.js $j(function () { var onSelectOpen...

I trying out the code shared by Pbotcher, but couldn't make it work...Can anyone help? Following is the js code: https://forums.appgini.com/phpbb/viewtopic.php?t=2876#p9282 $j(function () { var onSelectOpen=function(){ $j(".select2-drop-active .select2-result-selectable:eq(0)").css("color","") $j("....

Hi. I would like to know how to concurrently do calculation for the calculated field when importing record via csv import.

Any idea?

Regards,
Stephen Yap

thanks. It works.

For the list option using csv method, if the 'option 1' is removed from the csv. The previously entered value will not be shown in the form details. Re-saving the record will nullify the value. Is there any tricks to circumvent the changes on the field to NULL during saving despite the original valu...

I would like to let user to choose the no. of record per page. Is there anyone can share the code? I am thinking of leveraging $x->RecordsPerPage = $pagenumber; and create a table to let users to specify page number eg. 25 instead of hard-coded? But, how to store that in the session when a user modi...

Hi mohamed, I have similar objective as yours which is to allow user to view records which are inaccessible to them in the actual table. I think we can create the view for each table and edit the global-search.php where: /* get tables accessible by current user */ //$tables = getTableList(); //chang...

May be this is something you looking for

viewtopic.php?f=4&t=2870

Having querywhere set in hooks init, I am able to filter the record. But, if navigate from other page to the page that have querywhere set, the page will not load and require re-submission/refresh.

I did the test before and after installation of audit log. However, I didn't meant that the flaw is from the audit log, it could be the conflict with existing setup. I will try on a fresh generated application using Appgini 5.97 (before and after) to confirm again.

Hi, onoehring I am experiencing a little annoyance after install the audit log on Appginin 5.97. When I navigate to admin page after the first login attempt, it will return me to an login page again. I have to re-login in order to access the Admin page. May I know whether this is bug that ye to reso...

How to implement update_calc_fields function in import-csv.php so that every record imported would have calculated field run automatically?

Thank you for your kind suggestion.

That should avoid the link send via email being truncated. A proxy link (shorter) to return the actual link (long). But, the long link will still limited by the browser url's length. I check on the https://youtu.be/7gMWoVh62wU?t=145. In appgini old version, it actually generate the POST form. May th...

Hi, Oliveira. Can you elaborate more or give example/ any external reference? save query string on a temporary file - if it is temporary, that means it will not be persistent and access in future? request string on load with sessionStorage or localStorage - request strings is GET to the temporary fi...

Interested to know the method.

For example, I have constructed a url for a filtered records, as follows: http://localhost.com/abc_view.php?SortField=&SortDirection=&FilterAnd[1]=and&FilterField[1]=1&FilterOperator[1]=equal-to&FilterValue[1]=39&FilterAnd[2]=or&FilterField[2]=1&FilterOperator[2]=equal-to&FilterValue[2]=40&FilterAnd...

There is url length limitation: When the url was constructed and email to outlook, it tends to be truncated if length exceeded 2048. In addition, different browser also will put limitation on the url length. Is there any existing method in appgini, something like a POST method? I explore this https:...