Jump to content


Caspio Ninja
  • Content Count

  • Joined

  • Last visited

  • Days Won


CoopperBackpack last won the day on January 9

CoopperBackpack had the most liked content!

About CoopperBackpack

  • Rank
    Advanced Member

Recent Profile Visitors

267 profile views
  1. Hello @Eremas, This can be achieved with Cascading Elements. Please refer to the article https://howto.caspio.com/datapages/datapage-components/cascading-elements/ You need to have a lookup table with a list of districts/towns. You may find an example in this article https://howto.caspio.com/tables-and-views/lookup-tables/ Feel free to update this thread if you have further questions.
  2. Hello @kpcollier, If I got your inquiry correctly then you need to have a dynamic dropdown based on another dropdown. This requires a rather bulky JS solution as I understand. Did you consider using a Cascading dropdown on the DataPage? You just need to have a well-structured lookup table (please refer to this example on the screenshot) So, the first field is dropdown and the second one is the Cascading dropdown (https://howto.caspio.com/datapages/datapage-components/cascading-elements/) Is this solution right for you?
  3. Hello @CClabaugh, Generally it is possible with JavaScript code. Since Caspio uses the Highcharts library to render Chart DataPages, you may refer to the Highcharts documentation to lean more about Chart`s customization https://api.highcharts.com/highcharts/ I used the code from this Forum post and modified it to change the legend width. It works on my side. <script> document.addEventListener('DataPageReady', chartUpdateHandler) function chartUpdateHandler(event) { var cleaner = function(interv) { clearInterval(interv); } let interv = setInterval(() => { var
  4. Hello @VincenzoCocciolo, It looks like the issue is related to the parameter format. When you add the File field to the HTML block with a Picker icon, it is added as a String. So, please add the slash sign to render the link as URL. You may find this information in this article (the table at the end of the article ) https://howto.caspio.com/parameters/displaying-parameters/ Hope this helps.
  5. Hi @David17, I am glad that solution works for you now. If you need to add this code for several fields, please use this code <script> document.addEventListener('DataPageReady', checkInput); function checkInput(){ let numberFirst = document.getElementById('InsertRecordField_1_name'); //declare first variable let numberSecond = document.getElementById('InsertRecordField_2_name'); //declare second variable numberFirst.min = "0"; numberSecond.min = "0"; numberFirst.type = "number"; numberSecond.type = "number"; numberFirst.setAttribute("oninpu
  6. Hello @VincenzoCocciolo, I am not sure that this is the right solution for you. However, can you check if the Enable cross-app login option is enabled in all of the Authentications? You may refer to the article https://howto.caspio.com/authentications-and-connections/authentication/authentication/ Enable cross-app login – With this option you can enable cross app login to users who already have an active session with another one of your apps that uses the same users table for its authentication. For example if your ticketing system and your sales system are based on the s
  7. Hi @David17, Thank you for the screenshot. It looks like the cause of the issue is related to the element name(the Adults field). As I see on your screenshot, the exact name of the field is Adults, so the first letter is capitalized. Please make sure that you added the element name in the code as 'InsertRecordAdults', but not 'InsertRecordadults'. The exact field name matters. So, it looks like the code does not work, since it does not find the element with the name 'InsertRecordadults'. Please try this code in the Footer section: <script> document.addEventL
  8. Hello @David17, Both solutions work on my side on the Submission form. I can assume that you have another type of the DataPage. In case you have not a Submission form, but Single Record Update or Details DataPage, then please use EditRecordField_name instead of the InsertRecordField_name let input = document.getElementById('EditRecordYOUR_FIELD_NAME'); Hope this helps.
  9. Hello @qrmds, Unfortunately, the GetUTCDate() function is not available in the Formula field. You may find this information is this article https://howto.caspio.com/tables-and-views/data-types/formula-fields/ As a workaround, you may use the Application Task to calculate the DateDiff if this feature is available in your plan. The Task example: You may learn more about the Tasks in this article https://howto.caspio.com/tasks/ If you need to recalculate the age every year, it is possible to run the Task on 01/01 to get the relevant age. Hope this hel
  10. Hello @David17, The Caspio forms validate the data in a certain way when a user clicks the Submit button. If the data type of the entered data is incompatible with the data type in the table, the error message appears. However, you may add custom JavaScript to the Footer section of the Submission Form. The solution that is already suggested should work. Also you may try this code as well. Replace the YOUR_FIELD_NAME with your local field name. <script> document.addEventListener('DataPageReady', checkInput); function checkInput(){ let in
  11. Hello @DeKleineBoer, As far as I understand, you are trying to make calculations on the table level using the Formula field. If so, I am afraid, that it is not possible to use the result of some formula in another formula directly (selecting the field with formula when clicking the picker icon). In such cases I usually duplicate the required formula in the next calculations. For example: 1) You have the "Price_with_vat" Formula field with the following syntax [@field:Price]*1.2 2) You need to calculate the price +10% from the "Price_with_vat" field. The formula s
  12. I would like to add that if you want to make some value a default one, please select this value and click the checkmark button. You may learn more in this article https://howto.caspio.com/datapages/forms/form-element-types/ If you want to customize your DataPages with JS solutions, maybe these articles are helpful as well https://howto.caspio.com/datapages/ajax-loading/ https://howto.caspio.com/release-notes/caspio-bridge-13-0/13-0-impacted-areas/
  13. Hello @DiogoBem, You are correct, the radio buttons have id that looks like id="Value1_10_....", id="Value1_11_....", etc. Please note that each id includes some dynamic digits as well, in your example with id="Value1_10_323d54705b4c9c" it is 323d54705b4c9c. So, if you try to get the element as var test= document.getElementById("Value1_10") you receive Null. You need to get element where id 'begins with' or 'contains' "Value1_10". This external article can be helpful https://www.w3schools.com/cssref/css_selectors.asp Please try using a slightly different syntax. For
  14. Hello @kpcollier I am afraid that this cannot be achieved with Formula field in the table, since Formula field operates only within 1 record. As a result, we cannot check/use the values that are stored in the other records in the Formula field. It looks like the best solution is to create a Triggered Action. I am not sure about your table design, so I assume that Est_Table is the child table that has the Bid_id field as well. For example, the table looks like this: This is the Trigger design: Here is the output: Ma
  15. Hello @OlivierDeNantes, This can be achieved with the Triggered Action if this feature is available in your plan. You may refer to the article https://howto.caspio.com/tables-and-views/triggered-actions/ Also, you may find the example of the Trigger in this post https://forums.caspio.com/topic/8289-sum-function-in-triggered-actions/#comment-25800 Please note that the complexity of the Trigger depends on your workflow. It depends on whether the data is being inserted only into the Book Entry table, or whether it is updated and deleted as well. If the Triggered Action
  • Create New...