Address control is simply used to accept the Address in a composite manner in 6 different fields which can be later stored in 6 different columns of a sheet and used as separate entities.
The control has the following components:-
- Address Line 1 & Line 2 - these two components are used to capture Address
- City - this component is used to capture City
- State - this component is used to capture State
- Country (drop down) - this component is used to capture County
- Zip - this component is used to capture Zip code.
Properties of Address Control
- Label: Label is the text that is displayed above the Control and helps the user to understand what they are supposed to input in the text boxes.
- Properties: These properties help you customize the Label by changing the text size, weight ( Light, Normal, Bold, Extra Bold, X Extra Bold), alignment (Left, Center, Right, Justified) and color of the label.
- Type: The Type field is automatically generated depending upon the type of control used. In this case, it is “Address” type.
- Unique Names: A Unique name is used to uniquely identify a control in your App. Every control that is added on the screen gets an auto-generated Unique Name based on Label name given to the control. Since Address Control is a composite control and consists of 6 parts it has 6 unique names for each field.
- Submit Data: This field lets you determine whether to send the value of the control or not in Workflow based on various control states. There are three conditions that could be set for this field.
- Always: If this condition is selected, the data in the Address Control will be submitted irrespective of the state of the Address Control.
- Never: When this condition is selected, the data in the Address Control will never be submitted irrespective of the state of the Address Control.
- No When Hidden: When this condition is selected, the data in the Address Control will be submitted if the Address Control is visible and not submitted when the Address Control is hidden.
- Required: If you select the required option, the field becomes a mandatory field and the user can not submit without filling it.
- Read Only: If you select this option, the user will no longer be able to edit this field.
- Hidden: The hidden option helps you to hide the field from the user. This might help to perform some computation you don’t want the user to see or if you want to show certain fields only when a specific condition is met/not met.
- Caching: When the caching option is selected and if a LOOKUP formula is applied to this control, the value that the LOOKUP returns will be cached and the user will be able to see this value in the Control even when he accesses the microapp later with no connectivity. This option is required when you want your app to be accessible in offline mode as well and getting the latest data from the sheets always is not critical.
- Hide Label: This option hides the label of the Control from the view.
- Theme: The theme options lets you choose the color of the text box. You can either enter a custom hex code value or use one from the available themes in the builder.
- Placeholder: It is a prompt that gives a hint to the user as to what has to be written in a field. It is present in the field and is overridden when the user types something into it. You can set placeholders for each of the fields using the designated placeholder option.
- Tooltip: This option lets you display a message when the cursor is positioned over a field.
- Default Country: This option lets you set a default country for the Country code field which can be later changed by the user.
- Country Selectable: When the option is selected the user can change the country and set it to another country from a dropdown menu.
How to Use an Address Control?
First you need to select the Address Control form the Advance section of the Controls Menu.
The Address Control will then appear on the screen in the builder, you can then set all the above mentioned properties as per your requirements.
You can use the F option to bind data to each of the fields of the Address control and the V option to add validations to the field. You can learn more about validations here. There are four ways in which you can bind data to the Control.
- Static Data: By using the Static option, you can directly type in the text that you want to display.
- Sheet: The Sheets option allows you to get data from a sheet and display it in the Control.
- Control: Control options allows you to bind data to the Control by using another control’s value present in the microapp.
- Formula: The Formula options can be used to apply formulas and store the output of those formulas in the Control. You can learn more about formulas here.