Jump to content

This topic is 7953 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Hi,

I have a Field, "Status" which has two radio buttons, "accepted" and "not accepted." When records are added to the database neither option is selected. I then go through the submitted records and click one or the other. I was wondering if there is a way to select the records with an empty field (with neither "accepted" nor "not accepted" selected) in a CDML URL so I can show all of the new records in a display page. I thought I could use:

&Status=""

Where the empty double quotes would act as a null value. This has worked for me in a pop-up menu in the past. Will I have to use an FMP-IF statement to accomplish this? Below, I have included an URL which works in another situation. The only thing I would like to change is the "&Status=yes" part.

FMPro?-DB=CSMLCalendar.fp5&-Format=calresults2.html&Status=yes&CurrentDateTest=0&-SortField=Month&-SortOrder=descending&-Sortfield=Day&-Sortfield=Year&-max=5&-Find

Thanks,

Darryl

Posted

Hi,

Found the answer in another thread (create another calculation field in the DB which determines if the field in question is empty or not and use this field in the Search string).

Darryl

This topic is 7953 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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