Jump to content


Caspio Rockstar
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Mathilda

  1. Yes, one more option is available. You may create a separate details datapage, make all fields to pass parameters and add an autosubmit script. Also create a submission form, add auto submit script and receive parameters in all the fields. In the destination after record update (in detail datapage) redirect to the submission form. Deploy the details datapage in html block on results page, you may find the similar solution here. So the workflow will be like this: You hit the link, the details datpages opens, autosubmits itself, passes parameters and redirects to the submission form. The su
  2. Hi Clint, Yes, it's possible. You need to create a submission form, deploy this form in an html block in your report and pass parameters to that form in query string. This way you may create a link or a button which will call a submission form. If you don't want to change data before submission, you may also add an auto submit script to submit datapage automatically.
  3. Have you checked these articles? You may find examples of API calls there.
  4. I believe this post should be helpful. You may try using one of plugins recommended there.
  5. Hi Ivy, I have good news for you I was able to make it to work with jquery. Wrap your fields in div with ID cbform-improvement. Also you need to disable ajax on your report and paste the following script in the footer: <script> $("#cbform-improvement #Mod0InlineEdit").click(function(e){ var chkbx_before = "[@field:Field_name^]"; var chkbx_now = $("[name=InlineEditField_name]").is(':checked'); if(chkbx_before!="Yes"){ if(chkbx_now){ var timestamp = '[@cbTimestamp]'; $("[name=InlineEditField_for_date]").val(timestamp); } else { var timestamp = ''; $("[name=InlineE
  6. Hello, Why don't you use formula field on the table level? Example of the formula: Dateadd(mm, [@field:Calibration_Frequency ],[@field:Last_Calibration]) If Java script is a better option for you, you may check this post
  7. Hi Ivy, As far as I know, we can't use java script in Inline edit mode. That's why I would recommend editing record on details page. That script should work on details page
  8. Hi, I edited code, which you found. The Delete button will be hidden if value in the field is blank. Please note, field should be editable on details page, if you don't want to display the field on the datapage, you may hide the field using html blocks <SCRIPT LANGUAGE="JavaScript"> function MyFunction() { var stat=document.getElementById('EditRecordField_name').value; if(stat.length>=1) { document.getElementById("Mod0DeleteRecord").style.display = 'initial'; } else {document.getElementById("Mod0DeleteRecord").style.display = 'none'; } } window.onload=
  9. You need to use string parameters, so try removing # symbol in parameter names, also make sure that you inserted opening div tag in html block above all the fields and closing div tag below all the fields. Also I would recommend removing if in the last condition. Use else instead of else if. You may take a look at the code I use on my datapage: html block1 above all the fields: <div id="visi[@field:id]"> html block2 below all the fields: </div> <script>var isi = document.getElementById("visi[@field:id]"); if('[@field:Sales]' >=1000) {isi.parentNode.
  10. Hi, You need to hit source tab before inserting code. You may also disable html editor. Hope it helps
  11. Hi everyone, I just want to share this solution. If you need to define color for the whole column, you may use the following script in an HTML block: <div id="mydiv[@field:id]"> </div> <SCRIPT LANGUAGE="JavaScript"> document.getElementById("mydiv[@field:id]").innerHTML ="<span style='color:blue;'> [@field:FieldName]</span>"; </SCRIPT> replace [@field:id] with unique field and [@field:FieldName] with name of your field
  12. Mathilda

    iPhone Bug

    It's hard to suggest something else without checking. I can check the datapage, you may send me an URL and credentials in personal message.
  13. Hi, I tried your code, it works on my datapage. Make sure that the LockStatus field is editable. If you don't need to display the field, you may hide a field using html blocks
  14. Mathilda

    iPhone Bug

    Hello, I would recommend checking that you the "Enable cross app login" setting is enabled for your authentications. This setting can be found in the Advance settings tab in the authentication. Another idea - perhaps, you specified too short period in the setting, which controls time range when user is logged. Maybe they got redirected to the login screen in 15 minutes? You can find this setting in the Advance settings tab as well. Hope it helps.
  15. Hi Dorian, you didn't hit "Source" button before inserting code. You can find more information here Cut code->hit Source-> paste the code back
  16. Hi, it looks like report datapage. You may find the similar datapage on a public view on the real estate listings app template: https://www.caspio.com/real-estate-listings/ If you have an account, you may request the application and check how it was built.
  17. Hi dasigrist, You may delete the following code from the header. <div align="center"> <p>Processing...</p> <img src="images/progress_bar.gif" alt="Progress Bar" width="200" height="15" /> </div>
  18. Hi Mylene, Add header/footer, open the header, disable html editor and add the following code in the header of the datapage to hide the default submit button: <style> #Submit{ display: none; } </style> Add an HTML block below all the fields and Disable the HTML editor and on the Standard tab and add the code below: <div style="text-align: center; position: relative;"> <input type="submit" onmouseout="cbButtonHover(this,'cbSubmitButton');" onmouseover="cbButtonHover(this,'cbSubmitButton_hover');" class="cbSubmitButton" value="Submit" id="Submit1" name="Su
  19. You need to specify the designated entry page. Edit the authentication and expend the advanced settings. Then edit Timeout and redirection. In the Designated entry page: select go to a new page and paste an URL where you have deployed the login screen. Hope it helps
  20. Hi, I believe, this article will be useful. Also you may take a look at best practices
  21. Hi Kaxmi, It's a limitation of caspio REST API. Inserting multiply records is not allowed.
  22. Hi sxolimet, Creating and editing objects in account don't incur data transfer, however the preview of the report datapage or submitting data in submission form incurs. You may use browser tools (F12 and net tab) to estimate how many data transfer consumes one page load.
  23. Hi, you may check if you included field which is used in relationships. If your form is built on a child (related) table you may see this error if you don't fill out the field which is used in relationship. Hope it helps
  24. Hi Hendrik, Authentication fields are taken from the data source table or view. If you use a view, you may check if you included the field in the view. In case you use table you should be able to see all the fields except fields with special datatype like password. Also depending on the datatype compatibility you will see different lists of available authentication fields in a drop-down. Hope it helps
  25. You may use this kind of formula only in calculated field on report datapage. So when you open a report, age will be calculated dynamically and your data will be always up-to-date. It's very important, especially when you need to calculate someone's age However if you need to store value of calculated field in the table, you may use the solution described here
  • Create New...