I have a table with a date column. I wish to add X amount of days to this column where X is the result of a calculation in another table by clicking a button.
I can’t seem to get it to work, the thisRow function doesn’t seem to be available (I’m referencing the main table and not a view in the button). Instead it adds the number of days to all rows then inserts all those values into a cell.
What do I need to do to get current value or thisRow to just add X number of days to each row individually?