Open URL to a report record to edit from public
I have a form set up that my customers will input their full name and DOB to see if they already have an existing record. If they don't, then a new blank form will open for them to complete a record. However, if they do already have a record for this form, then it will open that record for them to update and then re-submit. These customers will NOT be app users and will access this publicly. I need to update the blue part of the below script so that the report can be accessed publicly. Does anybody know how to do this? Or do I need to completely change my script and do it a different way?
count = 0;
fetchRec = Complete_a_Waiver[Participant_s_Name.first_name == input.Participant_s_Name.first_name && Participant_s_Name.last_name == input.Participant_s_Name.last_name && Participant_s_DOB == input.Participant_s_DOB];
if(fetchRec.count() > 0)
{
openUrl("#Form:Complete_a_Waiver?viewLinkName=Waivers&recLinkID=" + fetchRec.ID + "&zc_NextUrl=#Report:Waivers","same window");
}
else
{
openUrl("https://creatorapp.zohopublic.com.au/laura_shireelite/shire-elite/form-perma/Complete_a_Waiver/qTAuDeuaXbyJOpA59M1nSy1mx6RHqM8hgrAxHkSA38MfTQdpPUuAfOe4NxKZp4EmXxjnQHqO9UtBrFTbuQMyP1AAOPWZ8RJwwEOA","same window");
}