How do I bulk edit? "Cmd =" won't work for portals

[RichardAustin]

In a found set, how can I bulk enter data into related fields inside a portal?

I can create a new related record in the portal by simply entering data, which creates the related record and puts the data in the field, but how can I do this in bulk for a found set?

I try "command =" but that doesn't work for fields in a portal. (It pretends to, but nothing happens.)

Is there a way to bulk edit related fields in a portal whereby the related records are created and the data inserted into the field?

[blackshark]

Are you trying to update a field in your master file for the current found set or are you trying to update the value of a field for all of the related records (portal) for one particular record in your master file?

[RichardAustin]

I'm trying to enter the same information in a portal field for a found set of records so that every record in the found set has the same information in the field. I tried even to write a script that would enter the info into the field and move to the next record, but that didn't work either.

I can do it while browsing any record, I enter the value and it creates the record in the related table and inserts the data I enter. But I need to do this for several hundred records in several found sets. Basically, I need the ability to bulk edit values in related fields within portals.

[spankalee]

How did you try to script this? It shold be possible so mabe if you post the script we can help.

There's two ways I can thnk of quickly. One is to use the layout with the portal and use the Go To Portal Row and Set Field steps. letting FM create the relationship. The other way would be to work from the child table and create the relationship yourself in the script.

[Vaughan]

Stuff like this might be better done through the FMP client rather than the web.

The web interface has limitiations compared with the client. Entering data into found sets is one of them.

[RichardAustin]

I simply created a script to insert the data into the portal field.

Insert text

Go to next field. (then I would go to the next record in the found set)

After some experimenting I am getting this simple script to work by putting a carriage return after the data and then going to the next field. Also, it makes a difference which table (of the same name) you use. Apparently, the field and table must match exactly in the script for the portal field. The same field in another instance of the same table doesn't work.