Smart Table Search Example 

Step 1. In order for this feature to work two separate forms need to be constructed.  The first form is the form you will want to use as a reference. For this example, the form can be considered an Item Database. First begin by creating a form and giving the table name: item_inventory_scan_demo_db

Step 2. As mentioned earlier, this form should have a unique value.  In this example our unique value will be a barcode number. The barcode numbers will be entered by the user from the device side or uploaded beforehand to the data table via CSV. The form below shows an example of how the smart table form (item_inventory_scan_demo_db) should look like. Please note, all these fields will either be "Text", "Text Area", "Pick-List", or "Read-Only". Be sure to remember the data column name (DCN) you enter for each of these elements, as you will need to reference them in the next form.

Step 3. Create the Item Inventory Form.  This form is where the users will scan the item and the fields: Brand of Product, Model Name or Number, Building Name, Additional Notes on Product, Date Added to Inventory and Room Number will automatically be filled in for them, thus saving them time. For this example we copied the database form and changed the table name to: item_inventory_form. This form can include additional fields for the user to input data, such as the Manatee Works element to scan the barcode.

Step 4. In the element that will be used to look-up content/unique identifier (Barcode Number text field with the data column name barcode_number), click on the element and scroll on the right hand side under Element Properties down to Smart Table Search. Click the 'Assign lookup' button, search for the smart table name, in this case it would be item_inventory_scan_demo_db

–Table Name: item_inventory_scan_demo_db

–Column Name: DCN for the element used for the smart table (barcode_scanned_number)

This barcode_number element is what will pre-populate the rest of their information. This is the element that will call back to our database form. 

 

Step 5. After the unique identifier (barcode_number) is calling to the database form in the Smart Table Search, in all of the following elements that you want pre-populated, call to the database by placing the following function structure in the Dynamic Value of the elements on the Item Inventory Form.

database_table_name.dcn_element_in_database

Example: item_inventory_scan_demo_db.brand_of_product

  

Step 6. Before you sync your device you will want to select a Lookup Record Transaction Size. Hover over the Company Tab and select Company Info. Inside Company Info you will see Lookup Record Transaction Size under the Client Customization section. Select Edit Company Info and you can enter a size for each lookup record transaction from 1-500. This number determines the number of records that are downloaded in a single transaction. Previously records used for Smart Table Search are downloaded one record at a time and now they will be downloaded at up to 500 records at a time greatly decreasing the time it takes to download lookup records. 

Step 7. Next sync your device.  You will see the two forms you just created (Item Database: item_inventory_scan_demo_db  & Item Inventory Form: item_inventory_form ) appear in the device.

To see if STS is working, open up the Item Database form and enter in all the information.  Hit done, and sync. After syncing has completed, sync your device one time more. Open your item Inventory Scan Form, scan or type in the barcode number, and the rest of the fields will populate.