We have created an app using Formulated Google Sheet. The columns are linked into 'Go to Details' and 'Forms' Editable. We are facing a problem wherein if we have linked 20 fields into a view,
Problem 1: on the Go To details we see about 10 columns on one record item, 12 columns on another record and so on.
Problem 2: on the Forms we see that there are only 5 or 6 fields showing.
We had not put any show conditions and are using a default view
are you able to share more into or a photo of your data table and how it is structured?
The table data has a formula that fetches data from another google sheet where the master data is residing (using Xlookup formula). The columns that are not visible would either not have data to show from the source dataset from where it is looked up which we have set it to blank if no value found. Further, the column either in view detail mode nor in Form view are visible.
User | Count |
---|---|
17 | |
11 | |
7 | |
5 | |
5 |