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

Question

Question

Lookup Fill Rule With Multi-line Field?

asked on February 22, 2018

Using Forms 10.2.1.205 and 10.2.1.246 I have a multi-line field that has a lookup Fill rule associated with it (no when). It lets me create the rule, but when I go to select the multi-line field I am displayed with options like I am with a single line field. Is this supposed to work?

1 0

Replies

replied on February 22, 2018

A multi-line field is still treated the same as a single line as far as data lookups are concerned, i.e., they are both still single-value fields receiving multiple values from the lookup. Seems counterintuitive at first, but this behavior does make sense because even with multiple lines there is still only one string/value.

Two ways around this would be to store all the values in a hidden table/collection and try using a formula to put them all into the multi-line (I believe this would separate them by commas), or by creating a stored procedure that concatenates the values with line breaks into a single result string that will go into the field.

0 0
replied on February 22, 2018

Jason,

So what I'm saying is that it is not behaving the same as a single field. With a single line field I can have just a fill lookup rule to allow users to type something in the field or select from a list that is populated from the lookup. When I do the same thing with a multi-line field it does not give the options from the lookup rule.

1 0
replied on February 22, 2018 Show version history

Oh right, yea it won't do that as far as I know. My guess is that it has something to do with one being an input element and the other being a textarea element.

Maybe a feature request? Seems like it should be possible and it would be beneficial.

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

Sign in to reply to this post.