Jump to content

All Activity

This stream auto-updates     

  1. Today
  2. Yesterday
  3. Hi, I have a datapage with a multiselect listbox with about 40 options. How I need this information to trigger an autotask, and it is not possible with this listboxes, I'm studying convert it in 40 yes/no variables. I'd like to know if in a search form there is a way to display this "40 yes/no" in a similar way that a listbox, with a limited number of lines and a scroll bar. Thanks!!
  4. Hi @CoopperBackpack Hope you are well. Here is the code that would let you to achieve the result. You should insert it in your HTML block. And I will explain the code below. Please be aware, that I used Virtual Field for this example with name "cbParamVirtual1" as a Calculated Value, since in Caspio virtual field has syntax [@cbParamVirtual1]. You can put there your own field name if needed instead of "cbParamVirtual1" <div class="message"></div> <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { document.querySelector('input[id*="cbParamVirtual1"]').addEventListener("change", myFunction); function myFunction(event) { let virField = event.target.value; document.querySelector('.message').innerHTML = "your text should be here " + virField; document.removeEventListener('DataPageReady', myFunction); } }); </script> This is the part where you insert text, added by JS code:: <div class="message"></div> The JS code has place, where you should enter the text you want to have in HTML block. Here is this part, replace "your text should be here " for the one you need. document.querySelector('.message').innerHTML = "your text should be here " + virField; Hope it helps. Regards, Johnny
  5. Hello @leina, External fonts should be used in the Header of the datapage. According to the specification, fonts should have one of the following formats: Format MIME type TrueType font/ttf OpenType font/otf Web Open Font Format font/woff Web Open Font Format 2 font/woff2 More details can be found here: https://developer.mozilla.org/en-US/docs/Web/CSS/@font-face So, firstly, you should download need font and add the correct link to the href attribute:
  6. Hello, I have a Submission form DataPage , one of the fields is set to the Calculated value. And I need to display the value from this field in the HTML block. How can I achieve this?
  7. I want to remove a field in my table, but it has a dependency. What can I do to remove it?
  8. Last week
  9. Hello everyone I'm new in caspion and i'm trying using google web fonts, however i don't know why it doesn't show in the html block. maybe the code doesn't go there i'm not sure <link rel="stylesheet" href="https://fonts.google.com/specimen/Libre+Barcode+39#standard-styles">
  10. Alison

    Online Store

    Hi @Katey, If you have an account with Caspio, you may request the following application and use it as is: https://www.caspio.com/apps/online-store/
  11. Katey

    Online Store

    Which is the easiest way to create online shopping store for free?
  12. Thanks CoopperBackpack, your solution worked (almost perfectly). I put your JavaScript in the header of the DataPage, and changed the option around, as title == title1, the innerHTML of the H4 header should read "Add your Invoice and Financial Statement Report". Floris
  13. I used the following in my table SELECT Count([@field:SubscriptionComplete]) FROM GrowerSubscription WHERE [@field:SubscriptionComplete]="1" However that returns the total for all records in the table. My report is filtered by the managers name, how can I show only the tally for the results for the filtered table?
  14. I need a user to make 3 selections from a lookup table. I need to ensure that, once a selection is made, the next lookup will exclude the ones that are already selected. If there are 10 items to select, the 1st Selection has 10 options, 2nd has 9 options ....
  15. Hello @crionsynx, I am afraid, that it is possible to count distinct values on the Pivot Report only in Totals & Aggregations. You may use Custom formula with the SELECT statement. However, it`s possible to filter results only by the fields that are used as Rows on the Pivot Report. For example: Hope this helps.
  16. On-page optimization is a search engine optimization (SEO) tactic that configures the structural elements of a website to increase its search engine visibility and reach. It includes a series of different processes that colaboratively optimize the website structure to help it be found by search engines in specific and searchers (end users) in general
  17. Hi, just to update this post. Here's the new and updated article link for creating a Search and Report DataPage: https://howto.caspio.com/datapages/reports/creating-a-report-datapage/
  18. Hi, just to update this post. Here's the new and updated article link for Authentication: https://howto.caspio.com/authentications-and-connections/authentication/
  19. Can I update an App Parameter through a scheduled task? It doesn't seem possible, but I would really like this. I have an app parameter that stores the current year and I would like that to update automatically at the beginning of every year. Any ideas?
  20. I'm using the List Datapage. Looks good on the web, bad when printed. When I download and print a PDF, the text sizes are off. My name data (would be the title tags in my excel sheet), are very large and lower down in relation to the cell text. (see attached) 1) How would I make all text in my printed PDF the same size? 2) Does anyone know how to evenly space out information in the List view? Thanks, Heather
  21. FOUND THE ANSWER ALREADY, PLEASE IGNORE THIS QUESTION... In the online reference there is given an example for the function Select : SELECT Count(Country) FROM Customers WHERE Country=’Canada’ If I add the select in this way to a virtual field (calculation) I get a syntax error. If I put is as Select Count([@field:fielname] FROM [@table:tablename] Then the syntax is accepted, but I get a formula error in runtime. So, what is the correct syntax for the select statement in an calculation field in a datapage? Thank you in advance :-)
  22. I havent verified it yet but I think we can have as many connections as we need and they only limit the number of times we can run :/
  23. Hi CoopperBackpack, I will definitively give your suggestion a go (next week) and let you know how I go. Floris
  24. according to my experience these were good Astra. Divi. OceanWP. Ultra. Tusant.
  25. Hello @vanderLeest, Please try this code: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { let title = document.querySelector('#cbParamVirtual2').value; let title1 = document.querySelector('#cbParamVirtual3').value; if (title == title1) { document.querySelector('h4').innerHTML="Add your Invoice"; } else { document.querySelector('h4').innerHTML="Add your Invoice and the Financial Statement Report"; } }); </script> The code should work properly if: 1) you have only one <h4> tag on the DataPage 2) Virtual2 and Virtual3 values are present on the DataPage once it is loaded. Feel free to write back in case you have additional questions.
  26. Hello @techguy, Please try to use difference in days between your date field and timestamp. You may set the timestamp to your timezone. Hope this helps.
  27. I have a task that runs, but I am having issues with the date. I want the date to return the current today date.. this task works, but I do not want to manually set the date.. any suggestion how to make it use "today's" date? This works exactly how I want if I manually change the date to the today date.. but I want this automated and run at 11:45pm at night for the current day. It is easy to schedule the task daily, just ca not get it to use the "today's" date.
  28. Hi @Josh1425, Triggered Action settings looks inline with the desired output. Do you have a Triggered Action on table "Entity_Information"? Do you see data in table New_Intake_Information_Form within fields used in Triggered action? Regards, vitalikssssss
  1. Load more activity
  • Create New...