please help me.
I have a table with two columns: ID and Product.
The information is imputed through a bot.
The more the ID buys the more lines it will have.
At the end of the flow, to ensure that the ID has completed the purchase, I need to flag it in a new column: purchased = YES.
however, the bot can only insert “YES” in the first line of the ID and the others are blank.
There is a way inside airtable so that I can repeat the “YES” for an ID if there is already a row with that ID and the column purchased “yes”.
Example:
table:
ID, purchased
123
123
123
123
Current results:
ID, purchased
123 YES
123
123
expected outcome:
ID, purchased
123 YES
123 YES
567
765
123 YES
123 YES
