Is it possible to have a date set in one column then have a formula column add 21 days and show the date in that formula column? If so what is the setup for that?
Please note that our working hours are Mon - Fri from 09:00 - 17:00 CET. Currently, there are a lot of tickets coming in, so response time is slower than usual. Thank you for your understanding.
Unfortunately, formula columns can only handle Integer and Float columns. Anything else other than that will be parsed as "0".
What you're trying to do could possibly be done with SQL query, but please note that preparing SQL queries for you is not included in the plugin support.
What I can do is give you some advice on the matter. Please take a look here, and you may be able to find the proper SQL query that'd do what you want to do.
Thank you for the feedback. Is this something that can be done using a manual table or does it have to be strictly a mysql database? Just trying to figure out if it's a viable option before diving into it too deep.
Unfortunately, this would have to be done through a query, and cannot be done with a manual table.
You would need to add a new column which would calculate this dynamically, and display that in the table. Probably you'll need to create a view, so the data is dynamically displayed in wpDataTables.
Is it possible to have a date set in one column then have a formula column add 21 days and show the date in that formula column? If so what is the setup for that?
Any ideas?
Hello Brandon.
Please note that our working hours are Mon - Fri from 09:00 - 17:00 CET. Currently, there are a lot of tickets coming in, so response time is slower than usual. Thank you for your understanding.
Unfortunately, formula columns can only handle Integer and Float columns. Anything else other than that will be parsed as "0".
What you're trying to do could possibly be done with SQL query, but please note that preparing SQL queries for you is not included in the plugin support.
What I can do is give you some advice on the matter. Please take a look here, and you may be able to find the proper SQL query that'd do what you want to do.
Best regards.
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
Thank you for the feedback. Is this something that can be done using a manual table or does it have to be strictly a mysql database? Just trying to figure out if it's a viable option before diving into it too deep.
Hi again Brandon.
Unfortunately, this would have to be done through a query, and cannot be done with a manual table.
You would need to add a new column which would calculate this dynamically, and display that in the table. Probably you'll need to create a view, so the data is dynamically displayed in wpDataTables.
Best regards.
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
I just got it working via a manual table and using a mysql update process. Thank you for help.
Great news, Brandon.
Thanks for letting me know.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
Best regards.
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