Set value enum in other table while Input other form

[codename-12]

I have problem when create some trigger action that use for update enum column status in table Room data into  "VC" after add data on check in table,  based on the room ID entered in the check-in table

[TeeSee1]

The value of a VC is automatically determined by its App Formula and you cannot set it runtime.

Change it to a regular column and then assign a value to it.

[codename-12]

how we can update data by id on other table? but the column still at enum type

[TeeSee1 · Accepted solution]

Use this method

[codename-12]

Yes, this works, but not just the specific ID that is changed, but the entire data

[codename-12]

thank you, finally I can figure it out