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
BENOIT
Offline
Last seen: 4 years 12 months ago
Joined: 11/29/2018 - 11:25
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.
Hi Brian,
Is there a way to have this function loop through a database, obtaining not just one specific record, but looping through all records of a database from a specific field?
Hi Owen,
Yes that would be feasable, depending on the size of the file it might be a bit slow. What are you trying to do as there might be other alternatives.
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 Owen,
You need to add a for loop to read each email address. Once you have the email then you could use it to call another function that will actually send the email.
Thanks a lot Brian, it works !
Thanks for letting me know.
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:
http://ideascripting.com/forum/counting-last-5-days
Furthermore @GetPreviousValue could help.