Automation
Cell Tools
4min
Cell Tools are ideal for automating data extraction from within single table cells.
At a high level, Cell Tools look for cells that exist at the intersection of a column and a row. This can be designated via header, index, or regex. Once the Cell Pattern finds a cell at an intersection of a qualifying header and row, they extract the data inside that cell and assign it to a Schema Field.
To create a Cell Tool:
- Within the Kit associated with the Schema you'd like to work with, locate the Field you want to place data into. In this case, we are working with our Primary Schema, Performance Report (refer to Pattern Creation and Editing for a refresher)
![Document image Document image](https://images.archbee.com/5NdwKZ3fWZT6oX-rA7jJu/vRgymhMJeJdEBFqFTtNxp_add-tool-slate2x.png?format=webp)
- Click "Add Tool" and select "Cell Tool"
![Document image Document image](https://images.archbee.com/5NdwKZ3fWZT6oX-rA7jJu/9rthQMYcptA_P8VwHBfgT_add-tool-menu-cell2x.png?format=webp)
Enter a “Row String” and a “Column String”. You can also identify a row or column by its index or by "regular expression", which is detailed further in Text Tools
- The “Row String” is the name of the row that the targeted cell is contained in
- The “Column String” is the name of the header that the targeted cell is contained in
![Document image Document image](https://images.archbee.com/5NdwKZ3fWZT6oX-rA7jJu/G6Ddi3byg2wJv0d_9F2Fp_cell-tool-config2x.png?format=webp)
- Click "Save Tool"
- Repeat this process for as many Fields as you need to extract via Cell Tools
- You now have automated cell extraction!
![Document image Document image](https://images.archbee.com/5NdwKZ3fWZT6oX-rA7jJu/ifgEjX54ffKSIWZYOH-8U_dv-cell-tool2x.png?format=webp)