Use another form submissions data as data source for login vefication

I am currently working on a project that involves three forms: Register, Login, and Order. I have been exploring Jotform's capabilities and have a specific requirement that I would like to inquire about regarding automated prefills and redirections.

1. Login Form: The Login form contains a single input field for the user's email. Upon successful login, I would like to automatically redirect the user to the Order form, passing the email as a parameter in the URL.
2. Order Form: The Order form should be prefilled with a specific user's information based on the email passed in the URL parameter. This prefilled information should be retrieved from a record in the Register table (submission) that matches the provided email.

I have been able to manually generate prefills with links, but I am looking for a more automated solution. Is it possible to achieve this functionality within Jotform? If so, could you please provide guidance on how to set it up?

registration form: https://form.jotform.com/241659246757065

login form: https://form.jotform.com/241658635920058

order form: https://form.jotform.com/241658966769278

Hi Joseph,

Thanks for reaching out to JotForm Support. Unfortunately, it's not possible to dynamically pull records from your Registration Table on your Login form. The closest we can offer is through the Spreadsheet to form widget, keep in mind, however, that the source will be static so you'll need to replace the Excel file with an updated one from time to time. If this works for you, we have a guide to do that here.

I've gone ahead and escalated the idea of using another form of submissions as login source to our developers, but when or if it's developed depends on their workload, how viable it is, and how many other users also request it. If there are any updates, we’ll circle back to this thread and let you know.

Thanks for your patience and understanding, we appreciate it.