Jump to content

NailDyanC

Caspio Rockstar
  • Posts

    392
  • Joined

  • Last visited

  • Days Won

    9

Everything posted by NailDyanC

  1. Hi, just to update this post. You may consider checking this workaround of this will help:
  2. Hello, just to add in the previous comment above. As I understand, you want to create a search field which can search to the 4 fields, right? If that is the case, on your table, add another field and set it to Formula. Then, concatenate the fields you want to use in your report. If all your field are in Text datatype , you can use [@field:FieldName1] + ' ' + [@field:FieldName2] + ' ' + [@field:FieldName3] + ' ' + [@field:FieldName4] on your Formula Field. Then, use this formula field as your search criteria, it should look like the attached screenshot. I hope that helps.
  3. Hi, just to add to the previous comment above. If you have created a Trial account it will be automatically be deleted after 14 days. All the resources and objects in your Caspio Bridge account will also be deleted.
  4. Hi, just to add, you may also consider checking and testing this formula: CASE WHEN [@field:Lucy]= 'TRUE' AND [@field:Stack] = 'TRUE' AND [@field:Edward] = 'TRUE' AND [@field:Sebby] = 'TRUE' AND [@field:Maria] = 'TRUE' THEN 'Account Manager' ELSE CASE WHEN [@field:Lucy]= 'TRUE' THEN 'LUCY' ELSE ' ' END + ' ' + CASE WHEN [@field:Stack]= 'TRUE' THEN 'STACK' ELSE ' ' END + ' ' + CASE WHEN [@field:Edward]= 'TRUE' THEN 'EDWARD' ELSE ' ' END + ' ' + CASE WHEN [@field:Sebby]= 'TRUE' THEN 'SEBBY' ELSE ' ' END + ' ' + CASE WHEN [@field:Maria]= 'TRUE' THEN 'MARIA' ELSE ' ' END END
  5. Hi, just to add in the previous comment above, you may also consider checking this video tutorial about conditional forms:
  6. For more details about calculated fields you may check these links: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/
  7. We reorder the arrangement of the formula that you have since the logic that our formula field is accepting is from top to bottom. However, I just want to clarify the workflow, you want to display only the names which is being selected in your checkbox and if all the checkbox is checked then “Account Manager”. If that is the case, can you please try this formula: CASE WHEN [@field:Lucy]= 'TRUE' AND [@field:Stack] = 'TRUE' AND [@field:Edward] = 'TRUE' AND [@field:Sebby] = 'TRUE' AND[@field:Maria] = 'TRUE' THEN 'Account manager' ELSE CASE WHEN [@field:Lucy]= 'TRUE' THEN 'LUCY' ELSE ' ' END + ' ' + CASE WHEN [@field:Stack]= 'TRUE' THEN 'STACK' ELSE ' ' END + ' ' + CASE WHEN [@field:Edward]= 'TRUE' THEN 'EDWARD ELSE ' ' END + ' ' + CASE WHEN [@field:Sebby]= 'TRUE' THEN 'SEBBY' ELSE ' ' END + ' ' + CASE WHEN [@field:Maria]= 'TRUE' THEN 'MARIA' ELSE ' ' END END
  8. Hi, just to add to the previous comment above, are you looking for a workflow like a running balance? If that is the case, you can use a calculated field instead. You may use this formula: (SELECT SUM(IsNull(Balance, 0)) FROM Running_Balance WHERE Date <= target.[@field:Date]) Balance is the name of the field where I store the amount and Running_Balance is the name of the Table. You may change these names based on your corresponding field names.
  9. Also, here's the link that you may consider checking for Calculated fields: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/
  10. Hi, just to add to the previous comment above. This can also be done in the DataPage level. If you would like to do it in this way. You may use a calculated field that will determine if that value is already existing in your table and just add a JavaScript that will prevent the form to be submitted if the value is existing: CASE WHEN (SELECT COUNT(field_name) FROM Table_name WHERE fieldname = [@field:fieldname] THEN 'Existing' ELSE 'Not Existing' END Then, you may add this JavaScript in the footer of your DataPage: <script> document.addEventListener('BeforeFormSubmit', clickHandler); function clickHandler(event) { var calc = document.querySelector("[id*=fieldID]").innerText; if (calc == "Not Existing"){ event.preventDefault(); window.alert("Submission BLOCKED!"); } else { document.location = "http://www.mysite.com/menu.html"; } } </script> Just change the field names and table names depending on the field that you are using.
  11. Hi, just to add in the previous comment above, you may also try to consider checking this workaround on how to get rid of that chatbox:
  12. Hello, just to add in the previous comment above. As I understand, you want to create a search field which can search to the different fields, right? If that is the case, on your table, add another field and set it to Formula. Then, concatenate the fields you want to use in your report. If all your field are in Text datatype , you can use [@field:FieldName1] + ' ' + [@field:FieldName2] + ' ' + [@field:FieldName2] .......... on your Formula Field. Then, use this formula field as your search criteria, it should look like the attached screenshot. I hope that helps.
  13. Hello, just to add in the previous comment above. As I understand, you want to create a search field which can search to the different fields, right? If that is the case, on your table, add another field and set it to Formula. Then, concatenate the fields you want to use in your report. If all your field are in Text datatype , you can use [@field:FieldName1] + ' ' + [@field:FieldName2] + ' ' + [@field:FieldName2] on your Formula Field. Then, use this formula field as your search criteria, it should look like the attached screenshot. I hope that helps.
  14. Just to update this post and add to the previous comment above, you may check this howto article about User Logs: https://howto.caspio.com/authentications-and-connections/users-log/
  15. Hello, just to add in the previous comment above. As I understand, you want to create a search field which can search to the 2 fields, right? If that is the case, on your table, add another field and set it to Formula. Then, concatenate the fields you want to use in your report. If all your field are in Text datatype , you can use [@field:FieldName1] + ' ' + [@field:FieldName2] on your Formula Field. Then, use this formula field as your search criteria, it should look like the attached screenshot. I hope that helps.
  16. Just to add in the previous comment above, you may also consider checking these forum posts:
  17. Just want to add to the previous comment above if you would like to know and start with Caspio. The first step in creating a web-based application is to build a normalized table. Make sure that the tables are well-architected accordingly to the needs of your application. You can click the links below: Introduction to Table and Table Design Data Normalization: https://www.youtube.com/watch?v=oexOYUUyQik One-to-Many Relationships: https://www.youtube.com/watch?v=IstAk982ntA Many-to-Many Relationships: https://www.youtube.com/watch?v=7D8u6Lb2BKU Caspio also has training materials that can help you in building your applications. You may want to visit them: https://howto.caspio.com/ https://howto.caspio.com/getting-started/ https://www.youtube.com/CaspioInc And if you have any platform related questions, I think Caspio Support is available 24 hours a day, 7 days a week now. Weekend support is limited to live chat, tickets, and emails. You can reach them through this contact details: Support Number: 650 691 0900 and choose Option 2 to reach Caspio Technical Support line.
  18. The first step in creating a web-based application is to build a normalized table. Make sure that the tables are well-architected accordingly to the needs of your application. You can click the links below: Introduction to Table and Table Design Data Normalization: https://www.youtube.com/watch?v=oexOYUUyQik One-to-Many Relationships: https://www.youtube.com/watch?v=IstAk982ntA Many-to-Many Relationships: https://www.youtube.com/watch?v=7D8u6Lb2BKU Caspio also has training materials that can help you in building your applications. You may want to visit them: https://howto.caspio.com/ https://howto.caspio.com/getting-started/ https://www.youtube.com/CaspioInc And if you have any platform related questions, I think Caspio Support is available 24 hours a day, 7 days a week now. Weekend support is limited to live chat, tickets, and emails. You can reach them through this contact details: Support Number: 650 691 0900 and choose Option 2 to reach Caspio Technical Support line.
  19. Hi, just want to add in the previous comment above, you may use a calculated field that will determine if that value is already existing in your table and just add a JavaScript that will prevent the form to be submitted if the value is existing: CASE WHEN (SELECT COUNT(field_name) FROM Table_name WHERE fieldname = [@field:fieldname] THEN 'Existing' ELSE 'Not Existing' END Then, you may add this JavaScript in the footer of your DataPage: <script> document.addEventListener('BeforeFormSubmit', clickHandler); function clickHandler(event) { var calc = document.querySelector("[id*=fieldID]").innerText; if (calc == "Not Existing"){ event.preventDefault(); window.alert("Submission BLOCKED!"); } else { document.location = "http://www.mysite.com/menu.html"; } } </script> Just change the field names and table names depending on the field that you are using.
  20. Hi @KAPITYAN, Can you please try to use this formula instead: str( [@field:Num1Address], 10, 6) + ',' + str( [@field:Num2Address], 10, 6) The formula above is another way to concatenate fields using other data types.
  21. Hi @mdeevers, I tried to recreate your workflow in my end and I was not able to get the error. I also use the same formula that you are using. The data type of the three fields is number. Below is the screen shot:
  22. Hi, just to add in the previous comments above, you may also consider checking this workaround:
  23. Hi, just to add to the previous comment above, you may also consider to try this formula: CASE WHEN CAST([@field:Photo] as NVARCHAR(max)) = '' THEN 'No Photo' ELSE [@field:Photo] END
  24. As I understand it, what you are trying to do is to add minute values to your timestamp based on when the field [@field:END_Pickup] is null? If the [@field:END_Pickup] is blank, the result of the formula should be the date on the [@field:Carrier_Date] + the number of minutes stated on the field [@field:ETA_to_Pickup]. If the above statements are correct, may you please try using this formula: CASE WHEN [@field:END_Pickup] IS NOT NULL THEN DateAdd(minute, [@field:END_Pickup], [@field:Carrier_Date]) ELSE 'END Not Provided'END I hope this helps.
  25. Just to add in the previous comment above, you may check this link about uploading files and images: https://howto.caspio.com/files-and-images/uploading-files-and-images/
×
×
  • Create New...