Good day everyone,
Was wondering for some guidance or direction to achieve this. I have one table where i clear and repaste in new and updated information. But a second table that is using the same info as column 1 in the refreshed table, say AB1. That number always stays the same, and trying to be able to add notes to that row but needing it to stay after i refresh the data. So that way i have notes that follow that number around.
Not sure if this is the best way to do this, but was the only way i could think of. Had it working at one time, was able to use a lookup formula filtering by thisrow. But this doesn’t seem to work anymore. Thanks in advance.
So you’re saying in Table A and Table B, Column 1 is always the same, and they should be connected based on that column?
1 Like
Thats what I’m trying to do
Can you make a relation column in table B, and write a formula TableA.filter(Column1=thisrow.column1)
1 Like
Since you’re already using an action to perform this, I’d recommend using AddOrModifyRow, with this column as the parameter for matching. This way, you’ll update an existing row in the table (instead of deleting and re-adding it), and any new rows that don’t match the parameter will be added to the table.
To maintain the relationship between the two tables, particularly the second table that contains the notes, I recommend using a relation column linked to the first table. You can either follow what @Samuel_Langford suggested or, during the action from the first table, establish the relation directly in the formula.
Best Regards,
Arnhold
2 Likes