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 autocomplete rules reference UDT Table, Value Set or Fast formula to lookup values for default?

Received Response


Defaulting payrollid and a large list of conditional values, too large to code big conditional statements, how can you accomplish?

Content (required):

Hello. We are new to using autocomplete rules and we are trying to work through defaulting payroll assignment/payrollid. We have numerous payrolls and a couple of them require us to look at a UDT table of values to find the correct payrollid. Can the autocomplete rule query a UDT table or a fast formula that can query the table or just call sql like in a value set?

An example UDT entry would be something like values below where the combination of the first 4 would get you the payroll relationship in the UDT.  

Howdy, Stranger!

Log In

To view full details, sign in.


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