I have used the wp table into a wordpress intranet. I want to create a user stamp into the wptable, so when a user adds an entry then their name gets inserted to the table as well. Is there anyway i can do this?
At the moment the user needs to be manually typed.
How about to get values of available users in the wp database. So i would like to create a single value selectbox in the table and this column would then display the available users and so they can just select one of the users from the list of option.
Secondly, there is a need from the company to send email notification to a user that has tagged. So when a new entry has been selected and tagged a user then it will send a notification email to that tagged person. Is there any way i can achieve this? Maybe need to integrate one of your other product to make it work?
To get the list of all available users, and see them when editing a field, you would need to create a separate SQL Query based table, where you would pull all users from wp_users table and then connect the names to the first table using Foreign Keys.
There's no way to send any emails with the built-in features of wpDataTables, and we don't have any add-ons or integrations that would help you with that.
Something like this needs to be done as a custom solution, and unfortunately we do not provide support for custom work.
I have another enquiry, can we allow certain access that only allow specific users (eg userID_1 & userID2) who can only edit/delete entries while the rest of the users (eg userID_3 - userID_10) can only add new entries? Is this possible? Screenshot of the add, edit, delete buttons https://imgur.com/Z9gtQwx
I ran into the same issue... Here's the SQL code I used. Still need to add a column for different services. We also created a Custom field for Address so you'd need to adjust the code, but this should get your started.
SELECT DISTINCT
CONVERT_TZ(ca.bookingStart, '+00:00', '-07:00') as 'BookingStart', cb.status, REPLACE(JSON_EXTRACT(fn.info, '$.firstName'),'"', '') as 'FirstName', REPLACE(JSON_EXTRACT(fn.info, '$.lastName'),'"', '') as 'LastName', REPLACE(JSON_EXTRACT(adr.customFields, '$."2".value'),'"', '') as 'Address' from gef_amelia_appointments as ca INNER JOIN gef_amelia_customer_bookings as cust on ca.Id = cust.appointmentId INNER JOIN gef_amelia_customer_bookings as cb on ca.Id = cb.appointmentId and cust.customerId = cb.customerId INNER JOIN gef_amelia_customer_bookings as adr on ca.Id = adr.appointmentId and cust.customerId = adr.customerId INNER JOIN gef_amelia_customer_bookings as fn on ca.Id = fn.appointmentId and cust.customerId = fn.customerId
Hi there,
I have used the wp table into a wordpress intranet. I want to create a user stamp into the wptable, so when a user adds an entry then their name gets inserted to the table as well. Is there anyway i can do this?
At the moment the user needs to be manually typed.
Thank you for your help,
Prima
Hello Prima
Thank you for your purchase.
You can use one of our placeholders:
%CURRENT_USER_LOGIN% - to display the user's username
%CURRENT_USER_FIRST_NAME% – this placeholder will be replaced with the First Name of currently logged-in user.
%CURRENT_USER_LAST_NAME% – this placeholder will be replaced with the Last Name of currently logged-in user.
You can add a new column to the table, where (in column settings/editing) you will set one of these placeholders as a predefined editing value.
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
Hi Aleksandar,
Thank you for your help. This works good.
How about to get values of available users in the wp database. So i would like to create a single value selectbox in the table and this column would then display the available users and so they can just select one of the users from the list of option.
Secondly, there is a need from the company to send email notification to a user that has tagged. So when a new entry has been selected and tagged a user then it will send a notification email to that tagged person. Is there any way i can achieve this? Maybe need to integrate one of your other product to make it work?
Thank you for your help.
Prima Patrianto
Hi again Prima
To get the list of all available users, and see them when editing a field, you would need to create a separate SQL Query based table, where you would pull all users from wp_users table and then connect the names to the first table using Foreign Keys.
There's no way to send any emails with the built-in features of wpDataTables, and we don't have any add-ons or integrations that would help you with that.
Something like this needs to be done as a custom solution, and unfortunately we do not provide support for custom work.
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
Hi Aleksandar,
Thank you for your reply.
I have another enquiry, can we allow certain access that only allow specific users (eg userID_1 & userID2) who can only edit/delete entries while the rest of the users (eg userID_3 - userID_10) can only add new entries? Is this possible? Screenshot of the add, edit, delete buttons https://imgur.com/Z9gtQwx
Thank you, I appreciate your assistance.
Kind Regards,
Prima
Hi Pima,
I ran into the same issue... Here's the SQL code I used. Still need to add a column for different services. We also created a Custom field for Address so you'd need to adjust the code, but this should get your started.
SELECT DISTINCT
CONVERT_TZ(ca.bookingStart, '+00:00', '-07:00') as 'BookingStart',
cb.status,
REPLACE(JSON_EXTRACT(fn.info, '$.firstName'),'"', '') as 'FirstName',
REPLACE(JSON_EXTRACT(fn.info, '$.lastName'),'"', '') as 'LastName',
REPLACE(JSON_EXTRACT(adr.customFields, '$."2".value'),'"', '') as 'Address'
from gef_amelia_appointments as ca
INNER JOIN gef_amelia_customer_bookings as cust on ca.Id = cust.appointmentId
INNER JOIN gef_amelia_customer_bookings as cb on ca.Id = cb.appointmentId and cust.customerId = cb.customerId
INNER JOIN gef_amelia_customer_bookings as adr on ca.Id = adr.appointmentId and cust.customerId = adr.customerId
INNER JOIN gef_amelia_customer_bookings as fn on ca.Id = fn.appointmentId and cust.customerId = fn.customerId
Hi again Prima
You can only change the table settings, so only a certain user role can edit the table:
This is located in the Editing tab above the table. You cannot choose individual users.
Anthony, thank you for replying to this ticket.
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