In another stateless form's onLoad event, I am testing the value of the Year field on the Year Records form and it seems there is no way to determine whether the value is null or not null as both the statements below return false:

Year_Records[Name == "Two"].Year == null

Year_Records[Name == "Two"].Year != null

I am referring to this sheet -  https://sheet.zoho.com/publishrange.do?id=0d9c0b681f5501ffcf6f935a335ab5e6 but the Lookup field (empty/null/no value) is not working as specified in the sheet.

I added a simple number field to the Year Records form and that returns a null value in the Stateless form's onLoad event as expected.

Regards
Moiz Tankiwala
Smart Training & IT Solutions