Alex_Varlamov - profile

Alex_Varlamov · Jan 30, 2020

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...

Alex_Varlamov · Jan 31, 2020

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...

Alex_Varlamov · Jan 30, 2020

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.

Alex_Varlamov · Jan 30, 2020

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...

Alex_Varlamov · Jan 30, 2020

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....

User Statistics

User Activity

Change field value of linked record without changing original value

Re: Change field value of linked record without changing original value

Re: Change field value of linked record without changing original value

Re: Change field value of linked record without changing original value

Re: Change field value of linked record without changing original value