Create separate rows from multiple Enumlist selections in AppSheet Using Loops

[@AcciónSonora-l9j]

Thankyou, you are an excellent teacher, please, keep doing this kind of material

[@AppsheetandMore]

Thank You for watching More to come!

[@muratkaya2357]

Thank You So Muchhh

[@AppsheetandMore]

Welcome 😊

[@Emma-PearlWright]

This was very educative. Looking forward to your next video

[@nanaabenagrant]

Insightful🙏🏾

[@SOBAR_DATS]

Thank you very cool video. Could you please explain the example with several columns? Enumlist that would be great

[@AppsheetandMore]

Great question. That would depend on how the selection of each enumlist is dependent on the other. If you have alot of enumlist that have to be broken down into records in one row then you'd have to relook at your data structure.

[@Raju-q2u]

Thanks for such a wonderful tutorial. What happens, if i update the existing record to have few more enumlist values selected. I tested it, but it is not inserting new rows. It is just looping and updating the first row to have only 1 value. So ultimately, New update is not stored anywhere in the database. Here is my observation on this issue: Instead of start inserting new rows from the bottom, it is trying to recreate new rows from the same old (middle of the table) row number. Please advise

[@AppsheetandMore]

Hello Raju, happy you found the video useful. I'm not clear on your question, can you clarify.

[@rajivkvaishnav]

Brother this works pefectly, but my question is how can I delete rows when I delete the parent , I mean I want to delete all automatically created rows when I delete the parent record

[@AppsheetandMore]

Hi Rajivkvaishnav, Thanks for your comment. To delete all related rows, You need to create an action button that carries out an another action on a set of rows. In the formula section for selecting the affected rows, you create a SELECT formula that selects the ID's of all attendance with the same the ID you want deleted. In the context of this demo that formula would have read SELECT(ATTENDANCE[ID],[REPEAT ID]=[_THISROW].[REPEAT ID]). Hope this helps