11 Replies Latest reply on Jul 19, 2017 5:15 AM by user16691

    Solution to fill in various online forms

    Tom_Droz

      I am looking for feedback from anyone that has had experience in fill out various online forms from data within your Filemaker solution.

       

      Any ideas on how hard this is to do, what plug-in you may have used and how you handle unexpected changes in the form would be greatly appreciated!

       

      Thanks

      Tom

        • 1. Re: Solution to fill in various online forms
          MacTutor

          Most online forms are some form of php submit. In most cases if you know the fields to be submitted you can use TroiURL to submit the data. In most cases it is not too difficult, but every site is deferrent and it doesn't account for issues arrise from captcha or other human present mechanisms used by many forms these days.

           

          Best

          Robert

          • 2. Re: Solution to fill in various online forms
            erolst

            Have a look at the MBS FileMaker plugin from Monkeybread Software. We use it inside a webviewer to synchronize data in the database with entries on the website.

             

            You can query and set values of HTML form elements, and e.g. test for the existence of a form or input with a given ID (oops… make that 'id' ) - besides tons of other functionality.

             

            There is also GET and POST, so I think (from my somewhat limited understanding) that you can also submit form data without an interface.

            • 3. Re: Solution to fill in various online forms
              Tom_Droz

              Thanks for both of the ideas!

               

              My thought was the users would be going to the same page on a regular basis then populating that page with a different FM record data. I was thinking that the user would go to the web page within a webviewer, click a button to see the data populate, then be able to interact with the page to make tweaks or answer a challenge question etc.

               

              Do you have any experience in doing that and do the two plugins above have the ability to do that?

               

              thanks

               

              Tom

              • 4. Re: Solution to fill in various online forms
                erolst

                Tom_Droz wrote:

                 

                My thought was the users would be going to the same page on a regular basis then populating that page with a different FM record data. I was thinking that the user would go to the web page within a webviewer, click a button to see the data populate, then be able to interact with the page to make tweaks or answer a challenge question etc.

                My client is doing exactly that - check out the screen shots. After selecting a model, they can open a Web Viewer which automatically navigates to the model's entry on the agency homepage, either in normal (#1) or admin mode (#2); in admin mode, they can update the website values with those from the database, make adjustments if need be, then click the submit button inside the form to trigger the original submit process. The whole operation can simply be canceled by closing the Web Viewer without clicking Submit. This uses the MBS plugin (and just a small part of it, for that matter).

                Webviewer_form1.png   Webviewer_form2.png

                • 5. Re: Solution to fill in various online forms
                  Tom_Droz

                  erolst

                  That looks like what i need, I just looked at the pricing and it is 1,999 euro or about $2,600, pretty pricey!

                   

                  • 6. Re: Solution to fill in various online forms
                    erolst

                    Tom_Droz wrote:

                     

                    the pricing and it is 1,999 euro or about $2,600, pretty pricey!

                     

                    This is for the unlimited licence. Do you really need that?

                    • 7. Re: Solution to fill in various online forms
                      Tom_Droz

                      erolst

                       

                      I am looking more at MBS.  Just to clarify my previous question, can you tell me if the data can be submitted in to the form without submitting the form?    As I mentioned, after the data from FM populates the form I want the user to review change etc than click on the webpage submit button manually

                       

                      I think you said yes.  Can you point me to nay place that might give a good example of the code for this?

                       

                      Thanks again for your help!

                       

                      Tom

                      • 8. Re: Solution to fill in various online forms
                        erolst

                        The way we implemented this is that you can fiddle around as much as you like, but in order to actually send the data from the from to to server you have to click the "native" submit button; so it's sort of semi-automatic.

                         

                        We just wanted a convenient way to transfer all those bits of data inside their fields without the user having to do it manually. The actual server submission procedure is unchanged, meaning you still have all the server-side validation in place.

                        Can you point me to nay place that might give a good example of the code for this?

                         

                        Not really, because I made this up as I went along. But you can have a look at my script, mybe this will give you some pointers.

                        • 9. Re: Solution to fill in various online forms
                          Tom_Droz

                          Erolst

                           

                          I have been tinkering with MBS, and it seems to be the only plugin out there that does this.  I am still having a problem with a form. 

                           

                          Are you aware of anyway to go to a particular field then tab to the next field, so even if I didnt know the field name I could still place something in it?

                           

                           

                          thanks

                          tom

                          • 10. Re: Solution to fill in various online forms
                            erolst

                            Tom,

                             

                            I guess it depends what you mean by "the next field"; HTML5 introduced the notion of a tab order, so this might help.

                            Also, MBS allows you not only to target forms and fields from FM, but also to have JavaScript code (that you can create on the fly) executed in the Web Viewer.

                            And you could maintain a list (in FM) / an array (with JS) of the relevant input types and use this to lookup and navigate to the “next” field, whatever that may be, and put contents in it.

                             

                            Between all those possibilities, I'd say yes, you can!

                            • 11. Re: Solution to fill in various online forms
                              user16691

                              Dear Tom_Droz,

                               

                              my most simple solution without any other plugin is to use AppleScript.

                               

                              The limit is that it works for MacOsX platform only.