Search the Community

BLUF: does anyone have any suggestions on how to make a submission form's rules engine read the values from a virtual calculated field? i am using virtual calculated fields in a submission form to query five boolean variables in another table which specifies which of the five fields in the form should be required (this is customizable by the user through a separate form). the queries successfully execute and i am getting expected results (i.e. 'Yes' and 'No' for each of the five variables), which are based on the user's selection of a profile in a dropdown in the same form (e.g. profile a, profile b, profile c, which, again, they configure through another form). the queries are dynamic...they correctly recalculate as the user changes their 'profile' selection. i've attached a screenshot of the interface. i need to use these virtual calculated fields ('Yes' and 'No') values in the form's rules so that i can specify which of the fields are mandatory based on the selected profile. though the rules engine seems to be able to distinguish between 'is blank' and 'is not blank' on the virtual fields, it seems incapable of reading the values. that is, i have tried "virutal field 1 is equal to Yes" (or 'yes' or 'true' or 1)....and nothing works. does anyone have any suggestions on how to make the rules engine read the values from a virtual calculated field? p.s. for the form submission, i am using a view which joins the profile table with the test entries table. however, since only the test entries are editable in the view, i don't have access to the profile values (even though they are duly joined through the view) and therefore can't use them directly in the rule. this is why i have had to resort to using virtual calculated fields with sql queries.

Section 2 does not appear on the drop down list of fields that can interact with rules in my submission form. I am aware that same field or section already used in another action will not be available. However, in this case the section does not appear even though it is not used anywhere yet. Any thoughts on this?

I have several sections in my submission form that I cannot use in my new Rule. They do not appear in the Action list. Can someone help?

The main goal is to have a pre-defined on-load multi-selected listbox. The listbox element uses Cascading dropDown virtual element. It should hide some sections if 1 element selected and hide others if 2 elements are selected. Can anybody help me with the Caspio or maybe JS solution? Thanks.

Hopefully I can explain this. Three Fields: A= Yes/No B= Dropdown choice with an "other" option C = Other field if OTHER chosen in dropdown B. If A = No, hide B and C Having trouble getting B and C to appear/hide based on values because I think you can only use a rule on one field at a time. Example: A = Male? (Y/N) , if Yes show B, keep C hidden still. B = Dropdown with "other" option. If other chosen, then show C, the other text field. But the rule stating to hide B and C does not allow me to apply another Rule for C. I can get B and C hidden or shown at same time only. Hope that makes sense. Way around this?

Hi everybody, I'm not sure where to submit bug reports, I'll just do it here. In a web form I added rules to hide certain input fields depending on the value of the field "type". Rule 1 makes the field "checkbox" hidden: Now in Rule 2 I cannot select the field "checkbox" at all: After removing "checkbox" from rule 1 ... ... I can select "checkbox" in rule 2: My guess is that this is a bug but correct me if I'm wrong. Regards, Tobias.

Say I have 3 tables; Users, accounts, assets. A user is completely unique and has a one to many relationship with Accounts. Accounts has a one to many relationship with Assets. I want to create a form for adding new assets. The person needs to select which account the asset belongs to. Given multiple users, each with numerous accounts - simply having a full drop down list of all the possible accounts is not feasible. How do I create a form with a "user" dropdown where the "accounts" dropdown only shows values linked to the selected "user"? Thus filtering the possible accounts to just the ones belonging to a specific user? I have played with rules but cant seem to find a way.

I want to include an HTML reminder text on a form when a specific field on a form is a certain value. Hint/Tip not what I want since its hidden unless licked. I want some RED text to appear is form field = X. I can get the text to display on form with HTML block. But using Rule Conditions I cant choose to hide the HTML block, only actual fields. Way to apply rule/condition to an HTML block?

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!

Hello, I have a Search and Results web page (simular to what is described here.. http://howto.caspio.com/tech-tips-and-articles/parameters/add-a-search-interface-to-results-sets-page ). The web page has a search submission form and two different results data pages (report1 and report2), both results pages receive parameters from the submission form and display tabular reports on the web page as expected. So far so good. The first virtual field in the submission form is a dropdown that offers the selections "report1 and report2, passing that parameter as [@report] on exit. How can I display/hide the results pages depending on the [@report] parameter received. Any and all suggestions are greatly appreciated.

Hello, I have a form with 10 survey questions. 4 of the questions have "If no, please provide feedback" and then a new input text field appears under the initial radio buttons. I use the Rules to hide the Feedback Inputs until the radio button selection is made to trigger them to show. For example: Would you participate in the event again next year? If No - why not? oYes oNo *If "No" is selected then a new field appears below radio buttons: Provide Feedback: --------------------------------- Text Area Input Box Here -------------------------------- Now, the bug -- When the Feedback Fields are made visible, and I then type something in them, the values of any of those 4 fields (that use the Rule "Hidden" function) don't pass the value(s) into the data table once a submission is made. No data is captured at all (for those hidden input fields only). Am I missing something? Or, is this a known bug? Or, is this new? Any help is greatly appreciated. Thx and best Regards, Geoff

In a detail page I have a field that is a check box, I also have a virtual field that displays text. When the checkbox is NOT checked I want the virtual field hidden. For some reason the rules do not allow me to "hide" any virtual fields. Any suggestions why?