Forums

Hello,

I saw the tutorial "How to load one row from a DB table into your form". A very basic question - can I use that method to edit a record or do I need to use Chronoconnectivity. Secondly if the former works then how do I get a particular record to show up. Do I have to create another form to take key input like a membership number etc and then fetch that record using the URL method.

Thanks
Amal

Hi Amal,

can I use that method to edit a record

Yes, you get the record using whatever identifier you included when it was saved . . . could be a user ID, an invoice number, a record ID . . . it depends on what your form does and how you have designed it.

You don't have to use a URL, you can use another form and ChronoForms will read the posted values. But you can use a URL if that helps.

Bob

Greyhead,

Thanks for your prompt reply. Kindly elaborate as I am still not clear about how to do it.

You don't have to use a URL, you can use another form and ChronoForms will read the posted values.

I will create another form with just the key (any of UserId/InvoiceNo/RecordId) as you mentioned, take that input from user and then you want me to call the main form with a parameter or something. How do I invoke that form?

Thanks
Amal

Hi Amal,

I'm not sure exactly what you are trying to do here. There are several ways to pass values from one place to another, which is the best to use depends on how you want your form to behave.

Bob

I might have confused you. I am trying to do a basic thing - I just want to call my main form and want it to load a single record which I can edit. I have prepared a Query form which has a single field, viz. my key (Membership #). Your tutorial talks about retrieving a single record by giving a "token". How do I do that using the query form. I don't see any option to give a parameter on submit of my query form. How do I invoke my form with a "token" as given in your tutorial.

Regards
Amal

Hello,

I hope Greyhead/Somebody can reply to my last query. How do I call my form with a parameter from another chronoform. Like in the tutorial "How to load one row from a DB table into your form" using a "Request Param" called token.

Thanks
Amal

Hi Amal,

If you have a column 'membership_no' in the table, put this into the DB Field Column of a DB Record Loader action.

Set the Table to the name of the database table.

If you have a previous form with an input called say m_no with the membership number in it then put m_no in the Request Param box of the DB Record Loader action. This will work if the first form is set to submit to, or to pass data to, the second form.

Bob