Create separate rows from multiple Enumlist selections in AppSheet Using Loops

[@mohdzamreeabdul3935]

Very good knowledge sharing. Thank you very much

[@edrol2008]

Really good teacher. Thank you🙂

[@tiniesani5642]

I love the way you explained everything. Very easy to understand. Thanks for sharing.

[@Emma-PearlWright]

This was very educative. Looking forward to your next video

[@AcciónSonora-l9j]

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

[@AppsheetandMore]

Thank You for watching More to come!

[@nanaabenagrant]

Insightful🙏🏾

[@muratkaya2357]

Thank You So Muchhh

[@AppsheetandMore]

Welcome 😊

[@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.

[@fikrimeiyanto7285]

hello gus, help, how if have start number and end number , how to implentasion using loops for create separate row. thanks

[@AppsheetandMore]

Great question. In this case instead of counting the number of items in the enumlist. You simply use the difference between start number and end number. Everything else is basically the same. Hope this helps.

[@dennyxhalim]

thank you for great sharing. what about if i have more than 1 enumlist to separate, for example i have product name ABC123 have colour variant BLACK, BLUE, RED (and more) also have size variant 35, 36, 37, 38 (and more) can you please help me. thanks again

[@AppsheetandMore]

Thanks for watching. So long as the number of items in the Enumlist are the same and they match 1:1. You can use the same formula and it should work.

[@dennyxhalim]

@ thank you for your reply, i will try. Thanks again

[@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