preset field

[Cannone_Cannone]

Hi everyone!!!
I have an entry form, after saving, I reopen the form automatically, but I would like it to automatically insert the employee ID number entered previously. Is it possible to do this?

Thank you

[Trevwiller]

Is the person ID you select the same and consistent or changes depending on training day?

[Marc_Dillon]

Use LOOKUP( MAXROW(...) , .... ) for Initial Value

[Cannone_Cannone]

Hello everyone and thanks for the help, I think I didn't explain myself well.
With the suggested formula, MAX ROW, when I open the new form I don't get the same employee id that I had entered previously.
Employee ID is the unique employee code. Now if I open the form to insert a course for an employee, I have to enter his ID number, insert the course and save the Form. When I reopen the form to insert another course for the same employee I have to always re-enter your Employee ID, I was wondering if it was possible to reopen the form with the ID entered last time.

[Marc_Dillon]

My suggestion remains the same. Perhaps you haven't realized that maxrow has a third argument for additional filtering?

[Cannone_Cannone]

bye thank you
I did it this way but it doesn't give me the result I would like

MAXROW("Training_List", "Employee Id", true)

[Marc_Dillon]

Employee id would not be an appropriate choice as the 2nd argument. You would want rownumber or a creation timestamp or similar. Make sure you review the docs.

[AleksiAlkio]

Do you have a table with email addresses and IDs already in your app?

[Cannone_Cannone]

Hi, yes I have a table called "ORGANIC"

[AleksiAlkio]

Would it be then a better solution to read the app user's ID from that table with the initial value? In that way it would be always correct and you don't even need to show it to the app user.

[Cannone_Cannone]

Hi, unfortunately I haven't solved the problem, when you reopen the form automatically the ID field remains empty and I have to enter it again

[Marc_Dillon]

Ok

[lynchk21]

Try:

Lookup(MAXROW("Training_List", "_RowNumber"),"Training_List","Training_List Key Column", "Employee Id")

Replace Training_List Key Column with appropriate column name