Login Script

[redballoon]

OK I have a login script that searches records and the result is that only those records that the user created is returned when they login, however the find function does not seem to work, the field I use called creator uses the function as shown here it is....

and the field used to refrence the user loging in has it's field filled by this...

Any suggestions ?

I know this should be easy...

[AudioFreak]

The first thing that sticks out is your find is using the "User name" not the "Account Name".

They are different. Try Get(Account Name)

Edited January 9, 2008 by Guest

[redballoon]

Thanks,

That did not work , what could be going wrong.

File maker does not see Get (Account Name) or Get (AccountName) as anything but a text string so it is actually searching for Get (Account Name).

I have tried Get(AccountName) Get (User) Get(User) etc etc Filemaker does not see it as a formula jjust a text string and it searches on it, so this must just be a formulation problem...

[AudioFreak]

In your script try using

Enter Find Mode

Set Field[Photo Catalog::Creator; Get(AccountName)

Perform Find

Keep in mind you will need to use error capture if you are trying to limit access to only the record creator.

Michael

[redballoon]

Error Capture ? can you explaine, thanks for the tip I will try it...

[redballoon]

I cannot actually format the script like that ? I have tried but it also fails ??

[redballoon]

In your script try using

Enter Find Mode

Set Field[Photo Catalog::Creator[color:red]; Get(AccountName)

Perform Find

I cannot get that semi colon in there it is not included as an operator and if I use a semi colon I am told filemaker is expecting an operator So I put an [color:green]= instead but this does not work.

[AudioFreak]

Hi Red,

I'm guessing you are trying to type the whole step in the calculation dialogue box.

Make a new script.

Find Enter Find Mode(left side of script window) and double click it.

Find Set Field, double click it. Now highlite the Set Field Script step. You will see 2 buttons on the bottom right. The top button is the field where you will be setting the Account Name(Target Field). Click it and select the field Creator. Now click on the button Calculated Result, on the right hand side there is a drop down list, choose Get Functions, Account name is the first one listed, Double Click it.

Find "Perform find" on the left and double click it, save the script. You should be good now.

One typo I did make was the set field step. See below. I left off the ending bracket.

Set Field[Photo Catalog::Creator; Get(AccountName)]

Off to work I go.....lol

Michael

Edited January 10, 2008 by Guest