get the value of a "cell"
Forums
Hello,
I'm sorry if my question is basic but I would like to know how to get for example the value of the first column and the second line in my Idea's database ?
Thanks in advance !
BenoƮt
I am trying to have the
I am trying to have the script run through a database containing email addresses send Outlook emails to those email addresses.
So far, I have set a global variable in my script for email addresses (emailAddress) and in the function provided in the screenshot, I have the emailAddress variable equal rec.GetCharValue("EMAIL") so that when it moves into the next function, it uses that global variable value to send an email to the email address provided from that database.
Hi Brian,
Hi Brian,
If i want get a cells value & then add it to the preious cell and keep on populating a column like that. Would it be possible ? For eg. in MS Excel, the same formula would like this =
Coln A | Coln B| Coln C|
12 2
22 4 coln C = 12 + 4 = 16 ----- i.e. --> A1 + B2 = C2
A2 + B3 = C3
etc.
in excel it is possible to do this due to cell references. But will i be able to do it in IDEA, which works with columns & not cells ?
Please check the link below:
Please check the link below:
http://ideascripting.com/forum/counting-last-5-days
Furthermore @GetPreviousValue could help.
Hi Benoit,
Hi Benoit,
Nope, nothing basic about this question. I think this is an advance question as you need to use the RecordSet and Record objects which can be a bit tricky but once you get to know them it is fairly easy. There is an example in the language browser on how to do it. What you do is first get the database object, you then use the RecordSet object to get the row that you are interested in. The final step is to indicate the field that you want to get the record from. Here is the code, let me know if there is anything that is not clear.