Funnel many related output fields...
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?
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?
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
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
Eric Rohloff wrote:
Use some jquery or pure to populate a field for storage and manipulation later.
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
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?
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?
Is this what our looking for?
http://progrower.coffeecup.com/forms/dr … er-fields/
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
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
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
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
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
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.