Hi All,
I’m building a checklist table to support a moderator setting up and running a workshop. Each task requires some housekeeping automation to happen in the background, which I can implement through a button. However, I need different buttons for each task/ row (e.g. Clear Data, Add Data, Set a Timestamp, Add an Entry, eMail Participants etc) . Is there a (n easy) way to either
place different buttons in each row of a table or
assign an action dynamically to a generic button, by referencing a button name, a formula or similar from another column?
If Yes, you should create different column for each button you want, then use the Concatenate() and the Button() function to put it in the same cell.
Is that clear ?
But in my docs I everywhere go with the direction of @Quentin_Morel to also have different colors and icons and place multiple buttons in column. You can still use “if” to show/not show buttons or simply use the disbaledIf field in the button to gray it out.
Hi Folks
Thanks to @Quentin_Morel and @Daniel_Stieber for the useful input. You both helped me realise that I wasn’t defining my problem correctly What I’m trying to achieve can be mocked up like this:
Obviously I can place whatever I want onto the canvas - not only the button, but tips on usage etc. I can even include interactive controls, allowing the moderator to manage table filtering etc. from afar:
@colm.toolan canvas column is a great way to that, and you can even show the buttons in the table view if you activate “Display preview”. For a multistep process like a workshop, this is most likely the best solution.
But just for the records, it is also possible with the buttons formula, which is helpful if you have 1000s of rows and want to show a button based on a condition - and not manually create a button via canvas column. E.g. I use this in a shared task list, where I the person who is doing the task clicks on “done” and the supervisor clicks on “sign-off”, both in the same column.
Here is an example of how to do this:
@Quentin_Morel yeah, you can not enter a formula as a text in a table and use it as a formula or action somehwere else. You can only do it the way you are aware of: create a column for each button instead of creating a row. In the end its almost the same effort and you can hide the many columns afterwards.