Data validation
Use data validation to build no-code logic into your spreadsheets.
Last updated
Use data validation to build no-code logic into your spreadsheets.
Last updated
To get started with Data validation, right click a cell and use the expand menu. Select Data validation.
Data validation can also be found from the command palette (ctrl/cmd+p).
Results from data validations can be read by programming languages like Python, JavaScript, and Formulas in Quadratic. Combine code with no-code data validations to build unlimited logic and applications for your team.
You can create dropdowns from statically entered list or by reading from existing data in the sheet. In the following example the data in our dropdown is from column 3.
You can also search inside of dropdowns to filter for the criteria you're looking for.
Checkboxes resolve to TRUE or FALSE and can be read by programming languages. Note the following checkbox which is read into Python; if TRUE the code runs to calculate top 5 by set criteria, if FALSE the code doesn't run. You can use these checkboxes for all sorts of logic.
You can insert messages to cells using the message validation. In this example we describe where the data for this validation is coming from in a static message that displays each time the cell is clicked.
