Customize forms with Database Integration
Available for:
The Form feature allows you to capture data related to your counted objects, import data about your items and export the Form to a CSV file.
This material will guide you through the steps of creating and customizing forms with database integration using the CountThings from Photos app. In this example we will integrate an Excel database containing Products (types of products), Size and Length into our Form. In the second part of this guide, you will see how to use and export your Form.
Please make sure that before starting your counting process using the Form, you have the appropriate counting templates downloaded from Template Library.
Create and customize your Form
Home Screen ➜ Settings ➜ Forms ➜ Click +NEW FORM ➜ Give a relevant name to your Form in Form Title (e.g. Metal products) ➜ Click Ok
We already know that in our Form we want to add 3 main values about our metal products (product, size and length), so we will add 3 dropdowns by clicking the “+” button 3 times ➜ Close.
1. First Dropdown settings (to import the types of products we are working with).
A. Select the first Dropdown (when selected, the Dropdown field has a blue background)
B. From Properties ➜ uncheck Reset with new image and check Change template based on value.
C. From Import Values from ➜ Select CSV / Excel ➜ Click Import.
D. Select the column to import (e.g. Product) ➜ Click Ok
E. From Values ➜ Set the Counting Template for each type of product using the generated dropdowns.
2. Second Dropdown settings (to import the sizes of products).
A. Select the second Dropdown (when selected, the Dropdown field has a blue background)
B. From Properties ➜ uncheck Reset with new image and check Change template based on value.
C. From Import Values from ➜ Select CSV / Excel ➜ Click Import.
D. Select the column to import (e.g. Size) ➜ Click Ok
3. Third Dropdowns settings (to import the length of products).
A. Select the third Dropdown (when selected, the Dropdown field has a blue background)
B. From Properties ➜ uncheck Reset with new image and check Change template based on value.
C. From Import Values from ➜ Select CSV / Excel ➜ Click Import.
D. Select the column to import (e.g. Length) ➜ Click Ok
4. Click Save & Exit.
5. Save again in the Settings Window that will automatically appear.
Export settings
6. If we want to export in a CSV file all the counted results with the imported data:
A. Click Settings.
B. From the left side of the Settings Window, click CSV/Export.
C. Make sure that you have your Form selected in Add Items From Forms field.
D. From Form Items field ➜ check Use All.
E. Click Save.
Use the Form
7. Count from a photo with Square Tubes
A. Open your photo.
B. Open the Form Filler (using the small arrow from the right side of the screen).
C. Select your Product (e.g. Square Tubes), the Size (e.g. 1/2) and the Length (e.g. 20’0”) from the Dropdowns. (the Counting Template will be set automatically when you choose the Product)
D. Click Count.
E. Click Save.
We will repeat the process from step 7 for the other types of products imported, using the sizes and the lengths relevant for us.
8. Count from a photo with Rebars
A. Open your photo.
B. Open the Form Filler.
C. Select your Product (e.g. Rebars), the Size (e.g. # 5(16)) and the Length (e.g. 24’0”)
D. Click Count.
E. Click Save.
9. Count from a photo with Angle Bars
A. Open your photo.
B. Open the Form Filler.
C. Select your Product (e.g. Angle Bars), the Size (e.g. 2 x 2 x 1/8) and the Length (e.g. 40’0”)
D. Click Count.
E. Click Save.
10. Count from a photo with Round Tubes
A. Open your photo.
B. Open the Form Filler.
C. Select your Product (e.g. Round Tubes), the Size (e.g. 5/8) and the Length (e.g. 20’0”)
D. Click Count.
E. Click Save.
11. After we finished our counting process, click on the Green Saved button
12. Open the generated CSV file.
13. Here we have all the counted results and the additional data of the counting process.
For more information, please contact our
Support Team at
support@CountThings.com.
You can also request a
virtual meeting with our experts to discuss how we can offer you the best counting experience.