sfa71

I think, with much struggle I figured it out. In this business, only a 2 day struggle is a win. Loaded the table, updated it iteratively and selected table elements in the calculations. shared here - long trigger so I had to scroll and record https://www.dropbox.com/scl/fi/601x4xlsduxk8y9nvrby7/Trigger-with-table-variables-2024-05-30_08-51-00.mp4?rlkey=omj7hnr3apg7o3jzotqxwlsz0&st=domtuqqt&dl=0

Trigger record limit I understand is 10,000. I'm looking for more resource that might explain what the record count is based on. for example, does a SELECT statement over a table count every record in the table toward the 10,000 limit? I calculate I am only processing about 2500 records but the trigger keeps exceeding the 10K limit. And in testing, when the 10K threshold is met there is no alternative but the abandon the Caspio session completely as is just keeps firing the trigger and reporting the error. It is a monster trigger accessing about 12 tables

Trigger record limit I understand is 10,000. I'm looking for more resource that might explain what the record count is based on. for example, does a SELECT statement over a table count every record in the table toward the 10,000 limit? I calculate I am only processing about 2500 records but the trigger keeps exceeding the 10K limit. And in testing, when the 10K threshold is met there is no alternative but the abandon the Caspio session completely as is just keeps firing the trigger and reporting the error. It is a monster trigger accessing about 12 tables

thanks for the response - so my issue is I have a trigger that has a "for each record in" process over a large table and the trigger goes over the 10K records limit. So I want to get a subset of the table created - thus I was thinking maybe a variable table would help but I'm not think that anymore. So I was moving toward a dynamic data-qualifying view but in the trigger, I don't seem to be able to select a view as a data source. I had a brute force method working until the tables got too big.

trying to find examples or best practices around defining and use tables variables. this forum had a question in 2020 that had an unofficial .pdf file attached that has been removed. Has anyone used the table variables successfully and live to tell about it. I've blown out my record count in a trigger and I want to load table variables to possibly avoid some thrashing.

Caspio chat responded with: Unfortunately, it's not possible to force the table 1 commit before the table 2 execution. What I suggest is using application tasks instead to run the process, however, it's only for a scheduled basis. Refer here: https://howto.caspio.com/tasks/ Any other ideas? my options seem to be to replicate the trigger in table one and use #inserted records or just have the user remember to force an update via table 2.

Table 1 has a price that is used to compute a total stored in table 3 by multiplying by a number of units in table 2 There is a trigger on table 1 update that revised a field on table 2 specifically to instigate an update in table 2 (so if the price changes it will recompute the total) There is a trigger on table 2 update that revises the total on table 3 Formula- Price(table 1) X units (table 2) = total (table 3) When a change to the units in table 2 happens, the total in table 3 is recomputed via the trigger on update in table 2. I want a change in table 1 to also execute the table 3 total - it is a very complicated trigger and I don't want to duplicate it on table 1 since there is no copy function for trigger specifics so i added an update flag on the table 2 that the trigger on table 1 sets true and that triggers the total update trigger on table 2. All works and records updated properly but...... Problem is that the table 2 trigger doing the computation does not see the changed data in table 1. Like the change to table 1 has not committed to the DB yet when the table 2 trigger is executed. Is there a way to force the table 1 commit to the DB before trigger in table 2 executes?

Works perfectly ProFor_Basic_Items Chart(1).pdf

This makes a lot of sense thanks - I am not very experienced with javascript = can you point me to a resource where I could see an example of the header javascript that could lookup data in a caspio table? I pass a parameter into the chart that selects the record to display. The record for display of the values carries the id for a user name and a second id for the project. I want to lookup the user name and the project name form their respective tables to display in the header of the chart.

looking for example of how I might customize a header in a charts datapage to display data from a different table based on elements in the chart data