Jump to content
  • 0

Passing non-Table field Parameters via Query String



I want to call a datapage URL with query parameters then have an HTML Block Link "pass through" those parameters via the URL call to my second datapage.

1) Call Tabular Rpt datapage to list (all) items from a table (caspio URL with parameters: WID=User ID, LBE=Email) from CMS (Wix)

     - these are current user id fields and NOT part of a table yet

    - URL (from CMS):  https://caspioacct.caspio.com/dp/appid1?WID=" + userId + '&LBE=' + userEmail  (works fine)

2) Have that Rpt datapage (in Details Page Fields) present an HTML Block with a Link to call a Submission Form datapage to create an entry in a different table (caspio URL with parameters: WID=User ID, LBE=Email, UniqueID=caspio primary key from first table, ItemName=caspio ItemName from first table)

    - https://caspioacct.caspio.com/dp/appid2?WID=HelpMe&LBE=HelpMeAgain!&UniqueID=[@field:TableID]&ItemName=[@field:ItemName]

     - the last two fields are part of the main table and work fine - no problem (works fine)

     - BUT the first two fields are managed externally in the CMS and are not part of Caspio environment (except via URL parameters from the initial call)

Note: I had this junk working with Authentication fields before having the bright idea to move user management to the CMS.    

When I try to add fields to the Link, my only options are Data Source Fields (table) or System Parameters but these are neither at the time of the call. 

I tried adding two "temp" fields to the original table and loading the External parameters but they're empty when I make the call.

I might also be able to create a "temp" table for the fields I need but that seems unnecessary.

Is there anything like a "global" variable I can store something in before I put it in the table? OF course, it needs to be accessible by the second datapage.

Any other workaround approaches from those more experienced?


Please help (and pardon the ramblings of a noob).


Link to comment
Share on other sites

2 answers to this question

Recommended Posts

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.

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.

  • Create New...