Search results for query: *

Hi all, I am trying to create an agent to do the following and require some help if possible. I want to loop through a view and for each document check and detach the attachment. The looping part I am OK with. And I have read the HELP on extractfile and just need come help tweaking this if...

Hi guys, I want to have some lotusscript that checks if a document exists for 2 criteria : Look in a view and seeif there is a document for USERNAME on DATE, i.e. if there is a document with "Doctor Gonzo" in the username field and "06/06/06" in the DATE field..... can anyone help? I feel...

Hi guys, Tsuji and Diancecht gladly provided me with the code below last week which converts MINUTEs into HOURS and MINUTES in the format hh:mm.... this works perfectly. EXAMPLE : function toHoursAndMinutes(minutes) { var mins = minutes%60; //modulus dividing by 60 var hrs = (minutes -...

Hi guys, Need help with a javascript / maths problem. I have a field which contains a number of minutes. I need to convert this into hours and minutes though. If I simply divide the field by 60, this gives me a DECIMAL ie. 350 (mins) divided by 60 returns 5.83 hours... but what needs to be...

Hi all, Could do with some advice.... I have an agent that is generating an "ILLEGAL USE OF PROPERTY" error in the log. Basically I want to loop through my "profile" database and for each document, check if a PERSON document exists in the address book. If it does, I want to replace the multi...

Hi guys, I am trying to hide or show some text in left hand frame (my menu frame) depending on the contents of my right-hand frame (my document/form frame) Any ideas? I think I need to get a hold of the FORM name in the right hand frame using script on my left hand frame and access it that...

Hi Guys, I know I can use fieldname.focus() to put the cursor in a text field, but do you know ho w I can do the same witrh drop down boxes and radio buttons? Gonzo

Hi All, I don't know if someone can help me or provide a code snippet or something. I have a database called people.nsf, which contasins a document called user. What I want to do is create an agent that checks each USER document in PEOPLE to see if it there is a PERSON document in NAMES.NSF...

Hi guys, I am trying to hide a form element with the ID "question1" and display a form element called "question2" (both of these are tables) with a link and function - but it is not working - thus: (I am getting "syntax error in my javascript alert) This is my link : <a...

Hi All, I'm trying to write a macro that will open a CSV file, delimit it, copies the data and pastes it in a specific sheet of a specific workbook. I've tried this several ways without success but here is the most successful attempt yet - ---- Sub cutpaste() ' ' cutpaste Macro ' '...

HI guys, Can anyone tell me how to look for a field value within another field? I want to check if a field value is already contained within a multivalie field. Any help much appreciated Gonzo

Hi all, I'm trying (without any success) to write a Lotusscript scheduled agent to loop through my ALLDOCUMENTS view, setting the ARCHIVE field to "Y" for documents older than 6 months, and permanently deleting documents older than 12 months. Can anyone help? I've been looking at...

Hi guys, I want a drop down field containing 5 dates - 2 days either side of today. Anyone got any ideas? I know an @adjust will be necessary! Cheers! Gonzo

Hi guys, I have the following code in the ONBLUR event of a field FIELD3.value = FIELD2.value - FIELD1.value this works fine, but if the sum is 13.20 - 12.50 the resulting answer is 0.6999999999999993. What I want is to round up to 2 decimal places. it's currency you see.... I want the...

Hi All, I have a view with three columns : flight_date, base and flight_number. I have a form with three drop-down fields which correspond to the three fields in the view. The first drop down (flight-date) has a list of dates. The second drop down (base) performs a lookup to the view and...

HI all, I am having the following problem. I use MS word 97 in the office. When I "save as HTML" Word creates an HTML file and any associted graphics in one folder, which suits me down to the ground. However, my colleagues use Word 2000. When they "save as HTML" it stores the HTML file in...

Hi guys, Can anyone tell me how to get an integer of how many checkboxes (ELEMENTS?) are ticked in a field? I want to limit the number of checkboxes that can be checked to 5, and can't find anything in forum (it telle me how to return the value, not the length?) Many thanks, Gonzo

Hi All, I wonder if someone could advise me on the following as I don't know the best way to accomplish this (formulas, Lotusscript or javascript/HTML). I have 3 dialogue list fields, FieldOne, FieldTwo, FieldThree. Each one contains the options 1 to 8. What I want is this : if you pick one...

Hi All, Struggling somewhat here. I use the following code on a form (which works) function SubmitDocument(){ var frm=document.forms[0]; if(frm.QuestionSeventeen.value=="") { alert("Please enter your postcode"); window.document.forms[0].QuestionSeventeen.focus(); return false; } else...

Hi All, Struggling somewhat here. I use the following code on a form (which works) function SubmitDocument(){ var frm=document.forms[0]; if(frm.QuestionSeventeen.value=="") { alert("Please enter your postcode"); window.document.forms[0].QuestionSeventeen.focus(); return false; } else...