Forums

I am having a hard time with doing a simple search from a table. All I want is a text box where you put in your "Serial Number", have the form return the one result.
​
I remember simple examples of Chronoforms back in the day, or sample data. Does this exist anymore? If I could see it, I could figure it out🙂

have the form return the one result

How do you want this to work ? 2 pages form where you put the serial on the first page then load the fields on the 2nd ? or you want to list the data somewhere ? or how exactly ?

Your read data action should "Return first result". That's pretty much it.

It's the use of variables that gets me (eg. {var:read_data3.Content.serial_no}, when to use, how to use, where to place etc. I think I am slowly getting it now.
​
What I am trying to do is:
1. Search for item (serial_no)
2. Display it, along with other items in that record
3. If fouund open up other fields to check.
4. Submit these results into new table.

You can add "Read data" action to read the data from the table according to the serial number then use the data into HTML view to display it

if you download the new v7 then it has a demo form for "Articles list", it has a search feature which you can analyze to get your form done, I may also build a demo form for you if you still do not understand the way it works!