Conditional logic for Single Sheet
Conditional logic allows actions or fields in a sheet to respond dynamically based on specific criteria, displaying entries accordingly. Follow these steps to configure it:
- Enable Conditional Logic
- Locate the conditional logic setting and toggle the “Enable Conditional Logic” option.
- Set Conditions
- Define the criteria using comparison operators like
equals
,not equals
,greater than
, orless than
. - Conditions with “Starts With” or Ends with” logic for complex scenarios.
- Define the criteria using comparison operators like
- Save Changes
- Click the “Save” button to apply the conditions.
Conditional logic ensures a dynamic, user-specific experience by executing actions only when the criteria are met.
Examples:
- Display a field only if “your-name” is “David.”
- Display a field only if “your-email” is “[email protected].”
You can add additional conditions based on your specific requirements.
Notes: Conditional logic is context-dependent. Ensure you understand the scope of the feature you’re configuring (e.g., form fields).
Before saving, test the conditions to ensure they work as expected. This step helps avoid errors in execution.
Conditional logic ensures a dynamic, user-specific experience by executing actions only when the criteria are met.
Conditional logic for Multi Sheet :
Conditional logic allows actions or fields in a sheet to respond dynamically based on specific criteria, displaying entries accordingly. Follow these steps to configure it:
Here We add two feeds
For Feed 1 Configuration :
For Feed 2 Configuration :
For Feed 1 – Conditional Logic
To enable Conditional Logic:
- Navigate to the Conditional Logic section in the Feed settings.
- Toggle the option to Enable Conditional Logic.
- Define your conditions. For example:
- Field: “Reference”
- Condition: is
- Value: “Google”
- Save your settings to apply the logic. This ensures actions are performed only when the specified conditions are met.
For Feed 2 – Conditional Logic
To enable Conditional Logic:
- Navigate to the Conditional Logic section in the Feed settings.
- Toggle the option to Enable Conditional Logic.
- Define your conditions. For example:
- Field: “Reference”
- Condition: is
- Value: “Direct”
- Save your settings to apply the logic. This ensures actions are performed only when the specified conditions are met.
This setup ensures that the form submission will be sent to Sheet 1 if the “Reference” is “Google” and to Sheet 2 if the “Reference” is “Direct.” The entries will be logged in the respective sheets based on the defined conditions.
Notes: Conditional logic is context-dependent. Ensure you understand the scope of the feature you’re configuring (e.g., form fields).
Before saving, test the conditions to ensure they work as expected. This step helps avoid errors in execution.
Conditional logic ensures a dynamic, user-specific experience by executing actions only when the criteria are met.