Caspio Guru
  • Content count

  • Joined

  • Last visited

  • Days Won


Mathilda last won the day on January 6

Mathilda had the most liked content!

About Mathilda

  • Rank
    Advanced Member
  • Birthday

Recent Profile Visitors

492 profile views
  1. Hi, try using my code in the footer of the datapage: <SCRIPT LANGUAGE="JavaScript"> function check() { var v_cost = parseFloat(document.getElementById("InsertRecordFirst_field").value); var v_retail = parseFloat(document.getElementById("InsertRecordSecond_field").value); if(v_cost>v_retail) { window.alert("Cost must be less"); return false; } } document.getElementById("caspioform").onsubmit=check; </SCRIPT> Replace First_field with field name where you store cost, and Second_field with field name where you store retail amount. Hope it helps!
  2. Hi Neil, I calculated future value using this formula. I have all the data in one table, so I used formula field with the following formula: [@field:Cash_flow]*power((1+[@field:rate]),[@field:number_of_periods]) It's possible to calculate the same in calculated field on report, if you need to take values from different tables.
  3. Hi, The update button appears only if you have at least one editable field on the datapage. Perhaps you hide that field using rules or javascript. Anyway you can hide update button using java script. Just add header/footer and paste the following code in the footer: <script> window.onload = function hide(){ document.getElementById("Mod0EditRecord").style.visibility = 'hidden'; } </script>
  4. Hi, there is the user logs feature, perhaps it's what you're looking for. As far as I know this feature available only for some accounts, so check pricing page to verify that this feature is included in your account.
  5. Hi You may try checking the direct URL of the datapage (URL type of deployment). If it works on direct URL and doesn't work on your site, you need to check your webpage. Hit F12 and check console, do you see errors there? Also what that script should do? I know that redirection doesn't work if you use iframe type of deployment. If the datapage is not authenticated you can send me an URL in private message, I'll check.
  6. 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
  7. Hello Dorian, Since the datapage is authenticated I can only check the login page. To remove borders, insert the following code in the header of the datapages and authentication: <style> #caspioform tr { border: none !important; } #caspioform td { border: none !important; } table { border: none !important; } </style> Also I would recommend editing theme in wordpress and deleting "margin" attribute for "table" element. 25px value adds space between elements. You may also use dev tool in your browser (F12) to find other attributes which you need to edit. This article might be helpful
  8. Hi Dorian, Create a new style. Do to Styles tab and click on the new style button in the top of the screen. As far as I know you will create a new default style this way. Hope it helps
  9. Hi, I would recommend using column type of chart. Define the following settings on the Configure chart settings screen of the wizard: - Chart settings: define value for the width setting, because chart will be too wide for 1 column. Try using 400px. - Data source settings: select "Use a separate field for each series" - category X axis: leave blank - category Y axis: set "fixed" for Axis value range and in the "to" field define your goal, so you need to put 50 there. Also select "none" in the formatting setting (it's set to % by default) - value1: select a numerical field and select "count" in aggregation. After that save changes. Hope it helps :)
  10. Hi Mark, yes, you are right. Wix is not the best site builder if you need to pass parameters or use java script with redirections
  11. Hi Mark, You can edit style attributes in Appearence-> Editor in Word Press account. If you need to edit Style in Godaddy site builder, you may find instructions here Hope that helps
  12. Hi, As far as I understand one product can have many clients and each client can have many products. You need to create one more table to build a many to many relationship. Build a one to many relationship between client table and the 3rd table based on client ID and one more one to many relationship between product table and 3rd table based on product ID. So you will get a many to many relationship in the 3rd table. Then you may create a view using 3 tables and display needed information on report. Please feel free to ask if you have questions.
  13. Where do you store those emails? do you have one email per record and you need to send emails to all the emails if the field? It would be great if you could describe a scenario. Also please note, there is a limitation in a number of characters in "to" field. You can enter up to 200 characters. You may find more info here
  14. Hi, as far as I know it's not possible to check if value is unique on the fly, you need to hit "Submit" anyway. I would recommend separating your form into 2 steps, like in this solution. First, user fills-out unique fields in submission form, then you may redirect user to update form where he can complete registration.
  15. Hello, Happy Holidays! Sure, it's possible, just remove "Select" from the Value field the when you configure the drop-down field. Please find more information here