AutoFill

The Field Autofill functionality in Ucode is a powerful tool designed to streamline data entry processes by automatically populating fields based on relationships between tables. This guide will walk you through configuring and using the Field Autofill feature with clear steps and practical examples.

Part 1: Creating Tables and Establishing Relationships

1. Source Table: Orders

Begin by creating a source table that will act as the data provider for autofill. In this example, we’ll use a table named Orders, which stores the following fields:

• Order Number: Unique identifier (e.g., 101, 102, 103).

• Shipping Address: Locations like Uzbekistan, USA, France.

• Shipping Method: Delivery methods such as Standard, Fast, Express.

This table serves as the primary source for autofill functionality.

2. Target Table: Shipping Information

Next, create the target table, named Shipping Information, where autofill will be applied. Add the following fields:

• Order Number: Relation field linked to the Orders table.

• Shipping Address: A field that will be autofilled based on the selected Order Number.

• Shipping Method: Another field to be autofilled.

Note: If you’re unsure how to create relations, refer to our [Relation Setup Guide] for step-by-step instructions.

Part 2: Configuring the Autofill Functionality

1. Accessing the Field Settings

1. Open the Shipping Information table.

2. Navigate to the Settings section and select the Fields tab.

3. Locate the field you want to configure for autofill (e.g., Shipping Address) and click the Edit button.

2. Enabling Autofill for Fields

For Shipping Address:

1. In the Autofill tab, select the Source Table as Orders.

2. Map the Shipping Address field from the Orders table to the Shipping Address field in the Shipping Information table.

3. Click Save to apply the configuration.

For Shipping Method:

1. Similarly, edit the Shipping Method field and go to the Autofill tab.

2. Choose the Source Table as Orders.

3. Map the Shipping Method field from the Orders table to the corresponding field in the Shipping Information table.

4. Save your changes.

Part 3: Testing the Autofill Configuration

1. Adding Data to the Target Table

1. Open the Shipping Information table.

2. Toggle all fields to visible from the Columns section.

3. Click the + Add Object button to add a new entry.

• Choose Order Number: 103.

• Autofill retrieves:

• Shipping Address: France

• Shipping Method: Express

• Save the data.

Benefits of Field Autofill

• Time-Saving: Eliminates repetitive data entry.

• Accuracy: Reduces errors by pulling data directly from source tables.

• Efficiency: Streamlines workflows, especially when working with large datasets.

Congratulations! You’ve successfully configured and tested the Field Autofill feature in Ucode. By leveraging this functionality, you can automate data entry, improve accuracy, and create a seamless workflow between related tables.