Hey there,
I have the following set up.
There are 2 columns in table 1.
Column A “Monday of the week” is a formula field that calculates the Monday of a week.
Column B “Manual weekly entry” which is a linked field to table 2.
Table 2 has a primary field “Monday of the week”. There is also a roll up column that rolls up all the record in Table 1 that are part of that Monday of the week.
When copy pasting manually Column A in table 1 to Column B in table 1 everything works perfectly and there is only 1 Monday of the week with a roll up of all the record that should be in that roll up.
However, when trying to automate the copy pasting through Airtable Automation (or Zapier, the result is the same) then the pasting is happening correctly, but in Table 2 we see that a duplicate Monday of the week in the primary field is created with each time only 1 record in the roll up.
Is there a way how this copy paste can be automated without creating a duplicate Monday of the week with a single record in the rollup in Table 2?
Thanks in advance!
Levi