Share
ReportHi, I'm having some trouble getting the patch function to work consistently in a particular part of my app. I've used patch many times before without issue, but now it's intermittently leaving fields blank. The fields that do not get updated with data are often, but not always, the same fields. I've confirmed that data in the source fields is present. I've attempted many different versions of the same code and all produce the same result. Hoping someone can see a glaring issue here.
This runs On Success of a form submission.
UpdateContext({ CurrentItem: Self.LastSubmit, editMode: false, newMode: false });
If(Or(Not(GUID(varJHAJob)=Form1_8.LastSubmit.'Job Order'.'Job Order'),newMode),
Set(varJHAJobsite,RecordsGallery1_10.Selected.'Job Order'.Site.Jobsite);
Patch(JHAs,Form1_8.LastSubmit,
{Site:Form1_8.LastSubmit.'Job Order'.Site,
'Hospital Name':LookUp(Jobsites,Jobsite=GUID(varJHAJobsite),'Hospital Name'),
'Hospital Phone':LookUp(Jobsites,Jobsite=GUID(varJHAJobsite),'Hospital Phone'),
'Hospital Directions':LookUp(Jobsites,Jobsite=GUID(varJHAJobsite),'Hospital Directions'),
'Hospital Address':LookUp(Jobsites,Jobsite=GUID(varJHAJobsite),'Hospital Address'),
'Police Department Name':LookUp(Jobsites,Jobsite=GUID(varJHAJobsite),'Police Name'),
'Police Department Phone':LookUp(Jobsites,Jobsite=GUID(varJHAJobsite),'Police Phone'),
'Police Department Address':LookUp(Jobsites,Jobsite=GUID(varJHAJobsite),'Police Address'),
'Fire Department Name':LookUp(Jobsites,Jobsite=GUID(varJHAJobsite),'Fire Name'),
'Fire Department Phone':LookUp(Jobsites,Jobsite=GUID(varJHAJobsite),'Fire Phone'),
'Fire Department Address':LookUp(Jobsites,Jobsite=GUID(varJHAJobsite),'Fire Address'),
'Ambulance Name':LookUp(Jobsites,Jobsite=GUID(varJHAJobsite),'Ambulance Name'),
'Ambulance Phone':LookUp(Jobsites,Jobsite=GUID(varJHAJobsite),'Ambulance Phone'),
'Ambulance Address':LookUp(Jobsites,Jobsite=GUID(varJHAJobsite),'Ambulance Address'),
'Job Number':Form1_8.LastSubmit.'Job Order'.'Job Number',
'Site Number':LookUp(Jobsites,Jobsite=GUID(varJHAJobsite),'Site Number')}));
Set(varJHAJob,"");
Set(varJHAJobsite,"");
Categories:
I have the same question (0)
All responses (
Answers (
529
