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...

Cheers Dian! I used it in this function - as you can see we just had the * and the + the wrong way around, but I spotted that (as I said my maths is terrible!) function toMinutes(mins) { var hoursDotMinutes = mins; var fieldArray = hoursDotMinutes.split(":"); var minutes =...

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

Pascal, Thank you once again!! I shall give this a go and let you know the results! 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 ' '...

Brilliant Dan - works perfectly! Many thanks Gonzo

Hi guys, here uis the field (called CrewIDs) when I do VIEW SOURCE <INPUT NAME="CrewIDs" TYPE=hidden VALUE="7878; 1414"> I have another fiedls called CREW.. I want to write a function that checks if CREW is inside CrewIDs - say for example if I type "7878" into CREW, it will return TRUE...

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

Many thanks again Pascal! I'll let you know how I get on. 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

Thanks predamarcel. Works perfectly. 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...