Pop-up Menu with value chosen

[wkirklutz]

Sorry for this very basic question, but it's been quite a while since I've worked in Filemaker.

I want to create a very simple Yes/No pop-up menu. I've done this, I think. But I also want Yes to be the default answer for all records.

How can I have Yes show up as the default in the browse mode instead of a blank?

-Kirk

[-Queue-]

Set the field that you're using for the menu as auto-entered with 'Yes'.

[wkirklutz]

I'm sorry, could you be more specific?

I went to Define Fields... > Options and then I have multiple things I could check under the Auto-Activate tab.

I tried putting Yes under the data area, but that didn't work.

-Kirk

[-Queue-]

Enter 'Yes' for the data. Any new records you create will default to it. Any existing ones must be changed manually, using Set Field or Replace.

[wkirklutz]

Ugh! So there's no way to make it so all of my 300 existing records will have Yes selected?

[wkirklutz]

Make that 704 records.

[Lee Smith]

Do a find for your records missing the Yes (704), put your cursor in the field, and

1). If you are using version 6, use the new Find and Replace feature Menu - Edit - Find & Replace. or

2). Earlier versions require you to use the Replace function either in the Menu - Records - Replace. or

Use the script step Set field and the the word Yes

HTH

Lee

[Ugo DI LUCA]

So now all your records are tagged with YES....

Do you need a NO anymore ?

[wkirklutz]

Actually, I'm having trouble with the find/replace. Sorry for all these basic questions.

I should be in the Browse Mode or the Find Mode?

I'm using FM 6 for Mac OSX. What do I put in the Find box? I know I put Yes in the Replace box.

How do I select that field?

-Kirk

[Ugo DI LUCA]

I'm confused about what you're looking for.

Are you looking for a way to have the popup-up always display YES as the default value while in Find Mode.

or

Are you looking for a way to have the popup-up always display YES as the default value while in Browse Mode.

These are 2 different querries.

The first would need a scripted global while the second would need the auto-enter Value pointed by Queue and Lee.

[-Queue-]

If you want to 'Replace' the data on existing records, you must be in Browse mode. How could you do it in Find mode, if you haven't found anything yet?

[wkirklutz]

Okay. I'm in Browse mode. I go to that field so that my cursor is in it. I go to Edit > Find/Replace

In the Find box I put nothing(since the yes/no field currently has nothing in it) and in the Replace field I put Yes.

Hit Replace all and it finds no records with that criteria. What am I doing wrong?

-Kirk

[EddyB]

Hi Kirk,

A few posts have already mentioned this but I don't think you have tried it yet...

If you just want to set all existing records to yes, you need to be in browse mode.

Go the said field so the cursor is in it

Go to Records menu, select replace contents

Check the radio button replace with calculated result.

Enter "Yes"

Click OK

Click replace.

Ed.

[wkirklutz]

Wooo Hoooo! It worked. Thanks for the help. Now I just need to figure out the SMTPit plugin and I'm golden.

Thanks again.

-Kirk