You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Can SQL be used to default values in Text type field Visual Builder Studio EFF?

edited 1:29PM in Human Capital Management

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!