I have created a Report to run at 0100 each day to check every row in a table for duplicates. The report calls an action and that action is set to write DATE(Today()) in [Duplicate] for any records that have a duplicate. This bit works fine.
The issue is that in checking each row its re-running all the App formulas in that row. So I have [Date] with an App formula of Today(). This has been changed to 18/02/2021 in all duplicated rows.
Is this by design or a bug? Since it seemed intuative to me that simply writing a value in a column would not change any other columns.