Hello,
I am working with a very huge database which often takes hours to load. It is a database which would append daily records to it so that I can keep track of all the changes and historical data.
Therefore, in the load script I would include a statement in the load script editor like this to shorten the load time:
WHERE vRECORD_DATE = '2021-10-11'
However, I would also like to make this a variable so that I can change it in the front end.
I am trying to take this approach
Let vRECORD_DATE = today();
However, everytime I update the variable using variable input and reload the data, it is still showing today()'s value.
May I know how to update the variable in the front end and trigger a reload on the sheet as well? (without going to the load script editor)
Thank you so much!
