Set user columns

[Pedroydzito]

I was trying to create a multiple choice using tiles inline list and actions, but the problem is that I used a spreadsheet tab for the database of choice and wanted to set the user’s column to the database value, but I tried in several ways and I believe that the only way would be if in the SET COLUMNS action had the option “USER”.

[Jeff_Hager]

Drive your tab off of the user sheet, then add an inline list to your choice sheet. Then you should be able to save your selections to the user sheet.

This isn’t an exact example of what you want, but maybe it will give you some ideas.

Reset Multiple Rows At Once

There have been several requests for people to find a way to clear a value in multiple rows. I was thinking about that and came up with a quick example of a way to handle that. Instead of trying to clear a value in an entire column, I realized we could just change one value on a parent column, load it as a single value in our sheet and then compare that parent value to a column that we set or unset for each row. It’s not about clearing an entire column, it’s about making a value in each row n…