How to create a dynamic (calculated) link to another table?
There is a Table#1 (Daily Expenses) [ID, Date, Sum, subject,MonthNo].
Where MonthNo=MONTH({Date})
There is a Table#2 (Months of the year) just as follows:
MonthNo MonthName
1 January
2 Febru...
The issue is still important to me. However, the keyword here is “dynamic” i.e. a link to another table which does not exist until I calculate it using a formula.
Just few words in addition. Since Artable does not provide a flexible reporting system I considered the mechanism of dynamic links to be the only way to maintain a small accounting application. For example, to consolidate figures with subtotals by pe...
