Hi, I have 2 tables: Table1 and Table2.
In Table2 I have the field “SUM”, which I use as the linked field in Table1. For some linked records, within the Table1, I want to change the value of field “SUM” leaving the original value not changed in Table...
I agree with you on junction tables, it’s really useful, especially for many-to-many relations when designing databases. Initially I did not consider the airtable as the traditional relational database. And it really makes sense now when looking at a...
Justin, thanks for your answer! It sounds like a good workaround, so for now I’m ending up with this solution, hoping that airtable developers will extend their functionality in the future.
Almost right :slightly_smiling_face: Well, I think it’s better to see something once than to hear about it a thousand times.
Here is a link to sample table: https://airtable.com/shrUitLKclYVQQlCj
With such tables structure, I want to add the “Produ...
Thanks for your reply. Sorry, maybe my question is not clear enough.
The “SUM” field from the TABLE2 has the field type “Currency”.
And in TABLE1 I have the field “TOTAL”, which is of type “Rollup” and shows the sum of all records linked from TABLE2....
