John Harris

More details : I am running a script to delete a portal row. The Script can be run from any layout. So it goes to the layout with the portal and prompts the users to Select a row to be deleted. This is where it needs to pause until row is selected. I have not tried any of the suggestios but will when I get a chance. Could you expand on making portal fields scriptable ?? Thanks JOHN.

Hi, So I thought I was being really clever. I have a script that needs to wait until a portal row is selected, I tried to create a global calculation which was: if(status(currentportalrow)>=1,0,99) The intention was while no portal row was selected it would return 99, as soon as a portal row was selected it would return 0. Then in the script I had a pause for the duration of this calculation field. Anyway it doesn't work, so I am not even a little clever ! I have posted this here because the basic question is how do you get a G calc field to get the status a portal row. But I'm sure there is a much better way to do this. Anyone go any bright ideas ?

Just to say that the url email really nearly works, a script line insert calculation "mailto:" & Email_Main & "?Bcc=" & H_Email2 does work, with apple mail. However mailto:"mailto:" & Email Main & "?Bcc=" & H_Email2 & "?subject=BlahTest" & "?body=Blah or field" doesn't work as it puts the subject in the Bcc line, with apple mail, it does work fine with MS Entourage ! I assume if I create a comma seperated list I can email a group of people, haven't tried that yet. Just to say thanks and let anyone else who cares, know it's possible.

I have two databases providing data to a "line item" file. I have a portal in one file which enters data via a dropdown list. Is there anyway of checking that the "line item" record is unique. I have tried creating a combined calculation field in the "line item" (name_id & event_id) and setting the validation as unique but that doesn't seem to work. I have tried using a count and self join relationship, to enter "unique" or "duplicate" into another field, but not only does the combined field only contain data from the first field entered, it doesn't change when I edit the record. If I remove the data from the combined field and reenter either name_id or event_id it seems to sort itself out a bit. The same thing happens with the unique/duplicate field. Any Ideas ?

Thanks So there is no way of sending an email with a blind address via outlook or entourage, to the BBC or anyone else from filemaker. Wanted to be able to make runtime version which would work with users default mail client. soory about the speelling.

Funny ! So it was late and I can't tpye ! Any better suggestions ?

Hi, Does anyone know how to send to a blind address from FM, eventually this will be runtime and crossplatform.

Thanks to all, I am working my way through the information in the posts, but I thought I would explain what I am trying to do. I have two databases one is a list of names the second is a list of events. I want to be able to add a name to a field in the events database so I end up with a list in the events database of names involved in that event. The reason I want to use copy paste, is that the field in the events database will have a list of names seperated by a carriage return. I can then have a field in the names database which checks if that name is in a given event. The result is I can add an event then add a name to it and see if they are involved in that event. It's great to know you are all out there and are willing to help thanks thanks thanks. John

I am trying to create a field which looks to a field in another file and asks if it contains certain data. The field in the external file contains names seperated by a carriage return. The fictional if statement I feel I want to use would be : if(relationship::externalfield contains "JOHN","yes","no") ANY IDEAS ? What I have is a database of members and a database of events, I have a script to add a member to an event which copies the member name into a field in the events database for that event and does a carriage return. I then want a field in the members database which checks if that member is in the event. I have tried to use repeating fields in the event database, however there are over 500 members in each event and I would need to check each repetition to see if it were valid. Also I would need to check each repetition to see if it contained data before adding a member to the next free repetition. I tried to automate this somewhat using a field that adds repetition +1, to use the getrepetition command and return a true/false result but you cannot specify paste +1 in this way. Any advice much appreciated.

I am trying to copy data from a field in another file and paste it into the current file using a script. The data doesn't load into the clipboard in the following windows example: Create two databases, name one 'COPY' one 'PASTE' Create one field in each, name one 'NAME' in the 'COPY' file, name one 'ID' in the 'PASTE' file. Enter sample data into the 'NAME' field of the 'COPY' file. (e.g. FRED) copy some junk into the clipboard (e.g. hhhhhh) Define a relationship in the 'PASTE' file named 'copypaste' 'NAME=ID' Create a script in the 'PASTE' file named 'pastefrmcopy' script line 1: Copy[select, copypaste::NAME] script line 2: Paste[select,"ID"] run script ANY IDEAS ? I realise that there may be many work arounds, the one I am currently using is to copy in the target file and call an external subcript in the destination file which pastes from the clipboard, messy isn't it. I can use the set field command only if both fields are global.