Question

Partial Field Lookup [Forms]

Forms

Updated January 27, 2015

asked on January 26, 2015 • Show version history

Looking to evaluate the first 5 characters of a Single Line field using a Lookup Rule. When my form matches on 3 fields (LastName, FirstName, & ID #), it needs to populate a hidden field flagging it as "Clean" as they are filling it out and prior to hitting Submit.

Another detail: The field in question are stored in separate tables on the same form.

How do I get this accomplished? I have the SQL View to use but unsure how I can compare the first 5 characters of of each of the field names.

0 0

Answer

SELECTED ANSWER

replied on January 27, 2015

Both will be setup when designing the form.

Both will apply when filling out the form.

1 0

Replies

replied on January 27, 2015

Hi there,

There are two ways to compare partial field.

1. Using javascript to get the first 5 chars and put it in a hidden field, lookup using that hidden field

2. Using stored procedure and implement compare first 5 chars logic in the stored procedure

1 0

replied on January 27, 2015

Thank you... Are both solutions something that can be performed while filling out the form?

0 0

SELECTED ANSWER

replied on January 27, 2015

Both will be setup when designing the form.

Both will apply when filling out the form.

1 0

You are not allowed to follow up in this post.

Question

Question

Partial Field Lookup [Forms]

Answer

Replies

Sign in to reply to this post.