Here’s the situation -
A manager loads a page with a RG list of staff, which corresponds to a data type ‘staff’. There is a field in that data type called ‘opt-in’ currently set as text so that it can allow three values - Yes / No / Undecided (undecided is important so I’m not using a Yes/No data type).
The ultimate goal is to display an icon in the RG that indicates the Opt-in status, as either a green check (Yes), red x (No), or black circle (Undec.). However, I’d like the manager to be able to click the icon to cycle through these options to change the status - then click a save button on the page to write that updated status back to the table.
My thought is, I can load the existing Opt-in values from the data table as a page list, then use that list to drive the display of the icons; but then allow interactions with the icons to change the list state which can ultimately be written back to the table. Is that a good way to do it? Is there a better way? If this is a decent way to go about it, where I’m struggling is how to set up the list and have it pull the data from the table in order to establish the beginning states for these icons.
Any help would be appreciated - or if you know of a video tutorial that covers this, a link would be great! Thanks!