Split data of enum list in separate rows

[Sameer_Rane]

Hello Everyone,
In my app Executive gets an option in the form to select multiple customers they need to visit as this data gets saved in the table with separated by coma eg: customer1, customer2, customer3.
but I want this data to be get saved in separate row one after the other following with all the details such as date, Location, etc which is entered by Executive while filling the form.
date, Location, etc these details should also be copied for every selected customer.

kindly suggest me with the solution with code.
Thanks

[tony1]

Hi @Sameer_Rane. You should use references between tables to do this. https://help.appsheet.com/data/references/references-between-tables

Here’s an example app that shows how to do this:

[Sameer_Rane]

@tony If I use a nested form then the executive to have to select the customer again and again. I’m giving them Drop Down list of customer using type (Enumlist) where he can select multiple customers at a time but in the database I want this data to be get saved in separate row one after the other following with all the same details such as date, Location, etc.

[Aleksi]

I’m afraid you are not able to do that directly at this moment. It’s in development phase but not ready yet.

[Charlie_T]

What’s the ETA for this? Thx

[Aleksi]

Please check this one if it could help you to build that functionality…

New Action: Add a Row to a table Announcements

We just added an initial version of a new action ‘Data: add a new row to another table using values from this row’ Please try it and give us feedback. Documentation, etc coming later this week. The brief version is here: let’s consider an example with Orders and OrderDetails as two related tables in an app. Add an action ‘CreateChildRow’ to the Orders table that will add a row to the OrderDetails table. You can specify expressions to assign to each column of this row. For example: Order = [O…

[Rifad]

Hi, This is just for adding single row. How to add multilpe rows from enum list ?

[Aleksi]

Please check the sample app called “NewRecordsFromEnumList” from here how it’s done… https://www.appsheet.com/portfolio/531778