Purchase order form help - Post ID...

User 2741445 Photo


Registered User
3 posts

I love this Form Builder, trying to figure out somethings though.
The goal is for employees in the field to access the form and get an automated sequential PO number to give our various vendors. The process would be enter password (which should bring up their name) they select which company they work for, select a vendor and the piece of equipment/vehicle it is for and it generates a P.O. Number
I am in the ("Password element" window) I was wondering in the "show element" (Using display rule) I added a condition
( [Employee] is "Bush, Stephen" )
now would I would I type the password in their for him to use or what, kind of stuck. I will also have a question latter on about generating an automated PO if all conditions are met.

Any help would be greatly appreciated. Trying to get this form produced by the New year.

You all have a Merry Christmas!!!!!!!! And thanks!
Attachments:
User 187934 Photo


Senior Advisor
20,190 posts

I would think using some mysql scripts tied to your form would work.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2741445 Photo


Registered User
3 posts

Thank you. However, I know very little about coding. I'll forgo all the other questions except this, as it is the main one. How do I get the number element to generate a sequential number that once generated is no longer a valid number? Or is that going to be a regular expression which I am also lost on. Or is this still going to be an MySql string?
User 187934 Photo


Senior Advisor
20,190 posts

The sequential number will have to come from some kind of existing data. I would do a mysql query looking up the last number submitted and then indexing the new one the required amount.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2741445 Photo


Registered User
3 posts

Thanks Eric, all I have is an excel spread sheet, no database. I have access, I guess I'll mess with it and see what I can produce from that, though I maybe wasting my time with it.

Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.