Can SQL be used to default values in Text type field Visual Builder Studio EFF?
Summary:
In additional person info, there is the multiple type record which requires a unique attribute, this unique attribute then becomes a required field and have to be a unique data. However not all data saved can always be unique and sometimes it is not required.
As seen in the document KB20428, a proposed workaround is to have a field that would take a sequence of number.
However as this is not a user-friendly method, as the user needs to check for the latest generated number and then +1 for the new record this does not seem.
Is it possible to use an sql query to retrieve the latest value, add 1 to it and default it into the value field in business rule?
Tagged:
0