Jump to content


Caspio Rockstar
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by Mathilda

  1. Hi Bill, I assume that you need a datapage to edit existing records. In case you want allow user edit his profile, you may use an update form. If you need to allow user editing more than 1 record, you may use details datapage or results page. As far as I understand, you'd like to allow editing a record only if data in one or more fields is missing. You may use predefined criteria with comparison type"Is not blank" for those fields. This way you will be able to filter records where fields are not blank. Hope that helps
  2. I see that one closing curly bracket } is missing. Try adding closing curly bracket before this line: document.getElementById("caspioform").onsubmit = Updatetocasd;
  3. I see that header and submit button are in blue color and results page is green, I think it doesn't look solid, however it's up to you. Also I would recommend adding date range, so your customers will be able to get data for a certain period, not for one date only. You can do that using criteria for the date field. The comparison type for the first criteria will be grater than or equal, so the second one - less than or equal. Don't forget to pass criteria parameters from the search datapage to predefined criteria on report. Hope that helps
  4. It seems that you posted your question twice. I replied here
  5. You need to use this script in the html block. Add html block, place it below all the fields, hit Source tab and insert your script. Also I would recommend using complete syntax InsertRecordAge instead of '@field:Age'. Integer datatype doesn't allow entering characters only on the table level in datasheet view. Hope that helps.
  6. Hi, Yes, it's possible, however you would need to create two separate datapages one for managers and another for team members. I suppose that you store team member ID (user ID) and team label (team A or team B )for each team member in the table which stores information about the user. Also I suppose that you stamp team member ID for each customer to identify who is assigned to the customer. Since those tables are related, I would recommend joining two tables in a view, use that view as a data source for report. For manager you need to set RLS settings to compare team label in the authentication datasource to the team label in the datasource view, so manager will see all the records, related only to his team. For team member you need to compare team member ID in the data source to team member ID in authentication, this way each team member will see only records, assigned to him. Hope that helps.
  7. Hi Juliette, As far as I understand you use calculated field. You may use CASE statement and check if the nickname has value. CASE WHEN Len([@field:Nickname])>1 Then '[@field:First_Name]' + SPACE(1) + CHAR(34) + '[@field:Nickname]' + CHAR(34) + SPACE(1) + '[@field:Last_Name]' ELSE '[@field:First_Name]' + SPACE(1) + '[@field:Last_Name]' END
  8. You can't use html tags in calculated fields. You need to use Java Script. As far as I understand, you need to show link only if the field is blank. I would recommend using the following script in html block <script> if ('[@field:connect_PIF_ER_eval_complete]'.length<1) { document.write('<a href="participant_evaluation.html?ER_ID=[@field:ER_Events_1_ER_ID]&Ev_Type=[@field:ER_Events_1_Event_Type]">Evaluation</a>'); } else { document.write('Evaluation Completed'); } </script>
  9. Hi, you may use the following script in the footer of the datapage: <SCRIPT LANGUAGE="JavaScript"> function calculate() { var check = document.getElementById("InsertRecordField_name").value; if(check =="Approved"){ var v_increment = parseFloat(document.getElementsByName("cbParamVirtual1")[0].value); document.getElementById("InsertRecordField2").value = v_increment+1; } } document.getElementById("caspioform").onsubmit=calculate; </SCRIPT> You need to use a virtual field to sort values in descending order and get the last submitted value, then increment value and write in a field
  10. You're welcome! Glad that it helped
  11. Yes, your workflow is more clear now. I updated script with additional condition: <script type="text/javascript"> window.onload=function myfunc(){ var check=document.getElementById("InsertRecordYour_field").value; if (check.length>0){ document.getElementById("caspioform").style.display = 'none'; setTimeout('document.forms["caspioform"].submit()',1000); } else { window.location.href = "specify_your_url"; } } </script>
  12. 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 submission form receives parameters, autosubmits itself and inserts a new record to your table. Hope that helps.
  13. I see that this post is old, however if someone else wants to do the same, you may use the script below: <script type="text/javascript"> function to_confirm() { var alertWindow = document.getElementsByClassName("Alert")[0]; alertWindow.getElementsByTagName("input")[2].click(); } document.getElementById("Mod0DeleteRecord").onclick=function to_delete() { setTimeout(to_confirm,1000); } </script>
  14. If the value is blank, the form will not be submitted. According to your first description it was the expected behavior What do you mean "not cancelling"? Redirect to another webpage?
  15. It seems that your parameters were cached. I would recommend clearing cache and cookies in your browser. How do you pass parameters? Do you see the same issue on deployed datapage?
  16. Hi Anthony, I think that cascading fields should help in this case. You may add records using submission form and filter orders based on user ID
  17. Hi, You may deploy datapages on different webpages. If you need to connect your application to 3rd party app, you may check these articles
  18. Hi, I use the similar logic in my view, view returns needed records. Perhaps there are no fields which match criteria. I usually filter table in the datasheet to verify that criteria works as expected. Also I see that in description you wrote that you filter records where Eval field=YES, however, according to the screenshot Eval field contains "Telemedicine". I don't know if that is the case, perhaps you just put wrong description. Hope that helps.
  19. 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.
  20. Hi, Do you receive parameters in fields? You may check field length and execute auto submission only when lengths is >0. You may also add more conditions and check more than 1 field. <script type="text/javascript"> var check=document.getElementById("InsertRecordField_name").value; if (check.length>0){ document.getElementById("caspioform").style.display = 'none'; setTimeout('document.forms["caspioform"].submit()',1000); } </script> You need you use InsertRecordField_name if you use submission form. In case of using update or details datapage the syntax will be EditRecordField_name Hope that helps
  21. Hi Esraa, Try using the following syntax: WHEN Charindex('''',[@field:TITLE], 0) <> 0 THEN Replace([@field:TITLE], '''',' ') Hope that helps
  22. I would recommend wrapping parameter name in single quotes, e.g.: '[@param_name]' This way you will be able to use parameter in sql query. In case of passing parameters to iframe, you need to use special syntax, try using this solution Hope that helps
  23. Hi Troy, welcome to forum You may use authentication to check is a user is in your table. If yes, user will get access to the datapage, if no he will get an error message. You may also edit error message in localization and create your custom message. Will that attachment always be the same for all the users? If yes you may use submission form with autosubmit script. If you need to take data from the table, you may use details page with autosubmit script. Hope that helps
  24. From your description it seems that you need to use many-to-many relationship and store brand name as well. I described how to build a many-to-many relationship here
  25. As far as I understand, you need to use field value as a link. You need to use HTML block with link and insert field parameter instead of "Click Here". Also you may use CSS to hide field and field name on results page. This post should be helpful.
  • Create New...