Funnel many related output fields...

User 2642607 Photo


Registered User
33 posts

I have created a long & complex form using web form builder and I have now hit an issue that is

more related to how I want to collect the data then any flaw in web form builder.

Here's the scenario:

I have created a drop down where a user can choose any Chinese province from the list (there

are 34).

After select a province 2 more boxes appear (districts and postcodes) depending which province

you choose.

For example; Guandong will open a drop down containing all its districts and a number field

containing the range of zipcodes for this province (510000 ­ 529999).

Beijing will open a drop down containing all its districts and a number field containing its range of

zipcodes (100000 ­ 109999).

And so on for each province.....

This results in generating 1 field key for the provinces (this shows as 1 column in MySql), but, it

also generates 34 field keys for the districts (1 district for each province) and 34 field keys for

each range of zipcodes related to each of the 34 provinces.

This means 68 columns to collect data for what is essentially 2 fields; district & zipcode.

There is a lot of other data stored but my issue is only related to the two sets of 34 field keys

mentioned above.

I can display all the collected data in an html table apart from the selected district and selected

zipcode.

What I would actually like to do is create the same 'name' for all the districts and zipcodes so

whichever one is chosen it would only be stored in 1 column in MySql (1 district column & 1

zipcode column).

Unfortunately web form builder does not allow this so I had to name them ; district1,

district2......district34; zipcode1.....zipcode34

They all must have unique names.

I am prepared to leave them this way in the saved web form builder but I want to change the php

output files (after export).

Can anyone inform me which php files this output data is displayed in?

I want to change all 34 of these 'district1.....district34' to one field key 'district'.

I want to change all 34 of these 'zipcode1.....zipcode34' to one field key 'zipcode'.

I'm sure something can be done to achieve my desired outcome, but i'm unsure if some of the 33

empty fields will overwrite the 1 field carrying data.

Has anyone successfully done anything like this before?
User 187934 Photo


Senior Advisor
20,181 posts

Use some jquery or pure to populate a field for storage and manipulation later.
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 2642607 Photo


Registered User
33 posts

Eric Rohloff wrote:
Use some jquery or pure to populate a field for storage and manipulation later.


Hi Eric,

Could you expand a little on your suggestion?

Is it possible to use jquery to check 34 fields and select the one that carries data for showing in a table and ignore the 33 blank fields?
Apologies about the layout of the original question, I cannot see a way of editing it to make it more readable :D
User 2642607 Photo


Registered User
33 posts

Just opening up the php forms I can see that form.cfg.php carries that data that I assume will populate MySql.

Does anyone know if this is the file to edit the data that will go into the MySql fields?
Is there another file that needs editing that I may have missed?
User 187934 Photo


Senior Advisor
20,181 posts

Is this what our looking for?
http://progrower.coffeecup.com/forms/dr … er-fields/
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 2642607 Photo


Registered User
33 posts

I've got that part sorted, link below try click on a province then 2 new boxes open, 1 is a drop down list of 34 districts that is different for every province and a number field that carries a pre-selected different range of 34 zipcodes representing each province.

http://bit.ly/1BYOLyn

(sorry, above link not working, try c&p)

The issue I am trying to solve is how to display the collected data, namely the district & zipcode selected.
Because of a request to create a form in this manner I now have 34 districts fields in MySql & 34 zipcode fields in MySql whereas every time the form is filled in there are 33 empty fields in both district & zipcode fields.

Districts have field keys named in this format district1, district2......district34
Zipcodes have field keys named in this format zipcode1.....zipcode33, zipcode34

What I'm looking to do is; After export the form, I want to edit the form.cfg.php file so all 34 district fields send data to 1 field named 'district'.....and edit the form.cfg.php file so all 34 zipcode fields send data to 1 field named 'zipcode'.

This site is not launched yet, so I have time to play around with the code, it's just i'm currently scratching my head trying to figure out what to try to edit.

fyi.......I have all the data displaying nicely in a table apart from the district & zipcode fields, this will be my mini project this weekend :rolleyes:
User 187934 Photo


Senior Advisor
20,181 posts

Don't display the empty fields.;)
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

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.