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.
Yes sir, are you familiar with the onload technique ??
-Add a text-formula filed.
-Allow some HTML code
-Add "<img src='[any image url, required]' hidden onload='javascript: alert("OK")'>"
-Try this, if it alerted "OK" then you can replace the alert function with a function that will search and calculate total using api_genResultsTable
Let me know if you need more clarification
-Add a text-formula filed.
-Allow some HTML code
-Add "<img src='[any image url, required]' hidden onload='javascript: alert("OK")'>"
-Try this, if it alerted "OK" then you can replace the alert function with a function that will search and calculate total using api_genResultsTable
Let me know if you need more clarification