Auto Enter Field TOO

[krismj]

i've gone to define database. i'm trying to get the tax acknowledgement field to produce an "X" if the item value is greater than $250.00 of the sold for price. i don't know how to do this. i don't know what type of option to give each field name or what formula to use so that i can get this result. so basically, i need the field to read:

If "item value" > $250.00 of "sold for" then insert "x" in "tax acknowledgement"

[Raybaudi]

Calculation for the AutoEnter option of "tax acknowledgement":

Case(

sold for > 250 ; "x"

)

[comment]

I could understand the value being greater than the price, or half of the price, or 25% of the price.

I could also understand the value being greater than $250.

But I don't understand the meaning of "greater than $250.00 of the sold for price".

[krismj]

i have an auction database for a non-profit organization. the database tells me how much an item was worth and how much it sold for. i only send tax acknowledgment forms if the item sold for more than $250 of it's value. so, [if the "sold for" price is $250 more than the item's value, then the "tax acknowlegement field" get's an "x" so i can then search the tax acknowledgement field for "x" and then print the tax acknowledgment forms. thanks!

[Raybaudi]

Case(

sold for > itemValue + 250 ; "x"

)

[comment]

I would suggest you make Tax Acknowledgement a calculation field (result is Number) =

sold for > itemValue + 250

This will produce a result of 1 when the condition is true, 0 otherwise (see also here). Auto-entered calculations are best reserved for those cases where users are allowed to override the results.

[krismj]

It works! THanks so much! You are awesome!