best way to add multiple child records from an enumlist of parent

[Muhammad_Salooj]

Hi community,

I've wondering if there's a way  to add multiple child records to a child table TASKS from an enumlist [TASKS] column of parent table PROJECTS using an api webhook.

I've looked at some sample apps but they don't seem to be working, the tasks are random and I'm trying to simplify the user experience for the users.

Generally the tasks are made by someone sending a WhatsApp message with all faults on vehicles, 
So I've made a quick edit column to paste the message, and then suggest it by SPLIT and Concatenate it into list items in the Enumlist column [TASKS] on the PROJECT table. 

When the user selects the suggested tasks in the Enumlist column, I want to create tasks for that project TABLE automatically so that they don't have to individually copy and paste each task line item in the ref TASKS table.

@dbaum @MultiTech @GreenFlux 

[dbaum]

Maybe one of the techniques in the  Looping with actions - Google Cloud Community  tip's sample app is what you need. See, for example, the "Add from List" action.

[Muhammad_Salooj]

thank you, I was hoping to speed up execution when i have to do it in bulk so was hoping to use the API . 

[dbaum]

You should be able to do that. Have you tried? What problem are you encountering that led you to seek a sample app as a model? Do you have a question about the help documentation re Manage apps using the AppSheet API - AppSheet Help?

[MultiTech]

If you're interested in how you could accomplish this in-app, without the API, you can find the basics of how to get things working in my "Blueprint Tables" sample app

• Sample App
• Setup video

----------------------------------------------------------------------------------------------------------------

You could also find similar functionality inside my Join Table Many-to-Many references sample app - it uses the same principles from the blueprint table to create the join table records.

[Muhammad_Salooj]

thanks Matt, I've watched them, awesome content, I was hoping to speed up execution when i have to do it in bulk so was hoping to use the API .

[MultiTech]

---

@Muhammad_Salooj wrote:

thank you, I was hoping to speed up execution when i have to do it in bulk so was hoping to use the API

---

Further in the video, I show how you can change the setup to use automation to make the updates

• This happen in parallel, making use of your license's degree of parallelism, massively speeding up the process

Basically... this is essentially the same thing as running through the API

• Running on the API:
  • runs on the server
  • executes actions you've created
    
    
• Running through Automation
  • runs on the server
  • executes actions you've created

They're basically the same thing

• Automation is "setup" using the GUI of AppSheet
• API is "setup" using code

The API, though, will allow you to do other things WITHOUT the need to setup a corresponding action first - that would be the it's partial edge

[cikguhelmi]

the fastest way i used to split column is using appscript in google sheet

https://docs.google.com/spreadsheets/d/1T35WruF4JrX4QnfBAeLJ03RxWEnVrKVvo68Jij6Gp8Q/edit?usp=sharing