+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: Can I link to an external table (/showthread.php?tid=11225)
Can I link to an external table - NorthernPenguin - Jan 17th, 2016
I am using v2.2.6 of Form Tools.
I have created an external form and am using it successfully. My one issue deals with a dropdown menu. The values of the dropdown menu will change from time to time, and I am trying to avoid having to update Form Tools and the HTML form page with the new values.
I was thinking that if I create a table, that can be updated easily by the client, with the list of values for the dropdown, Form Tools would use that table content in the dropdown. I have already converted the form to php, and can easily get the values of the dropdown to display in the form.
My issue is the integration with Form Tools itself.
Any ideas?
RE: Can I link to an external table - alexh - Jan 18th, 2016
It's definitely possible to make a dynamic drop down list on an external firm based on the contents of a different internal form or another database. It will take some programming, and it's not an out of the box solution possible with formtools. Keep in mind that this dynamic drop down box will not show up on your internal version of the form, however the responses submitted by the external form will show up as text.
I hope this makes sense.
Alex
RE: Can I link to an external table - Vinniepanasonic - Jan 20th, 2016
Alex,
I have trouble linking one dropdown field that is linked to an internal form. Pretty simple out-of-the box usage of FT.
When in List-view these fields look OK, which means the dropdown shows the correct value of the dropdown field. This also applies to exports and printer friendly views, but when performing a search on those field only ID numbers can be used to generate content.
Do you have any clues to what could be the problem?
(Jan 18th, 2016, 8:27 AM)alexh Wrote: It's definitely possible to make a dynamic drop down list on an external firm based on the contents of a different internal form or another database. It will take some programming, and it's not an out of the box solution possible with formtools. Keep in mind that this dynamic drop down box will not show up on your internal version of the form, however the responses submitted by the external form will show up as text.
I hope this makes sense.
Alex
RE: Can I link to an external table - NorthernPenguin - Jan 23rd, 2016
(Jan 18th, 2016, 8:27 AM)alexh Wrote: It's definitely possible to make a dynamic drop down list on an external firm based on the contents of a different internal form or another database. It will take some programming, and it's not an out of the box solution possible with formtools. Keep in mind that this dynamic drop down box will not show up on your internal version of the form, however the responses submitted by the external form will show up as text.Alex
I hope this makes sense.
Alex
I have it working partially. I don't understand what you mean by "however the responses submitted by the external form will show up as text".
If i select a value in the dropdown, it will not be displayed either internally or via the email response. At the very least i would like the email to display the response(s).
Any idea?
RE: Can I link to an external table - alexh - Jan 23rd, 2016
I mean if you have a dynamic drop down as a form, you won't be able to make that a drop down on your internal form unless you have all of those options set up as a drop down in your internal form. They will show up as a text field instead.
I hope that makes sense.