Question

Do lookup tables not populate off of fields based on formulas?

Forms

Updated May 12, 2023

asked on August 18, 2020

I'm currently trying to pull in a rate for life insurance that is based off of age. I have the age being calculated in a number field with the following formula, where Date_of_Birth_PI is selected from a date field and Effective_Date_HSA is 10/1/2020:

=DATEDIF(Date_of_Birth_PI,Effective_Date_HSA,"y")

This correctly outputs the age of the individual filling out the form, but that age doesn't seem to be able to return results when used with a lookup table. The moment I remove that formula and either populate that age field manually or even make it read-only with a default value, it works.

Is there something I'm missing?

0 0

Answer

SELECTED ANSWER

replied on August 19, 2020

Another workaround would be to add a duplicate age field that's hidden but not read only, and use that for lookup. You can keep your Age field read-only and showing to display that to the user. Then you could also create a field called AgeHidden, use the same formula for it, and add a field rule to always hide it. For your lookup, you can use the AgeHidden field as the input.

1 0

replied on August 19, 2020

Thank you both!

It's funny you suggest that Jared, as that's exactly what I did! Threw in an =IF(Age=0," ",Age) formula as well to prevent a zero from populating prematurely. Thanks for the assistance guys, I really appreciate it, especially since this is on a form I have to have done by this afternoon!

0 0

Replies

replied on August 18, 2020

Hi Dylan,

Currently it is not supported to trigger lookup rule by read-only field filled by formula. We will update documentation to clarify the behavior.

As workaround, you may uncheck read-only property of the field, then make it read-only in JavaScript.

1 0

replied on May 1, 2023

Hi, will Laserfiche Forms ever support a lookup rule by a read-only field filled by a formula?

0 0

replied on May 6, 2023

Hi Jasciel, currently there is no plan for Forms to support this.

0 0

replied on May 12, 2023

I see, thanks!

0 0

You are not allowed to follow up in this post.

Question

Question

Do lookup tables not populate off of fields based on formulas?

Answer

Replies

Sign in to reply to this post.