Jump to content
Salesforce and other SMB Solutions are coming soon. ×



Recommended Posts

In have two fields


Money Receipt > Text> Checkbox > value "Y"


Money Receipt Check > Calculation > Case(Isempty(MoneyReceipt),"",""Submitted") > text > Unstored



The problem is it is working in all records except two records. Whether the Money Receipt is checked or unchecked it is showing Submitted.


I do not know what could be the problem.



Link to comment
Share on other sites

a) make a temporary second copy, on your layout (not in field defs!) of MoneyReceipt.


b) format the second copy as a standard edit box. I bet you have some value in that field on that recor that is NOT "Y" and therefore the checkbox is not showing up as checked, but is nevertheless not empty.

Link to comment
Share on other sites



You are correct.


Initially the checkbox value was " YES", then I changed to "Y".


The two records were craeted before changing the value to "Y".


One more thing, since the calc contains "isempty", there got to be something in the field to give the result.


I should have thought of that.


Thank you very much.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use