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.
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
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
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.
th-cam.com/video/YlROfIAkvVk/w-d-xo.html&ab_channel=JoeTayactac Hi there, thanks for sharing. I thought your video seem like this one. But when I followed every steps of this one, it not work. Is it because Appsheet updated and this one can not be use anymore?
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
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
Very good knowledge sharing. Thank you very much
I love the way you explained everything. Very easy to understand. Thanks for sharing.
Really good teacher. Thank you🙂
This was very educative. Looking forward to your next video
Thankyou, you are an excellent teacher, please, keep doing this kind of material
Thank You for watching
More to come!
Insightful🙏🏾
Thank you very cool video. Could you please explain the example with several columns? Enumlist that would be great
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.
Thank You So Muchhh
Welcome 😊
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
Hello Raju, happy you found the video useful.
I'm not clear on your question, can you clarify.
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
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.
@ thank you for your reply, i will try. Thanks again
hello gus, help, how if have start number and end number , how to implentasion using loops for create separate row. thanks
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.
th-cam.com/video/YlROfIAkvVk/w-d-xo.html&ab_channel=JoeTayactac
Hi there, thanks for sharing.
I thought your video seem like this one. But when I followed every steps of this one, it not work.
Is it because Appsheet updated and this one can not be use anymore?
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
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