Hi All,
I have an app whith 3 fields, two of them are to search for record in the library (date and start time) and the 3rd for a number (text input) to update all the records found with the first two fields,
i have tried - Patch(GritDriverDetails,LookUp(GritDriverDetails,Date=DataCardValue11.SelectedDate And StartTime=DataCardValue12.Text),{ConfirmNumber:DataCardValue13.Text}) - but this only updates one record, how do i update all records with the same date and start time with one click.
Any help would much appreciated,
Thanks in advance
Ed
UpdateIf(GritDriverDetails, Date = DataCardValue11.SelectedDate and StartTime = DateCardValue12.Text, {ConfirmNumber: DateCardValue13.Text})
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.