Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation since 04/10/2021 in all areas

  1. Thanks @kpcollier and @sandy159 - the difference in days option worked. Appreciate your help.
    2 points
  2. Hello @Gabrielle, Please note that this dropdown shows the tables that have a unique field. The Authentication can be created using the table with the unique field since it`s required to define the specific user. For example, in this table the email field is set to unique: Feel free to update this thread in case of additional questions.
    2 points
  3. I'm not versed in jQuery terms but I got this working with the following. First include the cdn of jquery on your Header, you get no errors, so, that means you already have it included, but for anyone who might need it HEADER > DISABLED HTML EDITOR <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script> FOOTER If you want to go through every input, then use 'input' instead of cbParam What the code in the if does is it goes to the parent element of the current input (it goes to div) then searches the NEXT sibling
    1 point
  4. I tried this, and it is definitely because you are using #inserted as Destination and source. Maybe create a table variable and store the initial #inserted table there so you won't select from a table that's being constantly modified through the loop, or create another table altogether, that's where it conflicts.
    1 point
  5. Oh, alright, sorry about that, thank you for the solution, as well!
    1 point
  6. Hello @Kuroshi I am thinking of a workaround for this and came up with this -> Create a Task instead that has the same functionality as your Triggered action. Task is somehow similar to trigger. However, the task will not fire automatically once you inserted a record. you will need to click the 'Run' task or schedule when will the Task run. I hope this helps and works. - Barbie
    1 point
  7. kcastagnaro

    Calendar Pop up

    Hi! I was actually able to figure it out. I had to customize the following in my CSS. It was 14px. Thank you so much for your help! div.numInputWrapper span { position: absolute; right: 0; width: 2px; height: 50%; line-height: 50%; cursor: pointer; -webkit-box-sizing: border-box; box-sizing: border-box; }
    1 point
  8. Hello @wimtracking2, As I understood from your inquiry, you store the cities in the field with the Text(255) data type and set this field on the Search page as Listbox -> Allow multiselection And the Search is set like this: If this is the case, it is possible to add the "selected" attribute to the options you want by JavaScript. I added this code to the Footer section on the "Search and Report Wizard - Configure Search Fields" page (the HTML editor is disabled on the Advanced tab before pasting). <script> document.addEventListener('D
    1 point
  9. Hi @kpcollier, Happened to me before. This can happen when there are blanks on the file that you are importing. You need to filter and delete the blanks in the file first.
    1 point
  10. Hello @Hiperf, The issue can be connected to the exact field name. As far as I understand, the formula is in the Calculated Value field is valid. This means that the field name is PropertyActive (not _PropertyActive). In this case you need to reference the field as EditRecordPropertyActive (without underscore before the field name). I used underscore because it was in the initial script. You may learn more in this post https://forums.caspio.com/topic/4377-js-guide-caspio-form-elements/ Please test the code with this small correction. I tested this solution in my account an
    1 point
  11. Hello. Just to add, you may visit this How-to article regarding Styles: https://howto.caspio.com/styles/. -Potato
    1 point
  12. If you want to apply this to any data type, you may do the following in the Styles Page
    1 point
  13. Hello @Stepford, You may select one of the two approaches: 1) Change the alignment in the Styles section. In this case, the changes will be applied to all DataPages that use this Style. Please open the Source tab -> All -> find the cbResultSetTableCellNumberDate CSS class using Ctrl-F (or Command-F for Mac) -> change the text-align to right. 2) You may apply the changes to the particular DataPage without changing the Style. To do this you may add Header/Footer elements on the Configure Results Page Fields page and paste the code to the Header.
    1 point
  14. Hi guys! Just wanted to add these links about setting up authentications. It's very informative and helped me a lot when I was just starting out with Caspio https://howto.caspio.com/authentications-and-connections/authentication/ - Jihyo ♥
    1 point
  15. CoopperBackpack

    IF/THEN in Report

    Hello @jeffs88keys, It looks like the solution depends on the exact DataPage type. Could you let me know if this is a Tabular Report DataPage or Details DataPage? Do you need to display the statement in each record if this is a Tabular Report DataPage like this? If so, please double-check the condition, since I am afraid it your question it is "when [field1] is blank or if [field2] is blank" for both cases. Also, specify the the data type for [field1], for [field2] it is File data type as I understand.
    1 point
  16. Hi @Mollie, just to add, you may also check this Caspio's video tutorial regarding for responsive applications.
    1 point
  17. Hi @Mollie , You may also browse these articles that can help you with your inquiry: - https://howto.caspio.com/datapages/responsive-datapages/responsive-behavior-on-tablet-and-mobile/ - https://howto.caspio.com/datapages/responsive-datapages/modifying-styles-for-tablet-and-mobile/
    1 point
  18. Hello @Eugene, Since Caspio uses the Highcharts library to render Chart DataPages, I have checked the Highcharts documentation https://api.highcharts.com/highcharts/ I was able to find the solution that allows to add spaces between slices for the usual Pie Chart (not 3D Pie Chart). You may paste this code to the Footer section on the "Chart Wizard - Configure Chart Options" screen of your DataPage. Do not forget to disable the HTML editor on the Advanced tab before pasting the code. I put the borderWidth as 3, please use the value that you need. < scri
    1 point
  19. Sure! Btw, I found a way <script> document.querySelector("input[id^='InsertRecordList']").addEventListener('change', function() { document.getElementById('cbParamVirtual1').value = document.querySelector("input[id^='ComboBoxInsertRecordList']").value; }); </script> The input with id starting with InsertRecord**FieldName** stores the checked values, so you can just use that as a reference to listen for a change You can try it out again https://c2aby549.caspio.com/dp/83ff8000344c2f4c1794467fb6e2 Cheers!
    1 point
  20. There use to be a checkbox next to where you name the download in Download Options that would append the current date to the name. But, for some reason, they deleted that and changed it out without telling anyone. I was also looking for this today. Now, you need to click on the 'field picker' next to the name box in Download Options and select the timestamp option.
    1 point
  21. Hello @Mollie, If you are referring to the Caspio DataPages, please use the Responsive option. You may learn more in these articles: https://howto.caspio.com/datapages/responsive-datapages/responsive-datapages/
    1 point
  22. Hello @JayDub, The previous comment by kpcollier is absolutely correct. The email may not be sent because the WHERE condition is not met. I usually like to use the 'difference in days' block for this type of task. Basically, if a field with a date is in the future - then the Timestamp should be set in the first place. That said, to select the records with classes that begin in four days, the difference in days should be equal to 4. Here is the example, just swap the fields to yours: Hope this helps!
    1 point
  23. Hi @JayDub, Have you tried swapping the timestamp and CourseStartDate fields? "WHERE CourseStartDate EQUALS TimeStamp - 4 days' You could also try the 'difference in days' block under Date. 'WHERE difference in days between CourseStartDate and Timestamp equals -4' I have not been able to test these, but thought I would try to help.
    1 point
  24. Hello @IamGroot, Just wanted to inform you, I found a way to export/import a table/database with List-DataType value inside it. 1. Change the DataType to "Text(255) field" and Export it. 2. And in your Excel file, make sure that the value for the List-String field is comma separated like this: (Item1,Item2,Item3,Item4, etc.) 3. Proceed with the import as usual. After successfully importing your file. Go to your Table and to the Table Design. 4. Change the "Text(255) Field" (The one we changed in step 1) back to List-String DataType. 5. Then it will just return t
    1 point
  25. JavaScript Solution: Adding a Digital Signature to a Submission Form Feature Description: This JavaScript solution shows how to add a digital signature to a Submission form, Update form, and Details form. It also shows how to display the signature in Details and Results page of a Report. The signature pad is compatible with mobile devices as well. Note: This is a simple capture and displays a signature solution. It is not designed to replace a professional e-signature solution like DocuSign that assures security, legal, and visibility of all transactions with a complete audit tr
    1 point
×
×
  • Create New...