NailDyanC

Hi, just to update this post. Caspio has a new article about restricting file uploads: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/restrict-file-types-that-can-be-uploaded-in-a-datapage/

Hi, just to update this post. Caspio has a new article about restricting file uploads: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/restrict-file-types-that-can-be-uploaded-in-a-datapage/

Hi @Woolf, I created a sample workflow that would check if the new date is before or after the current date. Here's my formula(You will be using two calculated fields): CASE WHEN [@calcfield:1] >= (SysDateTime()) THEN 'AFTER' ELSE 'BEFORE' END The "[@calcfield:1] " is the first formula that you have that would determine the new date. Please let me know if that works for you.

Hi @Woolf, just to clarify, you would like to get 14 days before the current date? If yes, then you may use this formula: DATEADD(Day,-14,SysDateTime()) I use SysDateTime() function to get the current date. However, SysDateTime() only works on DataPage level.

Hi, just to update this post. Caspio now launches its New Youtube series(?) I find this very interesting. It is called Caspio Labs. And the Livestream is every Monday! This is a great help for us users of Caspio to learn how to transform Excel data into immersive web dashboards. This also help us level up our Caspio skills with development tips and personal coaching straight from the platform specialist and their technical evangelist. What I also love about this is they always tackle new topic every week. I also suggest to subscribe to their YouTube channel to be automatically notified.

Hi, just to update this post. Caspio now launches its New Youtube series(?) I find this very interesting. It is called Caspio Labs. And the Livestream is every Monday! This is a great help for us users of Caspio to learn how to transform Excel data into immersive web dashboards. This also help us level up our Caspio skills with development tips and personal coaching straight from the platform specialist and their technical evangelist. What I also love about this is they always tackle new topic every week. I also suggest to subscribe to their YouTube channel to be automatically notified.

Hi, just to update this post. Caspio now launches its New Youtube series(?) I find this very interesting. It is called Caspio Labs. And the Livestream is every Monday! This is a great help for us users of Caspio to learn how to transform Excel data into immersive web dashboards. This also help us level up our Caspio skills with development tips and personal coaching straight from the platform specialist and their technical evangelist. What I also love about this is they always tackle new topic every week. I also suggest to subscribe to their YouTube channel to be automatically notified.

Hi, just to update this post. Caspio now launches its New Youtube series(?) I find this very interesting. It is called Caspio Labs. And the Livestream is every Monday! This is a great help for us users of Caspio to learn how to transform Excel data into immersive web dashboards. This also help us level up our Caspio skills with development tips and personal coaching straight from the platform specialist and their technical evangelist. What I also love about this is they always tackle new topic every week. I also suggest to subscribe to their YouTube channel to be automatically notified.

Hi, just to update this post. Caspio now launches its New Youtube series(?) I find this very interesting. It is called Caspio Labs. And the Livestream is every Monday! This is a great help for us users of Caspio to learn how to transform Excel data into immersive web dashboards. This also help us level up our Caspio skills with development tips and personal coaching straight from the platform specialist and their technical evangelist. What I also love about this is they always tackle new topic every week. I also suggest to subscribe to their YouTube channel to be automatically notified.

Hi, just to update this post. Caspio now launches its New Youtube series(?) I find this very interesting. It is called Caspio Labs. And the Livestream is every Monday! This is a great help for us users of Caspio to learn how to transform Excel data into immersive web dashboards. This also help us level up our Caspio skills with development tips and personal coaching straight from the platform specialist and their technical evangelist. What I also love about this is they always tackle new topic every week. I also suggest to subscribe to their YouTube channel to be automatically notified.

Just to add in the previous comments above, you may check this link for the formulas that you can use only in Formula fields and in Calculated values: https://howto.caspio.com/function-reference/

Caspio has some list of formulas that you can use inside the Caspio Bridge including the COUNT and SUM function. You may check this link: https://howto.caspio.com/function-reference/

Just to update this post, you can achieve your workflow now using Totals and Aggregation with Data Grouping. You may check this link: https://howto.caspio.com/datapages/reports/advanced-reporting/totals-and-aggregations/

For other Caspio Formula, you may consider checking the function reference: https://howto.caspio.com/function-reference/

Just to add in the previous comments above and to update this this post. You may consider checking this article on passing of parameters using query string: https://howto.caspio.com/parameters/parameters-as-query-string-values/