Jump to content
Sign in to follow this  
actionman007

Determine non-empty fields

Recommended Posts

Hi,

Can I reverse this function:

If(IsEmpty(field1);"X";"")

so that if the field is not empty (has something in it) an X is marked in a corresponding field!

Cheers,

Dan :)

Share this post


Link to post
Share on other sites

If ( not IsEmpty ( field1 ) ; "X" )

Note that the default empty result is redundant in both versions.

Wouldn't you prefer to display the result as a checkbox, instead of "X"?

Share this post


Link to post
Share on other sites

You could also have reversed the result inside the If statement:

If( IsEmpty( field1 ) ; "" ; "X" )

Share this post


Link to post
Share on other sites

Hi,

Following on from my previous post,

http://www.fmforums.com/forum/showtopic.php?tid/186473/post/249111/hl//

How can I check if a specific date exists in a field, if it does then put a "X" in a corresponding field?

Cheers.

Edited by Guest

Share this post


Link to post
Share on other sites

you mean a tick instead of a check?

I mean a single checkbox that's either checked or not. For this, you need to define a value list, with a single custom value of 1. Set your calculation field to return a Number result, and change the formula to:

not IsEmpty ( field1 )

On the layout, format the field as a checkbox, using your new value list. Set the font color to the color of your background, and/or make the field narrow enough to show only the single checkbox.

See here for more fun with displaying Boolean (0/1) fields.

How can I check if a specific date exists in a field

You could check by:

DateField = Date ( x ; y ; z )

But it is not good practice to hard code data into calculations, and the question is not clear enough to suggest a better way.

Share this post


Link to post
Share on other sites

Hi,

What I have in the project is as follows,

Imagine a left hand column with titles of photographs/ works of art, then another column titled activity, with drop down value lists of marketing activity, such as "mail shot, email campaign etc" then next to each of these is a start date and an end date.

At the top of the page going from left to right, is a list of dates written as text, and underneath an empty field.

What I am aiming to do, is determine if the date at the top of the page is between the range of the one's selected in the start / end date and if so - to place a "X" or symbol in this empty field.

Hope this makes more sense?

Cheers,

Dan :)

Share this post


Link to post
Share on other sites

I am afraid you have lost me there. What is the purpose of this?

Share this post


Link to post
Share on other sites

It's to track marketing activity over a financial year, what we are doing on certain dates.

I will screen grab what I have done so far - and you can see...

Cheers,

Dan :)

Share this post


Link to post
Share on other sites

You're using FileMaker Pro -- it's a database not a spreadsheet. Databases can do a lot more than spreadsheets.

Perform a find using the date range, and FileMaker will only display those records that match the criteria.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.