Caspio Rockstar
  • Content count

  • Joined

  • Last visited

  • Days Won


Mathilda last won the day on October 1

Mathilda had the most liked content!


About Mathilda

  • Rank
    Advanced Member

Recent Profile Visitors

1,641 profile views
  1. I think that you may try using cascading elements, this will let you fill out fields with data depending on value, selected value in a parent field.
  2. In this case, you may use java script only for displaying the value to a user. Depending on your requirements, you may execute function window.onload or 'onchange' of a specific field.
  3. Current day of the week in an App Parameter

    In this case you may use java script. I created a simple example for you, you should paste script in the footer of the datapage: <script> window.onload = function myFunction() { var d = new Date(); var weekday = new Array(7); weekday[0] = "Sunday"; weekday[1] = "Monday"; weekday[2] = "Tuesday"; weekday[3] = "Wednesday"; weekday[4] = "Thursday"; weekday[5] = "Friday"; weekday[6] = "Saturday"; var n = weekday[d.getDay()]; document.getElementById("InsertRecordField_name").value = n; } </script> Enter name of your field instead of: Field_name
  4. Current day of the week in an App Parameter

    As far as I remember app parameter doesn't have this flexibility. Depending on the type of the datapage you will be able to get current day of the week in calculated field: DATENAME ( dw , '[@cbTimestamp]')
  5. Encryption of Emails?

    As far as I know, it's not possible. Caspio mailers send email on behalf of your email address, therefore you cannot use encryption in this case.
  6. WordPress deployment

    Hi, Thank you for sharing
  7. What type of the datapage do you use? You may have a look at this and this post
  8. Auto calculating and submitting a form

    I suppose that you use update form. You should use a little bit different syntax, have a look at this post
  9. autonumber as a parameter with autosubmit

    What is the purpose of using series of autosubmit datapages? I assume that you need to submit values to different table, in this case you need to pass ID to those records. This will let you then join tables in views and give you more flexibility in retrieving data Hope it helps
  10. I would use SQL query in calculated field on details page. E.g.: sum(hours) from table_name where user_id=targer.[@field:userid] Calculated field generates a value on the fly on every page load (therefore it's always up-to-date), but if you need to save it in table you may use solution from this post
  11. I just wanted to share this solution if you wish to add some text like "Select items" to your list string field, you may use this solution Insert HTML block above the field, disable html editor and insert code: <script src=""> </script> <script> function placeholders() { document.querySelector("input[type=text][name=ComboBoxInsertRecordField_name]") .setAttribute("placeholder", "Select items"); } $(document).ready(placeholders); </script> Replace Field_name with name of your field.
  12. You may try passing parameters from the search to results page header or html block. Pass parameter on exit for a field on search page, then use parameter names in the header of the results page [@field1] OR [@field2] OR [@field3]
  13. Need to format details page better

    As far as I understand, borders appear when you embed a datapage to your webpage. If you don't pass parameters to/from the datapage, you may use iframe deployment method, this will let you keep the same look as you have on preview in Caspio. Another option - edit CSS of your website and edit attributes which overwrite caspio style. One more possible option - ovewrite attributes in the header of the datapage, like: <style> #caspioform tr { border: none !important; } #caspioform td { border: none !important; } </style> You can user similar code for other form elements to override border:none. Use firebug or other F12 tools to inspect the form elements and find their respective style and customize them similar to the below code.
  14. Mobile App Builder

    You may try appypie, I tried deploying datapages there, works fine. I deployed datapage to "code page" type of page
  15. Automatic Emails

    As far as I know, this kind of triggers can be done on the server side only. You may reach out to this team, they implement this kind of requests