Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • Layout Basics • Control Properties • SQL/HANA Tool • SMTP OAuth setup with Microsoft Exchange Online • Using APP Report Maintenance and Delivery • Scheduled Run • Supported Browser Platforms • Salesforce.com API • Versago & Bizweaver Templates • Introduction (WebService Tool)
versago3:from_settings

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
versago3:from_settings [2023/05/01 12:20]
dlee [Content] 		versago3:from_settings [2024/08/28 11:51] (current)
dlee [Lookup List]
Line 45: Line 45:
     * Only one field can be designated with this option.     * Only one field can be designated with this option.
  
- * **Character Length** defines the maximum number of characters that can be entered in a field of the control.+  * **Character Length** defines the maximum number of characters that can be entered in a field of the control.
     * For text fields the value can be less than the number of characters defined in the database if you wish to restrict the value entered.     * For text fields the value can be less than the number of characters defined in the database if you wish to restrict the value entered.
     * For numeric fields the value should be the maximum number of digits you want to accept in the field. Because of the way data is stored this may be greater than the number of bytes defined for the column in the database.     * For numeric fields the value should be the maximum number of digits you want to accept in the field. Because of the way data is stored this may be greater than the number of bytes defined for the column in the database.
Line 153: Line 153:
   - On the “Control Settings” tab, select “Textbox” as the Control Type.   - On the “Control Settings” tab, select “Textbox” as the Control Type.
   - Select the data view to be used from the Lookup Report menu   - Select the data view to be used from the Lookup Report menu
-  - The [ **…**] ellipsis button to the right of the Lookup  menu is used to define Input Fields (i.e. form controls (values) that can be used as input filters to the lookup report) and OutPut Fields (i.e. form controls that will receive their input value from fields in the user-selected record in the lookup report).+  - The [ **…**] ellipsis button to the right of the Lookup  menu is used to define Filters (i.e. form controls values that can be used as input filters to the lookup report) and Mappings (i.e. form controls that will receive their input value from fields in the user-selected record in the lookup report).
     - At least one Output field must be configured. This will be the control where the lookup is being applied and should be the value to be displayed to the user.     - At least one Output field must be configured. This will be the control where the lookup is being applied and should be the value to be displayed to the user.
-    - Additional output fields may also be defined. These are typically other values associated with the lookup value. See the simple example that follows. +    - Additional output fields may also be defined. These are typically other values associated with the lookup value. 
-   +  - The list of values in the lookup will be sorted according to the sorting configured in the look up data view. 
- +
-In this example, we use a lookup to present a list of U.S. states. We want the user to select the state by name, but we want to capture both the name and the associated code. +
- +
-{{  ::versago3:formv2image86.png?384x161  }} +
- +
-In this example the value “Name” is placed in the Column (control) named “Lookup1” and the associated code is placed in the Column (control) named “Lookup2.”+
  
-Note that the controls that receive values do not need to be visible on the form. In this example the “Lookup2” is not displayed to the user even though the value is captured. 
  
  
versago3/from_settings.1682958002.txt.gz · Last modified: 2023/05/01 12:20 by dlee

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
CC Attribution-Noncommercial 4.0 International Valid HTML5 Valid CSS Driven by DokuWiki