1
Lotus notes formula
When I use computed text with formula of a multivalue field. it terminates value if semicolon ; is found in the field value. Any suggestion/solution to this problem. I mean to say for ex. abs is a multivalue field and computed text is having formula abc. Then if a value is entered in the field [...]
Answer Question
| February 4, 2013 12:39 PM
Lotus Notes, Lotus Notes Formulas
When I use computed text with formula of a multivalue field. it terminates value if semicolon ; is found in the field value. Any suggestion/solution to this problem. I mean to say for ex. abs is a multivalue field and computed text is having formula abc. Then if a value is entered in the field [...]
Answer Question
| February 4, 2013 12:39 PM
Lotus Notes, Lotus Notes Formulas
Lotus Notes formula
@IF(T11>0,@ROUND(F11*1/21,2),@ROUND(F11*1/6,2)) This is a formula I have created to calculate VAT depending on which cell is entered i.e. if an entry is made in T11 VAT is entered at 5% otherwise it is entered at 20%. I wish to add to this formula so that if an entry is made in cells J11 to Y11 [...]
Answer Question
| October 1, 2012 5:34 PM
Lotus Notes, Lotus Notes Formulas
@IF(T11>0,@ROUND(F11*1/21,2),@ROUND(F11*1/6,2)) This is a formula I have created to calculate VAT depending on which cell is entered i.e. if an entry is made in T11 VAT is entered at 5% otherwise it is entered at 20%. I wish to add to this formula so that if an entry is made in cells J11 to Y11 [...]
Answer Question
| October 1, 2012 5:34 PM
Lotus Notes, Lotus Notes Formulas
Hidden Formulas
Can any person out there tell me how unhide the formulas in a Notes Database? We have an old design which became relevante to modify now. Appreciate any help. Regards Noel Ramirez Caracas
Answer Question
| May 31, 2012 1:46 PM
Lotus Notes 6.5, Lotus Notes Formulas
Can any person out there tell me how unhide the formulas in a Notes Database? We have an old design which became relevante to modify now. Appreciate any help. Regards Noel Ramirez Caracas
Answer Question
| May 31, 2012 1:46 PM
Lotus Notes 6.5, Lotus Notes Formulas
Pulling additional data fields along with the primary field in a DBColumn lookup.
I’m a newbie to Domino and Lotus Designer, and am loving the seemingly inexhaustable flexibility and power that Domino has to offer. But I was wondering if someone could help me with what is probably a very simple question. I have created two Notes databases on the same server. Addresses.nsf contains static customer contact information. [...]
Answer Question
| February 24, 2011 5:25 PM
Domino Designer, Lotus Domino, Lotus Notes, Lotus Notes Formulas, LotusScript
I’m a newbie to Domino and Lotus Designer, and am loving the seemingly inexhaustable flexibility and power that Domino has to offer. But I was wondering if someone could help me with what is probably a very simple question. I have created two Notes databases on the same server. Addresses.nsf contains static customer contact information. [...]
Answer Question
| February 24, 2011 5:25 PM
Domino Designer, Lotus Domino, Lotus Notes, Lotus Notes Formulas, LotusScript
Lotus Notes view selection formula
I want to select main documents which contains response documents with field value voltage1=6000. I tried with: SELECT form=”Main” | (@IsResponseDoc & voltage1=6000) But result is null. What is wrong in this formula? PS. field voltage1 is located on the response document
Answer Question
| January 20, 2011 11:36 AM
Domino Designer, Domino Designer Form Field Data, Lotus Domino, Lotus Notes, Lotus Notes Formulas
I want to select main documents which contains response documents with field value voltage1=6000. I tried with: SELECT form=”Main” | (@IsResponseDoc & voltage1=6000) But result is null. What is wrong in this formula? PS. field voltage1 is located on the response document
Answer Question
| January 20, 2011 11:36 AM
Domino Designer, Domino Designer Form Field Data, Lotus Domino, Lotus Notes, Lotus Notes Formulas
Lotus Notes – Copy Folder of Emails to New NSF?
Good afternoon. I am a very non-Lotus user, so please forgive any ignorance in the question posed below. I have what should be a simple task, but I have been told “can’t be done” by a few Lotus users. I’m hoping to get some advice here, even if it is to confirm that. I have [...]
Answer Question
| September 15, 2010 4:42 PM
.NSF files, Lotus Notes, Lotus Notes 7.0.3, Lotus Notes Formulas, Lotus Notes migration
Good afternoon. I am a very non-Lotus user, so please forgive any ignorance in the question posed below. I have what should be a simple task, but I have been told “can’t be done” by a few Lotus users. I’m hoping to get some advice here, even if it is to confirm that. I have [...]
Answer Question
| September 15, 2010 4:42 PM
.NSF files, Lotus Notes, Lotus Notes 7.0.3, Lotus Notes Formulas, Lotus Notes migration
Disappearing replication formula in Lotux 7.x
Why would a replication formula, that works on over 900 laptops, suddenly disappear off one machine after a week?
Answer Question
| June 15, 2010 11:08 PM
Lotus Notes 7.x, Lotus Notes Formula Error, Lotus Notes Formulas, Replication
Why would a replication formula, that works on over 900 laptops, suddenly disappear off one machine after a week?
Answer Question
| June 15, 2010 11:08 PM
Lotus Notes 7.x, Lotus Notes Formula Error, Lotus Notes Formulas, Replication
Lotus Notes – Computed Value that totals fields
I have a page that I would like to add a computed value to. The CV would total all the values from a view based on the user currently viewing the page. So when Joe Smith views the page he will see a total of all his sales in the Sales view.
Answer Question
| July 31, 2009 3:59 PM
Lotus Notes, Lotus Notes Formulas
I have a page that I would like to add a computed value to. The CV would total all the values from a view based on the user currently viewing the page. So when Joe Smith views the page he will see a total of all his sales in the Sales view.
Answer Question
| July 31, 2009 3:59 PM
Lotus Notes, Lotus Notes Formulas
1
