NailDyanC

Hi, just to add in the previous comment above, you may consider checking this workaround:

Hi, just to update this post. Here's the new and updated link of the automatic emails/acknowledgement emails that you can check: https://howto.caspio.com/automatic-emails/acknowledgement-and-notification-emails/

Hi, just to update this post. You may consider checking this workaround of this will help:

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.

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.

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 ' '

Hi, just to add in the previous comment above, you may also consider checking this video tutorial about conditional forms:

For more details about calculated fields you may check these links: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/

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 '

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.

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/

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

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:

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.

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.