Question

How to check a field in a table against a single line field?

Forms

Updated February 9, 2016

asked on January 27, 2016

I have two columns in a table that I need checked against two respective single line fields. I'm trying to determine if Lot Check (hidden) has the same value as Stock Code Check (hidden). If they do not, I then need it to check AltKey2 (hidden) against 2AltKey2 (hidden). If those also do not match, I would like some sort of error message or warning to pop up letting the user know that these do not match. I have designated the fields that need to match up with an "x" or a "y". If either one match, then nothing needs to happen. My css classes are as follows -

Stock Code Check (hidden): SCCheck

2AltKey2 (hidden): 2AltKey2

Lot Check (hidden): LotCheck

AltKey2 (hidden): AltKey2

How would I go about doing this sort of check?

Thanks!

Two Part Check.JPG (48.2 KB)

| Download

0 0

Answer

SELECTED ANSWER

replied on February 9, 2016

Please see the comments with the resolution provided here.

2 0

Replies

replied on February 5, 2016

Hi David,

You can use Forms field rules to accomplish that. So show a table column when single line equals what you are looking for. I have attached a screenshot to give a better idea.

However, this does not provide the ability to have an error message or warning pop up if the fields do not match. To do so would require JavaScript.

Best,
Kevin

0 0

View 1 previous reply

replied on February 8, 2016

Kevin,

I don't know ahead of time what I want the table columns to equal. It's based on some other inputs from the user. I would also like to keep the columns that check hidden, and only show the necessary information. Any ideas how to use Javascript to accomplish this?

Thanks

0 0

replied on February 9, 2016

Kevin,

Is it possible to use the Field Rule to have the input field in the table equal the single line field? I only see that I can have it equal a specific number that I enter, not a variable. Is this possible?

0 0

SELECTED ANSWER

replied on February 9, 2016

Please see the comments with the resolution provided here.

2 0

replied on February 9, 2016

Sorry I'm a bit late to the party but glad to see that Michael was able to assist!

0 0

You are not allowed to follow up in this post.

Question

Question

How to check a field in a table against a single line field?

Answer

Replies

Sign in to reply to this post.