dear All ,
Hope you are safe & doing good.
i just started a new app, where in i have 2 tables
Table -1 : General
Table -2 : Civil
both the tables got some same columns. both the tables are required to have same Unique Id. Since the Table 2 is extension of Table -1.
when we enter the data in Table- 1 & save. it has to create a new record in Table -2 with some columns data from Table -1 record created.
by using the data , the user enters further data in newly created Record in Table -2.
i tried to use array formula Google sheet , but it is not behaving correctly.
Any easy method to link & create new record in Table -2.
Thanks for your Help in advance.