Hi, In my seller main form I have a customer field, it can add new customer or search for old customers here.
The customers table is a different table, can I make two tables for customers
table 1
table 2
and allow the above customer field in the order form to search and read data from the two tables.
Solved! Go to Solution.
If you are on an Enterprise license then Data Partitioning maybe your answer besides migrating to a more robust DBMS. I am only on a free plan and no experience on this myself. Maybe other members have better suggestions.
https://support.google.com/appsheet/answer/10105383?sjid=8985876769063475868-AP
You can combine lists from two tables to make a suggested values list. However, you cannot make the column a reference column any more and I assume that would break you app.
What is your reason for having two tables for customers? If you provide your intentions/requirements rather than solution ideas, you might get more suitable proposals from the community.
Thank you for your help
Because appsheet google sheet is limited to about 100k .. I thought if in case I reach the 100k what to do
If you are on an Enterprise license then Data Partitioning maybe your answer besides migrating to a more robust DBMS. I am only on a free plan and no experience on this myself. Maybe other members have better suggestions.
https://support.google.com/appsheet/answer/10105383?sjid=8985876769063475868-AP
@TeeSee1 Thank you very much
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |