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.
Hello,
I am trying to do something similar. Essentially I am trying to get a summary field without a relationship. I have some coding skills and I am proficient with quick base api's but could you possibly provide some more information on how to do this?
I am trying to do something similar. Essentially I am trying to get a summary field without a relationship. I have some coding skills and I am proficient with quick base api's but could you possibly provide some more information on how to do this?
