Forums

Forums / Developing Portals / Form Flow Primary Key Error

Form Flow Primary Key Error

3 posts, 0 answered
  1. Elizabeth Orlando
    Elizabeth Orlando avatar
    10 posts
    Registered:
    20 Jan 2023
    03 May 2023
    Link to this post
    On the first two forms of my form flow, it passes the primary key from the record created on the first form without issue, but when creating a child record on the third form, the next form loads with a completely different primary key that can't be found in our database. This only happens on creation, when editing the form the cdm_permitapplicationid usually stays the same. If I use the navigation to skip that node, it keeps the same cdm_permitapplicationid also.

    Example: 
    Forms 1-3 URL
    /brs/brownfields-application?nodeid=6b9EbDUVk9&cdm_permitapplicationid=c8746dce-9532-cef0-90e6-ff8c89b86a32&cdm_environmentalinterest_0=47e54c4a-2f90-91cf-b1f0-2e7e7674fd88

    4th Form URL (loads with different cdm_permitapplicationid, not found in our database)
    /brs/brownfields-application?nodeid=EvqCJeWb3A&cdm_permitapplicationid=a2b2c175-91c5-4092-82ef-d43a125d1a31&cdm_environmentalinterest_0=47e54c4a-2f90-91cf-b1f0-2e7e7674fd88
  2. Tom Pawelec
    Tom Pawelec avatar
    25 posts
    Registered:
    21 Oct 2022
    10 May 2023 in reply to Elizabeth Orlando
    Link to this post
    Hi Elizabeth,

    Verify that the populate method is the same for every form. Also check that "create a new record always" is NOT selected.

    Regards,
    Tom
  3. Elizabeth Orlando
    Elizabeth Orlando avatar
    10 posts
    Registered:
    20 Jan 2023
    19 May 2023
    Link to this post
    I resolved this by setting a static field with the cdm_permitapplicationid value and passing it to the next form in the form flow and this overrode the incorrect value. Still not sure why it's doing this, it's populated the same as other forms and not creating a new record everytime. The id it's passing is invalid and doesn't match anything so it's unclear where it's coming from.
3 posts, 0 answered