Auto populate/update choice list of a choice field in a table with new incoming values

[Dheeraj Pology]

I have a table into which data is pushed from an external source using table API. I have to manually update the choice list of product category (choice field) before pushing a record with new category name. Or else the new value will be blank for that record. How can i automatically update the choice list if there are new unique values for choice field in the incoming data?

[Mike_R]

Are you using a staging table & transform map or is it a POST request directly to the table?

With a staging table & transform map you can configure it to create a new choice in the list if it doesn't exist.

[H_9 · Accepted solution]

Hi Dheeraj,

To achieve this requirement, you should create a staging table and should use the table api on the staging table.

Then you can create a transform map, which will transfer the records from staging table to the target table.

In the field mapping of the transform map you can configure to create the new choices.

[Dheeraj Pology]

👍Thanks. Is it possible to set the transform map to run automatically for real-time data?

[H_9]

Yes, the transform map runs automatically once you insert or update the data in the staging table for every realtime inserted/updated record.

Please mark the answer correct if it helps. 🙂