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

Display a Field if there is data in a separate field


Recommended Posts

stacym

I am using Filemaker 12 Pro.  I created a table called Monthly Taxes. I am getting all my fields from the related table, Invoices.

I want to display the sales tax only if the invoice as been paid.  There are a couple of fields from the invoice that I could use to indicate the invoice has been paid;

1) Payment Status which is a drop down box giving 2 choices; Paid, Unpaid

2) Payment Date

The Monthly Taxes layout has these fields: Month, Payment Date, Taxes Amount and Taxes Amount Grand Total which adds up all sales tax from each month.  I created a new field called Show Tax Amount.  It is a calculation field.  I've been trying to write a script to perform what I want; display the Tax Amount data only if the invoice is paid.

I am obviously doing something wrong because either the tax amount always shows or it gives me a zero.

Can you help me?

Stacy

Link to post
Share on other sites

Join the conversation

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

Guest
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