This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I have a table with 20 columns, some of them are hiden from the user with a showif. Lets say i want my user to be able to select by himself which columns to have access to, can i create a dropdown in each row so the user can select these columns?
Yes you can do that and the Usersettings is a good solution. You could add an Enumlist field with your column names and then use something like IN(“ColA”,Usersettings(“ShowColumns”)) with the Show? option.
To make it more complicated, lets say i want to have multiple forms. So i have a bunch of location IDs, i want a designated form for each ID. Guessing that is far reaching?
OK, i’m struggling with the first thing, using usersettings.
I have created in usersetings an enum with column name named forms.
what is the expression i should write in the showif?
If you want to choose multi columns in one field, you should use EnumList, not Enum. Then the formula would be IN(“ColA”,Usersettings(“ShowColumns”)). Though you need to use own values and column names.
To conclude
I have created a table with a column of form ID, for each form i assigned a site and a true/false select for column names.
When a user selects a form name there is a showif? That matches the data on my form table.
Thanks for your help as always
LinkedIn
Twitter
