Hello all. I really would appreciate anyone's help on this as I cannot find any related discussion at all.
I'm building a website where I have many dynamic tables (different filtering and sorting rules for each) connected to my collections database. My collections database also has many fields, but I only need 4 fields (i.e., columns) to be displayed in the dynamic tables.
The default setting on dynamic tables is to have every field in the database collection first appear, and then you must separately delete each unneeded field/column. So each time I create a new dynamic table I need to delete hundreds of fields/columns, one at a time. This is way too cumbersome and time consuming.
My questions: 1) Is there a way to get around the table display default by just selecting the 4 fields I need to display, rather than deleting the hundreds on fields I don't need to display. 2) If not, is there an easier way to quickly delete the unneeded fields rather than manually deleting the fields one at a time?
Thank you very much ! Phil