Script Check button

ATTENTION: This forum is no longer active. Please navigate to our new support site at https://support.starfishetl.com/
Viewing 3 posts (of 3 total)
Anosh Wadia
User - Author
Post count: 19
#1

When you add a function field, what does the "Check" button actually return? I understand that it checks the script, but in some cases I've found that it returns the result as "@@ORG:RECTYPE@@" which is the field I assigned to the ScriptedField variable.

However in the function below, its returning "Other" even though all the records in my source data have a value of "A".

Function ScriptedField
'TODO: your custom VBScript code here
If "@@ORG:RECTYPE@@"="M" or "@@ORG:RECTYPE@@"="C" Then
ScriptedField="Call"
ElseIf "@@ORG:RECTYPE@@"="A" Then
ScriptedField="Meeting"
Else
ScriptedField="Other"
End If
End Function

So I'm unsure of what exactly is being returned by the test.

Thanks!
Anosh

Comments (3)

Aron Hoekstra's picture Aron Hoekstra
Administrator
Post count: 2
#2

I think my previous post will have answered this, but basically this is because variables are not resolved when using the Check button, I hope to improve this functionality in the near future.

Log in to post comments
Aron Hoekstra's picture Aron Hoekstra
Administrator
Post count: 2
#3

Anosh,

Just would like you to know in the latest release there is now support for resolving these variables in the Script Check button, and also when using variables in origin SQL statements, etc.

Log in to post comments
Anosh Wadia's picture Anosh Wadia
User - Author
Post count: 19
#4

Thanks Aron! I'll run an update and try it out and let you know if I notice any issues.

Thanks!
Anosh

Log in to post comments
Viewing 3 posts (of 3 total)

Forum Login

Login or sign up for our forums to connect to the user community.

Reply

You must log in to post.

Not a Member? Register.