Dear Oleg,
I read 2 variables from SQL:
varA = 2
varB= 3
I want to set VarC = 2+3 = 5
{VALUE(8)}+{VALUE(9)}-{VALUE(10)} >> this doesnot work...
It must be simple, I just not seem to find this anywhere...
How to do this?
calculate with values
Re: calculate with values
You should use Basic for any arbitrary calculations.
Download and install Basic plugin: http://www.robotask.com/downloads/BasicForRoboTask.exe
Now you can perform necessary calculations. See the example:
You can use Basic script action for complex algorithms.
Save the text into a file and use menu Task->Import to import into Robotask.
Download and install Basic plugin: http://www.robotask.com/downloads/BasicForRoboTask.exe
Now you can perform necessary calculations. See the example:
Code: Select all
;*****************************
;* RoboTask Task file
;* Do not edit in text editor!
;*****************************
[Root]
ActionAfterRun=INTEGER|0
Actions=FOLDER
Automat=INTEGER|-1
CatID=INTEGER|2099193306
Comment=STRINGLIST
ContinueOnError=INTEGER|0
ExternalName=STRING|"Task308"
Hide=INTEGER|0
ID=INTEGER|298810074
LogOnAsUser=INTEGER|1
Name=STRING|"Simple calculations"
OnErrorTaskID=INTEGER|0
Priority=INTEGER|3
RunOnClose=INTEGER|0
RunOnStartup=INTEGER|0
ToLog=INTEGER|3
WriteGeneralLog=INTEGER|0
[Actions]
Action1=FOLDER
Action2=FOLDER
Action3=FOLDER
Action4=FOLDER
Action5=FOLDER
Action6=FOLDER
[Actions\Action1]
ActionID=STRING|"A_VARIABLES_CREATE"
Enabled=INTEGER|-1
Name=STRING|"Create local variable ""VAR1"" with value ""2"""
Params=FOLDER
[Actions\Action1\Params]
expand=STRING|"0"
varkind=STRING|"1"
varname=STRING|"VAR1"
varvalue=STRING|"2"
[Actions\Action2]
ActionID=STRING|"A_VARIABLES_CREATE"
Enabled=INTEGER|-1
Name=STRING|"Create local variable ""VAR2"" with value ""3"""
Params=FOLDER
[Actions\Action2\Params]
expand=STRING|"0"
varkind=STRING|"1"
varname=STRING|"VAR2"
varvalue=STRING|"3"
[Actions\Action3]
ActionID=STRING|"A_VARIABLES_CREATE"
Enabled=INTEGER|-1
Name=STRING|"Create local variable ""VAR3"" with value ""10"""
Params=FOLDER
[Actions\Action3\Params]
expand=STRING|"0"
varkind=STRING|"1"
varname=STRING|"VAR3"
varvalue=STRING|"10"
[Actions\Action4]
ActionID=STRING|"A_VARIABLES_CREATE"
Enabled=INTEGER|-1
Name=STRING|"Create local variable ""RES"" with value """""
Params=FOLDER
[Actions\Action4\Params]
expand=STRING|"0"
varkind=STRING|"1"
varname=STRING|"RES"
[Actions\Action5]
ActionID=STRING|"BASIC_EVALUATE"
Enabled=INTEGER|-1
Name=STRING|"Evaluate"
Params=FOLDER
[Actions\Action5\Params]
expression=STRING|"{var1}-{var2}+{var3}"
variable=STRING|"RES"
[Actions\Action6]
ActionID=STRING|"A_DIALOG_MESSAGE"
Enabled=INTEGER|-1
Name=STRING|"Show ""Result = {res}"""
Params=FOLDER
[Actions\Action6\Params]
icon=STRING|"1"
msg0=STRING|"Result = {res}"
msgcount=STRING|"1"
playsound=STRING|"0"
showmessage=STRING|"1"
Save the text into a file and use menu Task->Import to import into Robotask.
Oleg Yershov
Re: calculate with values
Thanks Oleg!
works fine and simple
works fine and simple
