Total of a field , without relationship
I have a table in that i have one field called amount , so without any relationship how to get the total of the particular column in the same table
Forum Discussion
I have done something like the following, which will require some coding though:
1-Create a "Text-Formula" field and allow HTML tags in it
2-Add "<img> " and have the onload() function to run a script that will run api_genResultsTable&jsa=1 query, clist for the column to be calculated and get the total in javascript.
3-Add "<p>" with an ID that have the record ID composed in it so you can use in it a report
4-Return the calculated value in that <p> tag
The only downside is that you cannot export result, it will show as script in the CSV file. But it is good to study and check visually.
1-Create a "Text-Formula" field and allow HTML tags in it
2-Add "<img> " and have the onload() function to run a script that will run api_genResultsTable&jsa=1 query, clist for the column to be calculated and get the total in javascript.
3-Add "<p>" with an ID that have the record ID composed in it so you can use in it a report
4-Return the calculated value in that <p> tag
The only downside is that you cannot export result, it will show as script in the CSV file. But it is good to study and check visually.
Great. I got the alert popup to work. I am not sure how to calculate the total with the API_genresultstable? Possible to provide some color on that as well?