I'm very new to Lotus Notes Development and need to know how to force a refresh on a view that pulls in data from a form?
Technorati: None
(2)

Hi,

Do you know a way to sort MS Excel columns using Lotus Script? Do you have an example? I need to sort a range of columns using 2 columns (1 ascendent and the other one descendent). I have tried to solve this situation looking at Sort and SortSpecial Methods in VBA but so far, I haven't be able to convert the VBA code to Lotus Script.

Technorati: Developing
(0)

You know, I design a certain way and everything works, and I never really thought that the WAY I was designing was a contributing factor in the whole "everything works" bit.

Case in point. For every database I develop, I select my placement of hidden fields at the top or the bottom of the page, usually depending on what the standard is for the organization I'm developing for.

Case in point 2: As most of you know, I'm a Notes client junkie. It's rare for me to do any sort of web developing, but I was that day, so there we are.

I created a $$Return field that would use the parent doc's UNID carried over from another field to form the URL go to back to once the form was submitted. Computed for display, everything looked great, except... no doc ID.

I try everything, until finally I admit to myself that I need to get AWAY from laptop for a bit to think. It had to be something REALLY EASY, as it always is when you tear your hair out.

(I think I should note that perhaps I have been watching a bit too much "Blue's Clues" with Zoë, as I said, "now we sit down in our thinking chair and think....think... .thiiiiiiiiiiink.")

However, I think Steve from Blue's Clues is onto something, as about ten minutes after stepping away from my computer I KNEW what it was.

I walked over, swapped the placement of the $$Return field and the field which pulled in the value of the parent UNID, and it worked beautifully.

Sure enough, it seems that if Field2 picks up Field1's value, then Field1 must be on the form somewhere before Field2. I did note that I can also check "Compute after validation" to make sure it fills in correctly no matter what.

It sounds so easy. Ten years of developing and I'd never made that connection?

How long have I been doing development? Have I really just always been lucky or developed in a way that I never had to make the connection that the way they are placed on the page is the order in which the values will be calculated?

It just goes to show - just when you think you are experienced, it takes one small little field value to show you that there is ALWAYS more to learn!

Has anyone ever had a moment of Zen like that? Can anyone enlighten me some more on ways that computed fields work that really do make sense once you think of them? Let's hear!

Jess

Technorati: None
(3)