HOW TO DO MANY TO MANY RELATIONSHIP MODELLING IN APPSHEET?
@Naveen_N Hi Naveen, to model many-to-many relationship, a bridge table, or associative table, is usually needed. Here’s an article that explains this in more details:
Thanks For Your Answer. HOW TO IMPLEMENT IT IN APPSHEET.
@Naveen_N Suppose you have 2 existing tables A and B, and the relationship between A and B is many-to-many. You will need to create a new table in your app, and this table will be the bridge table. The relationship between A and the bridge table is one-to-many. This means that you must create a ref column in the bridge table that references table A. Similarly, the relationship between B and the bridge table is one-to-many, and you will also need to create a ref column the the bridge table that references table B.
Is there any Way to get Set of Rows Automatically in That Table Using list Formula?
Do I need to Add Every row manually?
Just dropping in a link to a summary post I made, which contains a sample app, about how to accomplish this.