Hey Folks,

It seems like I have successfully connected Webform with a FileMaker Pro DB. Server Name, Database Name, Layout, Username, and Password all seems to be correct. When I fill out the form it will create a new record however I can only map a couple of fields.

I believe the client has set up their FMP database to have multiple tables within the one layout. So the First Name field is mapped to "CNTCT::Name_First" (successfully) while the Address is mapped to "cntct_ADDR::Street" (unsuccessfully). So one table is "CNTCT" and the other is "cntct_ADDR".

When I have the First Name field mapped (CNTCT::Name_First) and nothing else it works fine but when I map another field to another table (cntct_ADDR::Street) no record is created and no fields are mapped.

The form in question:
www.cordonline.com/contact/join-now

I'm running:
Drupal 6.25
Webform 6.x-3.16
Filemaker Form 6.x-1.0

I know this is really confusing and I apologize. All of this is very new to me so any help would be appreciated. Let me know if there needs to be any more info given.

Comments

flamingvan’s picture

flamingvan commented

Hi jeffglen -- that's not confusing at all.
Unfortunately, this is simply a limitation of the module. It'll only create one record in one table.
I recommend that you use this module to enter all the data into a single table and then trigger an FM script to create whatever records are necessary and transfer the data to the appropriate fields.
Will that work for you?

jeffglenn’s picture

jeffglenn commented

Great, thanks so much for the fast feedback! We will definitely work something out. Thanks for the work you've done!

flamingvan’s picture

flamingvan commented
Status: Active » Closed (works as designed)