form with reading from db table

Hello,
I would like to ask you how to set up a "simple" form where user will:

write a number to a text field

then (s)he press a Submit button

and after that a whole line (record), that contains the number, will be listed in the form

Thank you,
JB

Hi JB,

you mean listed on the same page of the form ?

Hello and thank you Max,
it would be nice, to have it on the same page.. Like this example (you can test result with certificate 23/2022):
https://www.cqs.cz/References/
JB

Thank you, Max, we bought the v7 a few months ago and still haven't finished the current web with it so I would appreciate a howto for the v7, please.
JB

Your key should work for v8 too, it's recommended to use v8, it's faster and better

Hello,
I had to upgrade php version to 8.2 on my server and now I will need howto. I've tried it without success.
So, my table has 4 fileds (let's say fi1, fi2, fi3, fi4) and there is nr. in the first one "fi1" (let's say 123/123) and I need to "read" from the first row containing 123/123 the rest of the fields (so fi2, fi3, fi4).
Thank you,
JB

add "Read data" to the "Submit" event, choose the table, set the WHERE conditions to:

fi1 = {data.quote:form_field_name}

or

fi1 = {data.quote123/123}

now the {var:read_data_name.fi2} should have the value of fi2

Thank you, Max,
please check the picture, where is the problem?

Note: I've tried more solutions in the last step, I'm not a programmer, so...
If I try to test the form, there is no error.
Thank you,
JB

The record is found ? (does it trigger the found event?)

I do not know the action's name, it will be shown in the form debug, enable the debug and find the name or set the name using the Wizard Settings behavior.

the latest update shows the action's name in the editor, so you will be able to call it easily.

Or let me know and I can prepare a tutorial on this subject

Hi Max,
finally I try to solve another problem - I can't use php8.2 at this time, because of another system on the server, that doesn't support it (not a easy situation, server is not mine), so unfortunately I would need to have the form for both v7 and also for v8. :-/
Thank you,
JB