Trying to find the Auto Entry auto Re-adjust calc sample

[mr_vodka]

Hi all,

I am trying to find a post or blog on here or their site, where they posted a sample of a simple calc where the user could type in any field and it would recalc the other two fields.

It was a very simple example where it was something like A + B = C, where the user could change any of the fields and it the other two fields would readjust. It is NOT the sample on Mikhael's site.

I know that I could write the auto-entry myself but at this point its the point of me not being able to find the darn thing that is driving me nuts. Any ideas where the heck I saw this?

Thanks.

:hammer:

[comment]

Do you mean this one? Who's they?

[mr_vodka]

HAHA... Thanks Michael but no not that one obviously. :

There was another sample similar prior to that thread months ago. I cant remember where it was that I saw it. Arghhh... Thanks anyway.

[mr_vodka]

Ok I tried looking for it and gave up. It was a technique blog or something that I saw a while ago. Oh well.

Anyway, I was trying to work on something as such.

A + B = C, however when C is manually entered, A and B gets cleared. Any thoughts? I tried to use a variable to only trigger when needed but it doesnt seem to want to clear.

[comment]

Well, if you're willing to hardcode the field name into the calc, you could do it this way.

If not, I think it may be possible to do it by declaring a variable, along the lines suggested here, but I am not sure.

AutoSum2.fp7.zip

[mr_vodka]

Well I was hoping to get away from hard coding the name. The method that you posted in your sample file using Get (ActiveFieldName) is close the way I handle it now. I wanted to use variables but I couldn't get it to work using them. I tried incorporating both your method in the autosum file as well as the modified Mikhail method, by Alex_Z using variables.

But no luck I can get them to calculate properly in all directions but I cant get the first two fields to clear when entering a value into the third.

I guess I will have to settle for leaving it hard coded. That is why I was looking for that other thread or post so badly. I was pretty sure that it was close to what I was looking for and had hoped to find it just to be sure.

Edited April 4, 2007 by Guest