Can Make.com interact with “Option Set” columns in MyTable during data insertion?

Need help Database
1

Hi everyone,

I’m working on integrating my app’s backend with Make.com, and I have a quick question about handling Option Set fields when inserting new rows.

For example, I have a table called User which includes a column user_role. This column is an Option Set with predefined roles like:

  • admin
  • subadmin
  • manager

When inserting a new row into the User table via Make.com, is it possible to set the user_role field using one of these predefined options? If so, what is the correct way to format or reference the value in Make.com so that it matches the Option Set?

Any guidance or examples would be greatly appreciated!

Thanks in advance :blush:

2

I’ve not tested, but it shouldn’t be a problem. This is normally set using the display value. However, if you have modified the display value, you may need to use the original display value.