Chalkline a Google Sheet add-on designed to integrate a set of common used tools to imporve the usibility forGoogle Sheets.
We currently support a quick filters with the single click solution and an eaiser filter with Regular Expression by using formula REGEXMATCH.
We currently support a quick filters with the single click solution and an eaiser filter with Regular Expression by using formula REGEXMATCH.
Feel free to download and install, check the video instructions here on YouTube.
Filter with Single Click
The add-on in the sidebar provides you a quick shortcut to filter your dataset much easier, select a cell and apply a filter from the sidebar.
- Example 1: we can select a cell like A12 with the value Better Filter, click the button EQUAL TO to apply a filter equal to “Better Filter”.
- Example 2: we can select a cell like B12 with the value 7, click the button LESS OR EQUAL to apply a filter less than or equal to 7.
Filter with Regular Expression
The add-on in the sidebar also provides you an eaiser way to apply a regular expression filter to your dataset.
- You can select a target column to preview and apply the regular expression filter.
- Enter your regular expression.
- You have option to enable or disable Case Sensitive and Multiple Line.
- Create Preview will create a preview of the matches in the sidebar so you can test your regular expression in the sidebar.
- Apply button will apply your filter in current dataset.
Form Automation
We have an automation feature that can automate below tasks.
- UID generation for form submissions.
- UID column header
- UID prefix
- UID digits
- Generate PDF for the form response with a Google Docs or Slides as a template with placeholders.
- Template with slides or docs
- Trash slides copy or docs copy
- Trash PDF
- Send email to respondent when the form is submitted.
- Subject template with text placeholders
- Header name of Email address in form responses
- Message template with text placeholders
- Use PDF as attachment