Jump to content
  • 0

Use parameters to reference a different table


Question

I would like to use parameters to reference a different table other than the one that is associated with a data page. How can I do this?

For example:

Table 1 -> List of events

Table 2 -> List of users (username, password, full name, etc.)

Data page A -> Submit a new event

Data page B -> Search and view events

On Data page A, I would like the fields entered to be added to Table 1. But I would also like the form to automatically check Table 2 to see which user is currently logged in, and add their name to a "Submitted by" element in Table 1.

How can I do this? Thanks!

Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Hello,

As I understand you wanted to save the user's information when they are filling in the events submission form. As you mentioned to keep track of who logged in the system, I assume the events submission form is authenticated so users need to login before they get access to the DataPage. And if this is the case, you can simply insert an additional 'submitted_by' field in the events table and pass the user's information from the authentication window to the submit events DataPage.This tutorial teaches you how to pass such a parameter: http://howto.caspio.com/parameters/in-a ... users.html

The only difference is that in your situation, the parameter is received on a regular table field rather than the HTML block.

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...