I am trying to loop with actions using the solution in the video below and it works like a charm.
I am trying to adapt it but it freezes when I click Save.
He is using products, I am using dates.
Matt’s Parent Table
VC: [Created Children]
VC: [Remaining to be created] = [EnumList]-[Created Children]
My Parent Table (no VC)
[Last child created]
[Remaining to be created] = [EnumList] - LIST([Last child created])
The flow should be the same but I have better control over [Remaining to be created] and I need this later for a re-loop.
1’st try to get the Date of the last Child created:
VC column in parent table with MAXROW(Child,_RowNumber)
VC column in parent table ref to child table and get the last Date.
The app editor saved fine but when saving the form, the app crashes.
Action on the parent table to set the [Last Date Created] just after the child is created.
Action to update [Remaining] = [EnumList]-LIST([Last Date Created])
The first try was messy but the second one I think it’s fairly clean.
I was sure it will work.
I have checked everything and it only crashes when I do this:
[Remaining] = [EnumList]-LIST([Last Date Created])
Is this a bug?