Forums

Issue with record ids on nested 1 to many relationships Cancel The title field is required!

1. Chaya Shack

   

   2 posts
   Registered:
   21 Jun 2023
   21 Jun 2023

   Link to this post

   I have a node on my form flow that creates related records using nested 1 to many relationships. I have an invoice table embedded on the parent record and then invoice line items embedded inline on the invoice. After submitting the page, the records get created with the correct relationships in Dynamics however, the invoice line item id gets used as the invoice id in the query string. I then get an error in the error logs saying the invoice with that id does not exist as I am trying to load/display the created invoice in a subsequent form flow step. Does anyone have any ideas on what the issue might be? 
2. Eric Mann

   

   59 posts
   Registered:
   16 Oct 2020
   21 Jun 2023 in reply to Chaya Shack

   Link to this post

   Chaya - I'd look at encrypted GUID vs non-encrypted GUID.  
3. Rawdon Edghill

   

   76 posts
   Registered:
   16 Dec 2020
   22 Jun 2023

   Link to this post

   Hi Chaya,
   
   As Eric mentioned about the encrypted GUID vs non-encrypted GUID you can check to make sure the Encrypted GUIDS match for both forms.
   This can be found in Advanced - Model - EncryptGUID (should be set to true or false).
   
   Can you check to see if the second form is properly set to load information by "Default", or using the correct parameter in the query string.
   
   Also you might want to check the properties settings for the FormFlow this can be found in the FormFlow Designer to make sure that you have the:
   1st option - Pass Created Record IDs to Next Page is selected
   2nd option - Pass First Created Record Only is selected.
   
   I hope this information is helpful.
   
   Regards,
   Rawdon
   
4. Chaya Shack

   

   2 posts
   Registered:
   21 Jun 2023
   22 Jun 2023 in reply to Rawdon Edghill

   Link to this post

   Thanks for your response. I tried having the form load by default and with the parameter in the query string. I got the same issue with both. I also tried with both the 1st and 2nd options checked on the FormFlow designer and tried with them them unchecked. 
   
   When I remove the nested invoice line item, there is no invoice id in the query string. When I add the invoice line item back on the form, I get the invoice id in the query string but referencing the line item id. 
5. Rawdon Edghill

   

   76 posts
   Registered:
   16 Dec 2020
   22 Jun 2023

   Link to this post

   Hi Chaya,
   
   I am sorry to hear it is still not working for you.
   
   I would recommend you to reach out to tpcsupport@sylogist.com to create a case so that a developer can work with you one on one.
   
   Regards,
   Rawdon