Jump to content

All Activity

This stream auto-updates     

  1. Yesterday
  2. I'm primarily using Tabular DataPages. My thinking was to create calculated fields to summarize data in the dataset and display these calculated fields using an HTML box on pg5. An Example would be to summarize # of persons in a few key departments. Obstacles so far: - i'm not able to perform calculated fields on pg5 - on pg12 I was able to hide a calculated field using rules and a section block, but in pg 8 i dont see options to do this here.
  3. Hi @Elderberg, You can change the font of your HTML block under the HTML editor. You may refer to this screenshot: Then, choose the font that matches the font of your fields/labels, which you may see on your Styles: -JolliBeng
  4. Can someone guide me on how to get text to match that of the style selected for the datapage. Text that gets generated from the HTML Blocks shows up weird. See below link, which is the caspio URL, so no conflicts of CSS from outside hosting. I've also tried cycling through a few of the selected datapage styles but the text within HTML block still get rendered with a different font. BTW, not sure if its relevant but that text is within a table/list. https://c1aco134.caspio.com/dp/b08a7000ec2bfda29d2b43dabefd oh and lastly I've looked around the Style Editor, although haven't made any changes in there as I have zero experience with CSS nor the Caspio Style Editor.
  5. hi @kpcollier, I believe what you want is a UNION of both tables, and NOT a VIEW. Here's a good article differentiating the two: https://www.essentialsql.com/what-is-the-difference-between-a-join-and-a-union/ Unfortunately, Caspio does not have a direct table operation that allows UNION of both tables. The closest we can do is to create another table that has the common fields of your first two tables. We can, then populate the new table with Triggered Actions or Tasks to yield your desired result. After, then, just use the new table as your DataSource. I hope this helps. DN31337
  6. Hi, You can also modify the Styles using Source Code, you just need to click the "Source" tab. -JolliBeng
  7. Hi, In case someone might be loooking for this solution, I am attaching a solution of five formulas that will extract the nth element in a delimiter-separated list on string (in this case, the delimiter is a semi-colon). To upload this solution to your account, refer to this documentation: https://howto.caspio.com/apps/importing-an-app/ Hope this helps, DN31337 zapier_source_2019-May-18_2037.zip
  8. Hi All! I tried to consult this issue to Caspio Support Team. As per them, the issue is on SquareSpace. They said that the snippet should be disabled first to become editable. They provided me the following steps: You can disable the HTML Code by either adding "/safe" to the current URL or clicking "Disable Scripts in Preview” button in the bottom part of the editor. You can enable the Scripts again by clicking the “Enable Scripts in Preview” found in the bottom part of the editor. -JolliBeng
  9. Try this one. <style> [class*=cbSearchButtonContainer] { display: none; } </style>
  10. Can you advise what to put in the header of a Report Datapage to hide the search button? The first part of your code didn't work when i applied it to the Report Datapage, wishful thinking, but the 2nd part that goes into the HTML block worked great!
  11. Last week
  12. See the illustration. I'm trying to make use of the empty white space to the right of the search box, but having challenges finding the right solution.
  13. Hi, just to add Caspio DataPages are fully customizable to create an experience that matches seamlessly with your website and corporate branding. You may refer to this Howto article for further: https://howto.caspio.com/styles/ | https://howto.caspio.com/styles/customizing-styles/. I hope this helps.
  14. Hello, you can create a task that will run everyday at 12AM, where the condition of the task will be first you need to create a Date/Time field or a timestamp (depending on your workflow), then compare that field to the current date and if the field matches as today, the task will run.
  15. I want to use tasks in my account where I would be able to send a reminder email if this specific date is met, this task will run.
  16. Hi - Just to add you may also refer to this Howto article on Stamp a Record with User Profile Data.
  17. Hi guys, I would like to share this with you. Since there is an existing tech tip: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/how-to-add-a-time-limit-to-submission-forms/, I would also like to provide a possible alternative without using JavaScript and just relying on with Caspio's standard feature: Initial Requirements: -One Table containing the records for the data. Inside the table, you’ll need at least one unique field, and two Date/Time fields for your Start date and End date. (Screenshot: ) -Three Deployed DataPages: 1 Submission form, 1 Single Update Record, 1 Reports Form. DataPage configuration steps: 1. From the Submission Form DataPage, select the Start Date Date/Time fields from your available fields. Make sure to check the ‘On exit, pass ID and formula fields as parameters for us to get the duration time possible. ( ) 2. From the Configure fields, set the form element of the Start Date to TimeStamp. ( ) 3. From the Destination Options, select ‘Go to a DataPage’ as the destination after record submit. Select the Single record update DataPage as the destination of the submission form and click finish. 4. From the Single Record Update DataPage, go to the Record Identification and select the record with the unique field. Set the parameter name as [@insertRecord + field name + ]. ( ) 5. Similar with the configurations of the submission form, retrieve the End Date Date/Time field and set the form element to TimeStamp as well. 6. From the Destination Options, select ‘Go to a DataPage’ as the destination after record update. Now, select the reports DataPage as the destination of the Single Record Update DataPage and click finish. 7. Configuring your tabular Reports DataPage, configure the filtering fields and receive the unique field as the DataPage element and receive the value or parameter on load. ( ) 8. From the Configure results page fields, add a calculated field with the following formula: DateDiff (ss, [@field:StartDate], [@field:EndDate]) . Change the StartDate and EndDate to the name of your actual field. The formula gets the seconds between the two dates before submission and after the update form was created (Get more at https://howto.caspio.com/function-reference/). Verify if the formula will work and if valid, click finish and test the DataPage. 9. Deploy all the three DataPages and start submitting the record from the submission form. I hope this helps.
  18. The backgrounds are blending in with the background color of the page (white). Change it by going to the 'Background options' within "Fields" under the "Form/Details" section of the Styles and change it according to your preference.
  19. I want to be able to change the color of the field but I do not now if I should use a custom code or I just need to edit this in Styles. Please help.
  20. Hi, just to update this post. Here is the updated link for the troubleshooting notification email: https://howto.caspio.com/troubleshooting/automatic-emails/troubleshooting-notification-emails/
  21. How will the task trigger? May you specify as well how your API works? Here you'll find the basic instructions of task: https://howto.caspio.com/tasks/
  22. There is an HTML tag for that, and it is called <blink></blink>, there is also a Javascript way to do that if you're familiar then this might help: https://www.wikihow.com/Make-Text-Blink-in-HTML I am not yet certain if this can be achieved in CSS but you can insert a header/footer on your report and disable the enable HTML editor from the advanced tab. Then in CSS, you can have the following: .blinking{ animation:blinkingText 0.8s infinite; } @keyframes blinkingText{ 0%{ color: #000; } 49%{ color: transparent; } 50%{ color: transparent; } 99%{ color:transparent; } 100%{ color: #000; } } Instead of .blinking, you can select the Class or any attribute of the object you want to style, I haven't tested this code yet but, I definitely will test later. Let me know if this helps
  23. Hi, Just to update this post. Caspio Bridge DataPages can be copied with ease. Copying a DataPage is useful when you need to archive the current state of a DataPage before applying changes and can save time when you want to create a similar DataPage. For more details you can check this updated link for Copying DataPages: https://howto.caspio.com/datapages/managing-datapages/copying-datapages/
  24. Hi, you can also check the limitations of Rules here: https://howto.caspio.com/datapages/forms/conditional-forms/
  25. Barbie

    Modified By

    Hi Telly, In your Tabular DataPage include your "Modified By" field in your Details page and set the form element to "Hidden" and then on the On Load, receive: choose the Authentication Fields and the fields that you want to display. Next is, add a Virtual field Label it as "Modified By" and set the form element to "Display Only". Under the Advanced tab check the On Load and choose the Data Source Fields and get the "Modified By" field. We used this Virtual field to display the Modified By in your DataPage since we set the Last Modified to "Hidden" I hope this helps. Thanks, Barbie
  1. Load more activity
  • Create New...