Jump to content

vikovs

Members
  • Content count

    16
  • Joined

  • Last visited

1 Follower

About vikovs

  • Rank
    Member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. vikovs

    Data Page - Custom HTML Block - Label (not working)

    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?
  2. vikovs

    Adding Business Days to a Date Field

    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
  3. 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. vikovs

    Hide Charts when no data is present

    Hi TMeyer, There is a solution for hiding map if no records found (please see the article ), maybe you can adjust it to your needs
  5. 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.
  6. vikovs

    Food Database Link to Word Press Site

    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
  7. vikovs

    Subforms

    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/
  8. vikovs

    Remove "Data Table" tooltip

    It works! Thank you for your help!
  9. 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.
  10. vikovs

    Pie Chart Labels

    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.
  11. vikovs

    How to update a field with state information?

    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
  12. Hi Vitalikssssss, Brilliant! It works! Thank you sooo much!!!
  13. 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!!!
  14. vikovs

    Sample Script

    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
  15. Hi dspolyglot, You may also check the solution from this article - just change the font colour instead of background colour.
×