Hi Database Designers,
I imagine this is a simple request but I basically am a beginner…
I want to run a simple formula language agent that will append the text in “feild1” to the text in “field2”. Would be nice to add a carriage return prior to appending the text.
Can someone show me the code to use to do the merge?
Thanks, Paul
Subject: Adding fields
@SetField(“Field2”;Field2 + @NewLine + Field1);
I suggest that you open the online help and read though the section where the Formula language functions are listed and described. The easiest way to learn a new language is to first get an understanding about the tool and the functionality you have access to.
Do you have any programming experience before? You may want to take some beginner classes so you understand the principles of programming, adding two (or in this case three) values together is very basic.
Subject: Thanks
Hi Karl-Henry
Thanks for you quick response… pretty sure you have helped me in the past. Yeah, a simple solution. I wish I had time to study this. I’ve done a bit of C++ programming early in my career but it’s been over 20 years. I’m actually a mechanical engineer but I support this database on the side. I probably could have figured it out on my own but it would take significantly more time. I really wish I sat next to notes programming guru, I think I would pick this up very fast if that were the case.
Anyway, I really appreciate your help!!!
Take care, Paul
Subject: You are welcome
The easiest might be to pick up the IBM Redbook for Notes 6.0, it will cover all the basics (and Formula language and Lotusscript has not changed much since then).
Another alternative I would recommend is to go to some user group meetings, or even one of your local LUGs. I just got back from MWLUG, it was a great experience. You get to connect with other developers (and admins) and learn a lot, even if it now shifted more toward XPages and Connections.
But there were a number of good sessions about web development using Domino at MWLUG, everything from a great overview of fifferent technologies to how to use jQuery to make Ajax calls to a Lotusscript agent and process the data returned to sessions about node.js and NGNIX.
Lotusphere/Connect may be a bit pricey if you pay it yourself, but teh LUGs are usually free, you just pay for your travel and hotel.
Subject: Really?
You’ve been using this forum for 5 years now, Paul, and still haven’t had time to learn a little bit of Notes programming? What a busy man you must be!Phil