AppGini Community Forums

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:...

Thanks. Your suggestion work in php.

Just wonder how to implement this to the calculated field. As I now there is pesudo code for id, primary key and table..

but, how to custom a pseudo-code?

Table A Value 3 How to do a sql query to assign 'medium' based on the value in the Table A? The category will be referenced from Table B. I can think of case when...then (hard-code) in the sql query. Is there any alternative way to write the query? Table B Category Min Max Low 0 2.99 Medium 3 4.99 H...

I think if using the same id columns for filtering multiple ids, it has to use 'OR' instead of 'AND".

Is there a limitation on url length? max is how many characters?

I have a slightly difference question.

Is there a way to encode a permalink for multiple ids?

something like filter with ids in {1,2,4,5,7}

I have using csv import for thousands of records. Below is my observation: 1) the data import quickly into the table as it was observed the data have already loaded into the db table even the process not complete yet. 2) the process of registering membership_userrecords takes much longer time. It to...

I have test in other environment and it works fine. The audit log menu appeared at top right.

Thank you.

I am experiencing this:

After import csv data, error message turn up 'You don't have permission to access this table. Please contact the admin.'

I was logged-off by the system.

May I know is this still the bug?

Regards,
Stephen

May I ask whether the placeholder %%memberID%% in the advanced lookup query is workable?

Is there any other type of placeholders?

My temporary solution is :


include incFunctions.php in lib.php

create the following files in hooks:
import_csv.php
//create custom function for $transformFunctions

incFunctions.php
//create custom function for lookupQuery and pkGivenLookupText

I am trying to do csv upload for fields with cascading drop down. Advanced sql appended to the default: WHERE `tablename`.`field` = '1' // added before ORDER BY 2 -> the form entry still working The csv import not able to load the correct id from the primary table. Query log display the SQL syntax e...

It is not a bug. Just filter the records before print preview.

I would like to just share my own experience, despite encounter some clichés, but the overall audit is still functional. After plugin installation: I discovered that the menu was not showed up then I have to manually add it in the 'admin/incHeader.php' as shown in documentation pg. 11 section 3.2 I ...

This code shall works at header-extras.php <script> \$j(function() { if (localStorage.getItem("columns-contact_view") === null){ const field = {"contacts-department_id":true,"contacts-name":true,"contacts-email":false,"contacts-phone":false} window.localStorage.setItem('columns-contact_view', JSON.s...

Anyone could offer help here? I need to parse the php variable to the javascript in js file as follows: //table-tv.js for mass update. Want to replace the selection drop down list with a php return value // part of the code// /* prepare select2 drop-down inside modal */ $j('#mass-update-new-value-mo...

Just for sharing. It works in certain extents.
But, if there is changes on toggle fields, it will not persist over the page or refresh.

I guess the cookies will be re-write for every refresh or page navigation.

I try it on the browser console: window.localStorage.removeItem('columns-contact_view'); const field = {"contacts-department_id":true,"contacts-name":true,"contacts-email":true,"contacts-phone":true} window.localStorage.setItem('columns-contact_view', JSON.stringify(field)); It works and will unset ...

Appgini 5.97 I wonder whether it is the right behavior. The print preview in Table view will actually print all the records instead of the table view per page. Is there a way to limit the no. of records shown in the print page? If it is truly the right behavior, will the execution of print preview a...

Finally, I discovered that the menu was not showed up because I have to manually add it in the 'admin/incHeader.php' as shown in documentation pg. 11 section 3.2 After put the code, the menu will show up in the left instead of right. I also also check on the config.php but no code was appending at t...