Jump to content
  • 0

How to receive ID from "On exit, pass ID and formula fields as parameters" checkbox


Question

I have a submission form datapage with the checkbox "On exit, pass ID and formula fields as parameters" checked.

On exit, the datapage redirects to a separate datapage with a report with edit capabilities.

Each datapage is based on separate tables so simply put, I want to stamp the primary key from the first table as a foreign key in the 2nd table.

My problem is, how do I receive the ID (primary key) in the 2nd datapage. 

I am pretty sure this should be configured as an external parameter but how do I format the value so that it inserts the ID from the first table? I can't select the ID anywhere in the datapages.

 

 

2021-03-29_12-18.png

2021-03-29_12-24.png

Link to post
Share on other sites

3 answers to this question

Recommended Posts

  • 0

Hello @hctrr,

What you currently have in the configuration is already correct. You just need to add 'InsertRecord' prefix in your Parameter Name since you are receiving an ID. It should be [@InsertRecordTransaction_Id]. For more details, you may refer to this article: https://howto.caspio.com/parameters/passing-parameters/

 

Hope this helps!

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...