Question

Forms

Updated November 7, 2019

asked on November 6, 2019 • Show version history

=IF( INDEX(tbl_timecard.Num_LunchIn, ROW()) = "" , 1.00 ,  0.00)

I have a larger post on this whole issue but I wanted to isolate to where I see this breaking initially.

The Boolean statement of the IF above doesn't work when using the INDEX() value in a row where equal to BLANK.

Any ideas?

0 0

Answer

SELECTED ANSWER

replied on November 6, 2019

What type of field is it (i.e., single line, number, etc.) because that could potentially play a role.

For example, I'm 99.99% sure numeric fields actually equal 0 when blank.

2 0

replied on November 7, 2019 • Show version history

Not sure why I can't mark this as an answer anymore. But this is 100% correct. Once set to 0 for the number field it worked perfect.

Working logic:

=IF( INDEX(tbl_timecard.Num_LunchIn, ROW()) = 0 , 1.00 ,  0.00)

1 0

replied on November 7, 2019 • Show version history

I believe you can only mark something as Answered if the original post is set as a Question instead of a Discussion.

0 0