Notifications #3 - Post ID 302442

User 458539 Photo


Registered User
1,583 posts

I don't know SQL - what do you suggest?

Thanks
User 187934 Photo


Senior Advisor
20,170 posts

You can use a CSV file also.
Also with there be only one email address associated with each zipcode?
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 458539 Photo


Registered User
1,583 posts

No probably going to divide the city into 4 quadrants and have about 50 zips for each quadrant. So when the prospective client enters an and zip code it will go to the correct email in the quadrant. And can it send all emails to master email for accounting purposes?

Thanks

Byron
User 187934 Photo


Senior Advisor
20,170 posts

I have a simple script working. I think it will give you the needed info and you can build on it. I used an email template from RED for the confirmation page. I used plain text for the emails that get sent to the person assigned to the zip code. The code allows multiple emails for the same zip code. This way if somebody needs to cover for another person. There's also a master email as a BCC.
I've attached the two files i used. My test form made in FB had only an input for a name and a zip code.
I used the Redirect to another ulr option in the form Confirm setting tab. I entered the location of the email_by_zip_processor.php file as an absolute url https://.....
Place the csv in the same location as the email_by_zip_processor.php. The code is setup to have them in the myformname_exported folder. I always export my forms and the remove the _exported off the end. You can do what ever you want, It's only important to know locations.
Start with a simple form and test. We can build on it once you know you have it working.
The email_by_zip_processor.php is commented where you need to enter your input names and email addresses for the host. You shouldn't need to alter anything below line 35 if your inputs in your test form are zipcode and name.
Attachments:
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 458539 Photo


Registered User
1,583 posts

Thanks!!!!

Playing with this -

Byron

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.