TRIGGER

[adiarnon]

hi,

i want that when my user enter the document

one of the fields will filter with the value of the user that entered

so,

i added a trigGer - on open

with selection in field

the field - manager

the value - right(osuser(),7)

its not working!!

and when i added a button

with the same action its working

why???

[jerrysvensson]

OnOpen only works if you use Plugin as client.

Using WebView (Ajax) it will not work. See refrence manual.

[rubenmarin1]

Hi,

- Right(string, 7) will return the last 7 characters (always 7 characters).

- Mid(String, 7) will return the characters from the 7th character of the string (length of result string can vary)

- Subfield(OSUser(), '\', -1) will return the string after the last '\'

Also check that values returned from the 'value' is exactly equal than the field values.

[rubenmarin1]

If doesn't works because of what Jerry saids and installing plugin to everyone is not an option, maybe you can use section access to filter values on login.

[adiarnon]

we are using the Plugin as client.

and like i said

when im using the same action in a button its working!!

[adiarnon]

it not the problem

like i said

when im using the same action in a button its working!!

[marcus_sommer]

Put osuser() in a textbox to see if it returned what you expect. Further check if both action-expressions are the same and not a typo occured.

- Marcus

[adiarnon]

YES,

it returned what im expecting

[marcus_sommer · Accepted solution]

Try to select anything else maybe something month(today()) or set a variable-value to see if the trigger fired. Another possibility might be to use a landing-page within your app and then using an OnSheetActivate trigger.

- Marcus