TOPIC:

Thank you so much, this is exactly what I needed. The value is added to the field before the init script runs so everything works now. I appreciate all the help!

Hi, I have one more question. It seems that the php query that you offered does not return the element value for the specific user that is logged in, so I am getting a value back that isn't correct.

Is there a way to query for it in a way like "select <element_name> from <record_table> where username = <username>" ?

Thanks.

I should add that I already have the username stored as an element in the form.

Hi,

something like this:
Hope this helps

Regards,
Tihana

Hi,

This approach does not seem to work and based on how the records are stored in the database I wouldn't expect it to work. It doesn't seem possible to add multiple criteria to the where clause in this case but please clarify if I missed something.

I found this old entry that describes searching through records for specific criteria: crosstec.org/en/forums/3-breezingforms-f...records.html?start=0

I want to be clear because what is described in the thread linked above seems overly complicated for what I'm trying to accomplish.

To summarize, I have users entering information in the multiple-page form. Each time a page is completed, there is an element in that page that gets set to "Complete". When the user logs in next time and the form loads, I want the form to check the last page that was set to "Complete" and navigate to that page.

So far, attempting to get the value of the "Complete" element in the form init script failed because the value is empty during the init process and only populates after the script is complete. In the past I could access the value of the "Complete" element during the init script and this is how I was doing it (I don't know why it no longer works). Is there an easy way to do this that I'm missing?

Thanks.

Hi,

basically, you can add multiple criteria to WHERE with AND.

Maybe I make a mistake with the code, please try it like this:
Please try it like this:
If this won't work, then please check this:
crosstec.org/en/forums/3-breezingforms-f....html?start=0#128489

Hope this helps

Regards,
Tihana