The Quantity control is an Advance control that is used to enter the quantity and can be used in microapps where the user has to specify the number of certain products or other elements.

Properties

UI Properties

  • Label: Label is the text that is displayed above the control and helps the user to understand the purpose of the Quantity Control.
  • 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 a “quantity” type.
  • Unique Name: 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 on the basis of the Label name given to the control. Since Quantity Control is a composite control and consists of two parts it has two unique names for Title and Value.
  • 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.
  1. Always: If this condition is selected, the data in the Quantity Control will be submitted irrespective of the state of the Quantity Control.
  2. Never: If this condition is selected, the data in the Quantity Control will never be submitted irrespective of the state of the Quantity Control.
  3. No When Hidden: When this condition is selected, the data in the Quantity Control will be submitted if the Quantity Control is visible and not submitted when the Quantity Control is hidden.
  • Required: If you select the required option, the control becomes a mandatory field and the user can not submit the form without updating it.
  • Read Only: When 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 field even when the user 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 field from the view.

Properties

  • Theme: This lets you choose the color of the control. You can either enter a custom hex code value or use one from the available themes in the builder.
  • Text: This displays the element whose quantity is being entered by the user.
  • Properties: This lets you customize the look of the text by setting the text size, weight ( Light, Normal, Bold, Extra Bold, X Extra Bold), and color of the label.

How to Use a Quantity Control?

Start with selecting the Quantity Control from the Advance section of the Controls Menu.

The Quantity Control will then appear on the screen in the builder, you can then set all the above properties as per your requirements.

You can use the F option to bind data to each of the fields of the Quantity 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 text field.

  1. Static Data: This allows you to directly type in the value that you want to set.
  2. Sheet: This allows you to get value from a sheet and display it in the control.
  3. Control: This allows you to bind data to the control by using another control’s value present in the microapp.
  4. Formula: This can be used to apply formulas and use the output of those formulas to set the control. You can learn more about formulas here.

Preview

Did this answer your question?