Search the Community

Hi I would like to have a search field that has the ability to search using ranges. Currently, I am using criteria to do this but I'm wondering if there's an alternative option aside from this. Is there a different way to apply ranges for my DataPage?

Hello! Is there any performance benefit to filtering results in the View vs. Data Page? Thanks

Hi, I have a trigger action that send an email when a new record have some parameter out of range. But every time that a new record accomplish with this condition the triggered action send me an email for each record that accomplish with the conditions.

Hi there, Could anyone help me to resolve the issue with the following search logic scenario: a user can search by Date field with "from&to" range with criteria, but if criteria are blank I would like to return records with blank Date field Field datetype: Date&Time Thanks, @Vitalikssssss

I'm trying to use SOAP SelectDataRaw call to query my table and I want to use "LIKE" in the criteria section but I'm not able to. Criteria would be similar to: Name LIKE 'jame' to get result "James" (where yes, James is in the table). I've tried: Name LIKE 'jame' Name LIKE '*jame*' Name LIKE *jame* How do I query the table to return results where only a portion of the field need be identified???

I would like to add a rule to a data page that prevents a user from selecting an erroneous date, ie anything after a certain like the current date or something after a age limit for the application. When I try to choose greater than or equal to for the birthday calendar field, it does not allow me to add a condition that prevents the user from proceeding. Is there a way to do this inside the data page? Thank you.

I need to display a link after a certain time/date (essentially "now" compared to the date entered in the record) in a table. (IF date.table IS AFTER NOW then show this link: http:...) Using rules and sections seems to make the most sense, except I can't figure out the criteria settings. : Condition, Operator, Value. If it's possible to do this right in the HTML/JS, that's cool too. (the script checks to see if someone has completed the form, and displays one of two different links) <script> if ('[@field:connect_PIF_ER_eval_complete]'.length<3) { document.write('<a href="https://www.seaetc.com/participant-dashboard/event-evaluation/?ER_ID=[@field:ER_Events_1_ER_ID]&Ev_Type=[@field:ER_Events_1_Event_Type]&join_ID=[@calcfield:1]" class="et_pb_button_caspio_compeval">Complete Evaluation</a>'); } else { document.write('<a href="../participant_certificate.php?fn=[@authfield:First_Name]&ln=[@authfield:Last_Name]&cred=[@authfield:Credentials]&er=[@field:ER_Events_1_Title]&date=[@field:ER_Events_1_ER3*]&ce=[@field:ER_Events_1_ER17_Total]" target="_blank" class="et_pb_button_caspio_viewcert">View Certificate</a>'); } </script> thx!

When using dropdown in a form, I would like to be able to search in a dropdown with the criteria "Contains". Now, if I type "C", the cursom jumps to the first Item in the list that starts with the letter "C". Is it possible to narrow down a search in a dropdown when typing and where only items that contains the text I typed are displayed?

JS code snippet below will copy value from one criteria field to another:

Hello; I am trying to create a view in which I would like to use multiple criteria on one field to filter the data. i.e. RecordID <> 101, 109, 117, 131, 140 When I attempt to do this Caspio tells me "Invalid value - Value Must Be A Number" Is there a workaround for this? Thanks!