Hide Field command messes up the input.Field value ...

Hi:

I have the following code in a Stateless Form's on Load section ... it is meant to be called from another Stateless Form with the StoreNumber passed in the url

Hide StoreNumber;
if (count(Stores[StoreNumber == input.StoreNumber])  >  0)
{
 //get record from Stores Table
 thisStore = Stores [StoreNumber == input.StoreNumber];
 etc. etc.

In order to prevent someone from directly requesting this Stateless Form, I make a check to ensure that there is no matching Stores record.

But it does NOT work ... the StoreNumber value from the previous transaction seems not be cleared from cache.

However, if I change the order of instructions like so ...

if (count(Stores[StoreNumber == input.StoreNumber])  >  0)
{
    //get record from Stores Table
    thisStore  =  Stores  [StoreNumber == input.StoreNumber];
    hide StoreNumber;
    etc. etc.

... everything works as expected.

Looks like the mere act of hiding a field causes ZOHO Creator to mess up ... this should NOT happen ... took me a long time to find this workaround ... and required a lot of unnecessary script changes in a number of such Forms ... this needs to be fixed urgently ... so Developers don't have to have these work arounds in all their Apps.

Gaev