Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #552

Re: Switching Data Entry Fields

Show all headers | View raw

On Fri, 20 Jan 2012 13:12:02 +1300, Helpful Harry wrote:
>  Another way without adding any Fields is to use an editable Field for the
>  LineItemCost.

A perfectly different approach which I do use frequently is to permit
extra data.

I do use this for a price comparison table.

* usual prices here do include tax (19%). Some don't.
  So adding a "+" to the price will add 19% to the result.

* some items are sold in more than one unit.
  So adding "/n" will divide the price by n.
  Example: 12.6/6 will take a price of 2.1 per unit.

* some prices are give for square meters (Quadratmeter in German)
  So adding "q" to the price will take other fields
  into consideration, and take that price directly where
  a price for square meters is computed

* some companies do offer discounts for me.
  So adding a "%" to the price may take the discount into consideration.

This can be done via auto data entry to change the value within the
field itself. Or this can be used to modify the data entry within
another calculation field.

For the situation here one might choose to add "$" to the data entry in
order to differ time units from total prices.

But that's more something for expert users, which do prefer direct data
entry instead of using the mouse for extra field selections.

- Martin

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Find similar

Thread

Switching Data Entry Fields bilbod <bjaynes@montanaport.net> - 2012-01-19 10:50 -0800
  Re: Switching Data Entry Fields Martin Τrautmann <t-usenet@gmx.net> - 2012-01-19 20:24 +0000
    Re: Switching Data Entry Fields bilbod <bjaynes@montanaport.net> - 2012-01-19 12:29 -0800
  Re: Switching Data Entry Fields HelpfulHarry@BusyWorking.com (Helpful Harry) - 2012-01-20 13:12 +1300
    Re: Switching Data Entry Fields Martin Τrautmann <t-usenet@gmx.net> - 2012-01-20 05:44 +0000

csiph-web