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:

Do you mean this one? Who's they?

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.

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.

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

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, 200718 yr by Guest