You are viewing limited content. For full access, please sign in.

Question

Question

Forms and Lookup Rules

Forms
Updated June 12, 2024
asked on June 11, 2024 • Show version history

New user here. I am trying to build a form and am running into issues with one of my lookups.

varLocation. Lookup Rules work. Label: AHS = Value: 001.
varJobTitle. Lookup Rules won't work with Label: TEACHER = Value: 103.
It does work if my Label: TEACHER = Value: TEACHER




 

0 0

Replies

replied on June 11, 2024

What are the column types of your Location Code and Emp Type Code columns in SQL. Based on it working when swapping TEACHER -> value I'd assume it needs to do a string match not a numerical match. 

0 0
replied on June 11, 2024

Hi Zachary. Thanks for the response. They are all varchar.



0 0
replied on June 11, 2024

Hu, I reproduced this on my end and it works fine. Could you press F12 to open the developer console and then refresh the page and retry the lookup. The request we're looking for is lookup and the payload tab

using this SQL schema

 

0 0
replied on June 11, 2024

Hmm, it works for me when I try to reproduce it. Could you press F12 to open the dev console and then navigate to the network tab to search for 'lookup' and open the payload tab like shown here

the sql schema i'm using is:

0 0
replied on June 12, 2024

Appreciate you putting a second set of eyes on this Zachary. I rebuilt the form and the Lookups are working. Will have to look into Developer Console to troubleshoot the original form later. Thank you for your input!

0 0
replied on June 12, 2024

Glad its working for you! Was this a form you converted from classic forms to the new form designer?

0 0
replied on June 12, 2024

No. A brand new form. Hoping I don't run into this again!

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...