You’re offline. This is a read only version of the page.
38
Having some issues with a save button. Have several formulas on the OnSelect. At the moment this runs correctly once. The first patch runs correctly every time, the second patch runs correctly once.
First patch sends the input information to a second sharepoint list (Dates), second Patch goes to (Employee Names)
Do I even need the SubmitForm with the patches? Should I just patch everything?
This form is updated daily.
Share
ReportPatch(Dates, Defaults(Dates),{Name:Value(DataCardValue12.Text),CheckInDate:Value(DataCardValue15_CheckInDate.SelectedDate),Reason:Value(DataCardValue18_ReasonOut.Selected.Value),SickHoursTaken:Value(DataCardValue1_SickHours.Text),VacationHoursTaken:Value(DataCardValue23_VacationHoursTaken.Text)});SubmitForm(Form2);Set(currentRecord, LookUp('Employee Names', ID = Value(DataCardValue45.Text)));Patch('Employee Names',currentRecord,{SickHoursTaken:Value(DataCardValue1_SickHours.Text), SickAvailableNow:currentRecord.SickAvailableNow - Value(DataCardValue1_SickHours.Text)});Patch('Employee Names',currentRecord,{VacationHoursTaken:Value(DataCardValue23_VacationHoursTaken.Text), VacationAvailable:currentRecord.VacationAvailable - Value(DataCardValue23_VacationHoursTaken.Text)});Notify("Record Saved",NotificationType.Success);
Hi @adyboon ,
You have posted this twice - I have responded on the other post.
Can you please close this one.
All responses (
Answers (
