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

Question

Question

Cloud: Lookup rule adding extra row(s)

asked on November 8, 2023 Show version history

Hi all, 

In the Business Processes ->Form, I created a query rule to use as a lookup rule to populate a table inside a form.
I have min and max 1 rows so if there is no data, at least one row will be available for data input.

The fields inside the form are set like this:

The lookup rule has the fill fields as new rows for all of the fields I'm populating.

For some reason it's adding 3 extra rows.
In another form, it adds 1 row.
In another form it works as expected. 
I've double checked to see if I'm missing something between the one working and the ones that aren't but there isn't anything that I could tell. 
Has anyone run into this issue?

I have had it like this on our on-prem LF and it works without any issues. I'm currently trying to convert on-prem lookups to work the same in the cloud.
Do I need to reach out to my VAR?

Edit: It looks like it adds 2 rows no matter what min I set it in the Advanced settings.

 

0 0

Answer

SELECTED ANSWER
replied on January 11, 2024

To anyone who runs into this issue, it's due to the way the lookup rule is setup.
If you look at the documentation, it doesn't say you have to do it a certain way. The way I got my lookup rule to work so far is by selecting the Fill this way(Table layout):
Date-> Digital Temp-> Therm. Temp-> etc

If you do fill this way:
Acceptable Y/N -> Date -> Digital Temp - > etc

Which is alphabetically and how it shows in the dropdown when you start trying to fill it out, you will run into the issue I did. I reported this with my VAR as well. 

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.