OK so we need to collect the address from the user as the services booked happen at the clients homes. So on our forms we collect address, city, postal codes etc. The issue I'm finding is that those details don't then end up in the users WP user profile. In fact they don't end up in the customer profile either... the fields just live solely on the appointment which isn't very useful when we want to look at a users account later for address or any pertinent details. How can I sync the data collected in the form to the users profile within WP? Could the webhooks be used to send this data to say zapier then send over to WP users tables? I just don't want the user to have to fill in this information the next time they come back in to book & I need it there for WooCommerce orders... thoughts?
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
The address, city, postal code, etc isn't a part of Amelia, and those can only be added as custom fields at the end of the form. However, they are variables, and are not linked to the person that is booking an appointment. You would need to require those as custom fields, so your customers enter the data, but then you would need to manually enter that info into the WP User.
Perhaps there's a way to use webhooks to pull the data from custom fields, into Zapier and back into WP User details, but we've never done that, so I can't say for sure.
OK I'm very familiar with Zapier & want to try to make this work as its pretty crucial to the way we need to use the system. Do you have any documentation on using Zapier to grab the custom field data? I know how to activate user sync in Zapier once I get the data in there. Just need clarity on how I grab the custom fields & send to zapier. Does Zapier recognize Amelia as a integration?
We haven't had the chance to create specific documentation examples for the web hooks, so everything we currently have on them is located on this page.
Please take a look, and hopefully that will help you out.
thanks i'll check it out, actually got it flowing a bit this morning. the webhooks send the data to zapier, i'm mapping to mysql because there isn't a way to do users via wordpress zap...but i suspect this will work via mysql update the users when address etc. comes through the booking form. will let you know how it works out!
The major roadblock in this is the wp_users table doesn't actually hold the addresses... they are stored in usermeta table which has them organized by ids not rows... I think actually this makes it impossible via Zapier which is very depressing after getting this far... Need to sort a way to make this work just not sure how now...
I've never dived into it that deep, but I'll try to help.
If you know your way around SQL, you can extract the data you need in columns, using SQL Views (stored queries), which will return the data that you need.
You would need to extract the data you need from rows in wp_users into columns in the view. Then, you can reference the view instead of wp_users through Zapier, and it should work. Views are dynamic, meaning changes in the source tables will be referenced in the view also, so there shouldn't be much issues with that.
OK so we need to collect the address from the user as the services booked happen at the clients homes. So on our forms we collect address, city, postal codes etc. The issue I'm finding is that those details don't then end up in the users WP user profile. In fact they don't end up in the customer profile either... the fields just live solely on the appointment which isn't very useful when we want to look at a users account later for address or any pertinent details. How can I sync the data collected in the form to the users profile within WP? Could the webhooks be used to send this data to say zapier then send over to WP users tables? I just don't want the user to have to fill in this information the next time they come back in to book & I need it there for WooCommerce orders... thoughts?
Hello Seth
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
The address, city, postal code, etc isn't a part of Amelia, and those can only be added as custom fields at the end of the form. However, they are variables, and are not linked to the person that is booking an appointment. You would need to require those as custom fields, so your customers enter the data, but then you would need to manually enter that info into the WP User.
Perhaps there's a way to use webhooks to pull the data from custom fields, into Zapier and back into WP User details, but we've never done that, so I can't say for sure.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
OK I'm very familiar with Zapier & want to try to make this work as its pretty crucial to the way we need to use the system. Do you have any documentation on using Zapier to grab the custom field data? I know how to activate user sync in Zapier once I get the data in there. Just need clarity on how I grab the custom fields & send to zapier. Does Zapier recognize Amelia as a integration?
We haven't had the chance to create specific documentation examples for the web hooks, so everything we currently have on them is located on this page.
Please take a look, and hopefully that will help you out.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
thanks i'll check it out, actually got it flowing a bit this morning. the webhooks send the data to zapier, i'm mapping to mysql because there isn't a way to do users via wordpress zap...but i suspect this will work via mysql update the users when address etc. comes through the booking form. will let you know how it works out!
The major roadblock in this is the wp_users table doesn't actually hold the addresses... they are stored in usermeta table which has them organized by ids not rows... I think actually this makes it impossible via Zapier which is very depressing after getting this far... Need to sort a way to make this work just not sure how now...
Hi again Seth
I've never dived into it that deep, but I'll try to help.
If you know your way around SQL, you can extract the data you need in columns, using SQL Views (stored queries), which will return the data that you need.
You would need to extract the data you need from rows in wp_users into columns in the view. Then, you can reference the view instead of wp_users through Zapier, and it should work. Views are dynamic, meaning changes in the source tables will be referenced in the view also, so there shouldn't be much issues with that.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables