I have a text field called “Events”. Some of its values are as follows:

I’d like to write a script that will find all the records for which any of the values Alice_Austen_House_20?? appear and then do the following: 

1) Insert the text “Alice_Austen_House” into the Events field

2) Delete all the text Alice_Austen_House_20?? from the Events field

Here is the start of my script, intended to find the relevant records and then insert “Alice_Austen_House” into the Events field:

Here are the details of the first step of the script:

The first step correctly finds the relevant records, but then I see this error message:

I’m puzzled by the error message because, as you can see below, I have included “Alice_Austen_House” in the value list for Events.

What am I doing wrong? What do I need to do to get this to work?

I'm using FileMaker Pro 17 Advanced.

54 minutes ago, John Link said:

I’m puzzled by the error message because, as you can see below, I have included “Alice_Austen_House” in the value list for Events.

I believe you are experiencing the same problem as the one you did here:
https://fmforums.com/topic/106996-problem-with-script-inserting-text-into-field/?do=findComment&comment=483157&_rid=72594

Either use Set Field or at least enable the 'Select entire contents' option*.

--
(*) This is assuming Events contains a single value. If it's a checkbox or similar, then you will need to deploy a significantly different strategy.

 

 

Edited October 9, 20214 yr by comment