Hi @Anonymous :
I've made a test but it worked well.
Please try adding a unique identifier "ID" to TripRecord.For Example:
ClearCollect(TripRecord,{Input1:"",Input2:"",Input3:Today(),Input4:Today()})
1\Add a gallery and set it's Items proeprty to(Sort the items displayed in the Gallery in ascending order😞
Sort(TripRecord,ID)
2\Add two drop down controls into this gallery(fromdropdown/Todropdown)
Set fromdropdown:
Items
["","Canada","Mexico","US","UK"]
OnChange
Patch(TripRecord,ThisItem,{Input1:fromdropdown.SelectedText.Value})
Default
ThisItem.Input1
Set Todropdown:
Items
["","Canada","Mexico","US","UK"]
OnChange
Patch(TripRecord,ThisItem,{Input2:Todropdown.SelectedText.Value})
Default
ThisItem.Input2
3\Add two date picker controls into this gallery(Fromdate/Todate)
Set Fromdate
OnChange
Patch(TripRecord,ThisItem,{Input3:Fromdate.SelectedDate})
DefaultDate
ThisItem.Input3
Set Todate
OnChange
Patch(TripRecord,ThisItem,{Input4:todate.SelectedDate})
DefaultDate
ThisItem.Input4
4\Add an "Add" icon and an "Rubbish-bin" icon
Add icon-OnSelect
Patch(TripRecord,Defaults(TripRecord),{ID:Last(Sort(TripRecord,ID)).ID+1,Input1:Todropdown.SelectedText.Value})
Rubbish-bin icon-OnSelect
Remove(TripRecord,ThisItem)
The principle of my solution is:
1: When adding a new item: Use the Todropdown.SelectedText.Value of the current record as the value of the Input1 field of the new record.
2: When displayed, the default value of the To drop-down box of the new item is the value of Input1, so it will display the Todropdown.SelectedText.Value of the previous record by default
Best Regards,
Bof
