I'm wondering how to store and search the contents of a set of variables in one record

[bonsai]

I'm going to create a record in a custom table using the catalog item below.
I'll use a flow to create the record, read the catalog variables, and set the field values.

I'm still figuring out how to set the variable set in the field.

My requirement is to be able to search the contents of the variable set from the list screen.

*I want to use the date and time field as is.

Does anyone have any good ideas?

[Tanushree Maiti]

Hi @bonsai 

These are the  tables where sc_cat_item submitted variables are stored :

sc_item_option
sc_item_option_mtom
sc_multi_row_question_answer

MRVS variable , from list view - you can search.

If Under MRVS variable ( as highlighted by yellow) - you are looking for search option , it is not supported feature. 

Why not your are searching the data in the existing table itself.

[Ankur Bawiskar]

@bonsai 

so you want to grab data within MRVS and then set

It's not straight forward

How many records you will create in that custom table?

Are you saying if MRVS has 3 rows then 3 records will be created and each of the respective record the start, end etc will be fetched from that row?

If yes then check this gif, I also attached in post. It iterates rows in MRVS and create catalog task, see and enhance

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏