How do enums work? / Setting Enum value from other Table.

AppSheet AppSheet Q&A
1

I have two tables, Personnel Table and Personnel Setter Table. First table columns are ‘PersonnelID’(text), ‘PersonnelName’(name) and ‘PersonnelStatus’(enum). Second table columns are ‘ID’(tex), ‘PersonnelToChange’(Ref-EnumList) and ‘StatusTo’(Enum).
What I want to achieve is that when I open up a new form for the second table, I select the Personnel whose status I want to change and select the status I want to change to. After which the new form will values will apply accordingly to the first table, then the values for the second table will be deleted.
I essentially want to emulate a ‘For all selected, change status to’ logic.

2

You use this to pass values from a source table to use in a target table updates.