Hello JONIEC,

Thank you for reaching out to us.

Unfortunately, currently, this feature is not built-in in Amelia. Amelia is not designed for that. What you can do is you can create page for your employees and for each employee you can show the booking form that will contain services only for that employee. This you can achieve with our shortcodes like this for example

1. [ameliastepbooking employee=1] if you want to show the booking form for the employee with ID 1,

Hope this helps.

If you have any more questions please open a new separate ticket for each question and we will gladly help you there.

We wish you all the best.

Have a nice day. 

Hello JONIEC,

I will check this with my colleagues from WPDT team and I or them will contact you as soon as we have more information. 

Hello, JONIEC.

Yes. You can use wpDataTables to pull a custom SQL Query from your WordPress database to pull data from Amelia.

For example, if we would simply pull all the data about employees, such as name, id, small version of their picture ( thumbnail), and full version of their picture,

we would do an SQL Query like :

SELECT * FROM `wp_amelia_users` WHERE `type`= 'provider';

This Query will pull all the columns with data from the amelia users table.

Here is a dummy example from my localhost database where i have some dummy Employees.

All the information about all Amelia users ( customers, Employees, and Amelia Managers) are stored in database table named 'wp_amelia_users'.  ( wp_ is the default WordPress Database table prefix, but on your site it might be different, like "yourSitePrefix_amelia_users".

Then, first try in your PHPMyAdmin to pull the data you need as a test.

And then in wpDataTables you will be able to create a custom SQL Query to pull all the data you need.

Now, the image files are being stored in the WordPress Media library,  

and in the database table for Amelia users ( including employees) it is saving links as path to these images,

the full size of image is in column 'pictureFullPath'  and the thumbnail is in 'pictureThumbPath'.

So, it depends how you wish to present the images on your WordPress page.

-

If you want to make a custom designed WP Page, with details about employees,  without having a table format like this,

then you an use our Single Cell Shortcode feature - this can allow you to position the Employee details anywhere on the page, one cell from the table at a time.

Please check out more about making SQL Query-based tables here;

and here about using our Single Cell Shortcode.

-

If you wish to make a tabular display, and if you want to have a column that shows the thumbnail of the employee's  image,  then when a user clicks in the image, to load the full sized image,

you have to use an Image column. ( Check the rendering rules here)

for that you will have to use SQL CONCAT function in order to "join"/"merge" data from two image columns into one column to have the image thumbnail and full image both in same column cells.

Please check how to use CONCAT in our plugin on this Video.

-

Please note: Using this plugin feature requires at least a basic knowledge of SQL. It is assumed that you can create the table in some MySQL data manager (e.g., PHPMyAdmin, MySQL Workbench), and prepare a SQL query that will return the data you need. If you do not know how to use MySQL, refer to the “Create a MySQL-query-based table by generating a query to MySQL database” section. It will explain how to create complete tables or MySQL queries without this basic knowledge. Please be advised that preparing MySQL queries for you is not included in the plugin support.

-

And i just wanted to point out that you can try wpDataTables before purchasing

 on our sandbox Demo sites ( you can find links for the main plugin Demo,  

as well as add-on Demos, in my signature),

and there is a 15-day money-back guarantee period, 

so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)

Let me know if you have any additional questions.