Use parameters to reference a different table

[jmiller]

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!

[shengnandou]

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.