-
Posts
16 -
Joined
-
Last visited
Recent Profile Visitors
The recent visitors block is disabled and is not being shown to other users.
vikovs's Achievements
Newbie (1/14)
1
Reputation
-
Hi IMTanuki, Yes, you are right. You can define Label for the custom HTML block as you show in your screenshot. Please see my examples too: 1) DataPage Wizard view 2) Report DataPage Preview Is it what you need to achieve? Could you please send the deploy URL of your report?
-
Adding Business Days to a Date Field
vikovs replied to JeremyMenefee's question in Calculations and aggregations
Hi there, In case someone needs, you may try the following solution to count ONLY business days and exclude weekends and Holidays (you may need to have a separate table with State holidays information) To calculate the difference in dates (only considering business days), enter the following into your calculated field: SELECT (DATEDIFF(dd, [@field: StartDate], [@field:EndDate]) + 1) -(DATEDIFF(wk, [@field:StartDate], [@field:EndDate]) * 2) -(CASE WHEN DATENAME(dw, [@field:StartDate]) = 'Sunday' THEN 1 ELSE 0 END) -(CASE WHEN DATENAME(dw, [@field:EndDate]) = 'Saturday' THEN 1 ELSE 0 END) -(SELECT count(id) FROM Your_State_Holidays WHERE date BETWEEN [@field:StartDate] AND [@field:EndDate] AND DATENAME(dw, date) NOT IN ('Sunday', 'Saturday')) where you replace StartDate and EndDate with your corresponding fields and Your_State_Holidays wih the name of your table -
nancyrai37 reacted to an answer to a question: How to download more than 1000 rows via REST API
-
How to export Recipe data WITH special characters
vikovs replied to Kirkman's question in Import/Export and DataHub
Hello Kirkman, Have you tried to export the table either using Tables listing or Tools->Export? You may check the options available described in the article Hope it helps- 4 replies
-
- recipe guide
- recipes
-
(and 3 more)
Tagged with:
-
vikovs reacted to an answer to a question: Calculate Week Number in Formula Field
-
How to download more than 1000 rows via REST API
vikovs replied to MattFL's question in API and Integration
Hi MattFL, I am afraid that with the current set up and system limitations (API returns maximum 1,000 rows per call) it is not possible to do. As soon as Caspio is continually improving the product and expanding standard feature set, you may visit Caspio Ideabox at http://ideabox.caspio.com and share your idea there. -
Hi jwrigh10, As far as I know, it is possible to integrate Caspio with Wordpress. You will need to install Caspio Wordpress Plugin on your site and use Wordpress Deployment for your DataPages. You may find more information on this in the following article Hope it will help
-
Hi franbill, Could you please give more details on your workflow and what you would like to achieve? Meanwhile, please take a look at the following article, maybe this solution will help you to achieve the desired: https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-create-a-multi-page-form/
-
Remove "Data Table" tooltip
vikovs replied to dspolyglot's topic in User JavaScript and CSS Discussions
It works! Thank you for your help!- 17 replies
-
- javascript
- tooltip
-
(and 2 more)
Tagged with:
-
vikovs reacted to a post in a topic: Remove "Data Table" tooltip
-
vikovs reacted to an answer to a question: Embed Within A Datapage, A Pdf Stored On Caspio Database
-
Hi timothyjl, The possible solution here is to use both Fields and Sections to set up rules, this way you can refer to them twice. For example, you have Section 2 with Field 2 and Field 3 included there and you have Section 3 with Field 4 and Field 5, so you can set up the following rules: 1) rule 1: criteria: if select field isBlank - value: Hide Field 2, Field 3, Field 4, Field 5 2) rule 2: criteria: if select field Yes - value: Hide Section 3 3) rule 3: criteria: if select field No - value: Hide Section 2 and also here you can add criteria for Active field (checked) and make it disabled you may also check this tutorial video to learn more about Conditional Rules As for redirect after form submission, yes, you may use the following solution: Dynamic Redirects After Form Submission Hope it helps.
-
Hi AdamS, You may check whether you have both parameters selected in Values tab -> Display options -> Value label. Press "Edit" button and add the missing parameter (manually or using the parameter picker), if this is the case. Please see the screenshot in the attachment.
-
Hi timothyjl, If you need to fill some form, you may consider using cascading dropdowns. Please check info in the following article. Hope, it will help
-
vikovs changed their profile photo
-
How to change the width of chart columns?
vikovs replied to vikovs's question in Styles and Localizations
Hi Vitalikssssss, Brilliant! It works! Thank you sooo much!!! -
Hi everyone, I would like to increase the width of columns in a Caspio Column chart. Is there any solution for this? Many thanks in advance for your help!!!
-
Hi Pearse, You can do this by using standard Caspio Bridge Import feature. Just select Append option in Import Wizard :) You may find more information about import in the following article
-
Hi dspolyglot, You may also check the solution from this article - just change the font colour instead of background colour.
- 6 replies
-
- javascript
- css
-
(and 1 more)
Tagged with: