populate table with lookup

replied on April 19, 2019

The "as new rows" option is not available when the condition(s) of the lookup are part of a table/collection. I don't know the exact reason, but I imagine it is because it could easily create a lot of overhead that would impact load times.

0 0

View 2 previous replies

replied on April 24, 2019

Thanks so much! Maybe I'll create a stored procedure to see if that works.

0 0

replied on April 30, 2019 • Show version history

Turns out I got the same result with a stored procedure. I can see on Laserfiche Answers where some people have accomplished what I'm trying to do (populate a multi-row table) however I can't see what they are doing different to get the "as new rows" checkboxes to be active. My input parameters are outside the table. Thanks!

0 0

SELECTED ANSWER

replied on April 30, 2019

Although your input parameters are outside of the target table, if they are in any table/collection the option still wouldn't be available.

Are you saying they are normal fields?

0 0

replied on April 30, 2019

Jason, I see what you're saying and the parameters are not present in the table where I would like to see the results load. The 2 parameters are normal single line fields that are used as parameters in the stored procedure; they are not returned in the result set and are only used in the Where clause.

0 0

replied on April 30, 2019

I believe I just got it. My parameters weren't normal fields, I had forgotten they are table fields. After I created new parameter fields as normal fields, I got my checkboxes. Thank you so much for your help!!

0 0

Question

Question

Answer

Replies

Sign in to reply to this post.