I was told Airtables had better database like features than Notion, but cant find them
I have 3 tables, A → B → C , and want to get data from A in C but cant find a way
For example I have a clients table, a contracts table and a monthly payments table, in payments table i link to the contract to be paid (and ofc contracts links to clients), clients table include a field security_deposit. I want to calculate the amount to pay for the given month, and include a checkbox to mark its the first payment.
Another thing (that Notion can actually do) is to reference a column of a linked table in a formula, I cant find away to reference data by formula in Airtables.
For example, in Notion using gui i cant do what i want, but I can use a formula to achieve it.
This would be something like: if( first, contract.map(current.client.map(current.security_deposit)), 0 )