Text Calculation field modifiable? 
Author Message
 Text Calculation field modifiable?
In the addresses in my FM 6.04 database I've tried to get the
"Country" field filled in automatically using a text calculation based
on what's being entered in the two-letter codes of US states
(generating "USA" in the Country field) or Canadian provinces
(generating "Canada").
Problem is that I also have some records in other countries, and the
text calculation "Country" field is not modifiable, so now I can't
enter Japan, Belgium or whatever. Any suggestions?
- Jose


Mon, 24 Oct 2005 08:54:38 GMT
 Text Calculation field modifiable?

Why isn't the country field modifiable?  Is it defined as a text field
(with whatever 'auto-enter' criteria desired)?  Or...?

Quote:

> In the addresses in my FM 6.04 database I've tried to get the
> "Country" field filled in automatically using a text calculation based
> on what's being entered in the two-letter codes of US states
> (generating "USA" in the Country field) or Canadian provinces
> (generating "Canada").
> Problem is that I also have some records in other countries, and the
> text calculation "Country" field is not modifiable, so now I can't
> enter Japan, Belgium or whatever. Any suggestions?
> - Jose

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg              (818) 883-2846
FM Pro Solutions       Los Angeles, California
Associate Member, FileMaker Solutions Alliance


Mon, 24 Oct 2005 09:02:40 GMT
 Text Calculation field modifiable?
if the field is a text field with an auto enter option,  as distict from
a calc fiels, then you can overtype data auto entered by typing in the
field, providing of course the field on the layout, in layout mode, is
set to allow entry:
layout mode, field format, behaviour, allow entry itno field

Fields set to not allow entry, can generally be spotted from within
Browse, mode, by clicking on the layout background, the fields that
suddenly show a light greyed dotted border are allow entry, those that
stay exactly the same are of the not allow entry persuasion. It so it
always seems.

Chris Brown
Neurosurgery
University of Adelaide

Quote:

> In the addresses in my FM 6.04 database I've tried to get the
> "Country" field filled in automatically using a text calculation based
> on what's being entered in the two-letter codes of US states
> (generating "USA" in the Country field) or Canadian provinces
> (generating "Canada").
> Problem is that I also have some records in other countries, and the
> text calculation "Country" field is not modifiable, so now I can't
> enter Japan, Belgium or whatever. Any suggestions?
> - Jose



Mon, 24 Oct 2005 09:30:35 GMT
 Text Calculation field modifiable?
OK, I get it; I had set this Country field up as a Calculation Field
rather than as a Text Field with an AutoEnter option...
Which resolves this, but creates another issue. This works only if the
Country field is empty. However, if someone moves from BC (and
therefore had "Canada" in the Country field) to, say, WA (which, if
the Country field were empty, would AutoEnter "USA", the AutoEnter
function does not overwrite "Canada" replacing this with "USA". Is
there any way to achieve that?

On Thu, 08 May 2003 01:30:35 GMT, Chris Brown

Quote:

>if the field is a text field with an auto enter option,  as distict from
>a calc fiels, then you can overtype data auto entered by typing in the
>field, providing of course the field on the layout, in layout mode, is
>set to allow entry:
>layout mode, field format, behaviour, allow entry itno field

>Fields set to not allow entry, can generally be spotted from within
>Browse, mode, by clicking on the layout background, the fields that
>suddenly show a light greyed dotted border are allow entry, those that
>stay exactly the same are of the not allow entry persuasion. It so it
>always seems.

>Chris Brown
>Neurosurgery
>University of Adelaide


>> In the addresses in my FM 6.04 database I've tried to get the
>> "Country" field filled in automatically using a text calculation based
>> on what's being entered in the two-letter codes of US states
>> (generating "USA" in the Country field) or Canadian provinces
>> (generating "Canada").
>> Problem is that I also have some records in other countries, and the
>> text calculation "Country" field is not modifiable, so now I can't
>> enter Japan, Belgium or whatever. Any suggestions?
>> - Jose



Mon, 24 Oct 2005 13:43:38 GMT
 Text Calculation field modifiable?
this can be a bit of a quagmire to explain...

the first thing perhaps, is that there are lookups and auto enter calc
options attached to text fields. Lookups are dependent on a rel, and are can
be re-looked up, which I won't try to explauin (look in the help) other than
to say this is the sort of thing that would deal with the record whose
person changed state, by re-entering the state, and assuming the rel was a
state = state thing, the new country could be brought in... depending...

this is what an invoice would use to lookup the current price, linked
item=item to items db, you can update the value in the source db (item)
without affecting existing invoices, but new invoices will use the new
value.

A enter calc option, only enters a value at new record creation, it cant be
'recalculated like a lookup, but as it is a text field,  it can be retyped.
Both are hard data fields.

Without more details of the db structure, in an ideal structure, I would
think there should be a states and countries 'db' or at least a db that
contains both fields and where there is data in all fields
in your main db (persons/companies...  of some sort I'll assume)  rel to the
states and countries file, state=state...

to refresh the value you have to relookup...

Chris

Quote:

> OK, I get it; I had set this Country field up as a Calculation Field
> rather than as a Text Field with an AutoEnter option...
> Which resolves this, but creates another issue. This works only if the
> Country field is empty. However, if someone moves from BC (and
> therefore had "Canada" in the Country field) to, say, WA (which, if
> the Country field were empty, would AutoEnter "USA", the AutoEnter
> function does not overwrite "Canada" replacing this with "USA". Is
> there any way to achieve that?

> On Thu, 08 May 2003 01:30:35 GMT, Chris Brown

> >if the field is a text field with an auto enter option,  as distict from
> >a calc fiels, then you can overtype data auto entered by typing in the
> >field, providing of course the field on the layout, in layout mode, is
> >set to allow entry:
> >layout mode, field format, behaviour, allow entry itno field

> >Fields set to not allow entry, can generally be spotted from within
> >Browse, mode, by clicking on the layout background, the fields that
> >suddenly show a light greyed dotted border are allow entry, those that
> >stay exactly the same are of the not allow entry persuasion. It so it
> >always seems.

> >Chris Brown
> >Neurosurgery
> >University of Adelaide


> >> In the addresses in my FM 6.04 database I've tried to get the
> >> "Country" field filled in automatically using a text calculation based
> >> on what's being entered in the two-letter codes of US states
> >> (generating "USA" in the Country field) or Canadian provinces
> >> (generating "Canada").
> >> Problem is that I also have some records in other countries, and the
> >> text calculation "Country" field is not modifiable, so now I can't
> >> enter Japan, Belgium or whatever. Any suggestions?
> >> - Jose



Mon, 24 Oct 2005 14:19:13 GMT
 Text Calculation field modifiable?

Quote:
> OK, I get it; I had set this Country field up as a Calculation Field
> rather than as a Text Field with an AutoEnter option...
> Which resolves this, but creates another issue. This works only if the
> Country field is empty. However, if someone moves from BC (and
> therefore had "Canada" in the Country field) to, say, WA (which, if
> the Country field were empty, would AutoEnter "USA", the AutoEnter
> function does not overwrite "Canada" replacing this with "USA". Is
> there any way to achieve that?

Hello,

You could also use a small trick to allow the calc field to be overwriten by
the user. Define another field, say country_manual_entry and modify your
calc to something like:
if(not (is empty) country_manual_entry; country_manual_entry;
case(state1;countrya;state2;countryb;etc.))
Next, you position the new field just behind the calc, while setting the
calc to be transparent and not allow entry. When you type in the calc field,
you really will be editing the underneath field, which will make the calc
field to take this value.

So if some provinces/states are not covered by your case statement (or in
another table, if your calc use a related value based on a state:state
relationship), the calc result will remain empty, but the user will be able
to set it by setting the underneath field.

Hope this helps

Marc-Andr Paiement
Montral



Tue, 25 Oct 2005 02:08:58 GMT
 Text Calculation field modifiable?
I am going to go along with Chris on this one and suggest that you may
want a table/file which is just states/provinces and countries so that
you can use relationships as well as calculations in setting hte state
and country fields.

Riley Waugh

Quote:

> > OK, I get it; I had set this Country field up as a Calculation Field
> > rather than as a Text Field with an AutoEnter option...
> > Which resolves this, but creates another issue. This works only if the
> > Country field is empty. However, if someone moves from BC (and
> > therefore had "Canada" in the Country field) to, say, WA (which, if
> > the Country field were empty, would AutoEnter "USA", the AutoEnter
> > function does not overwrite "Canada" replacing this with "USA". Is
> > there any way to achieve that?

> Hello,

> You could also use a small trick to allow the calc field to be overwriten by
> the user. Define another field, say country_manual_entry and modify your
> calc to something like:
> if(not (is empty) country_manual_entry; country_manual_entry;
> case(state1;countrya;state2;countryb;etc.))
> Next, you position the new field just behind the calc, while setting the
> calc to be transparent and not allow entry. When you type in the calc field,
> you really will be editing the underneath field, which will make the calc
> field to take this value.

> So if some provinces/states are not covered by your case statement (or in
> another table, if your calc use a related value based on a state:state
> relationship), the calc result will remain empty, but the user will be able
> to set it by setting the underneath field.

> Hope this helps

> Marc-Andr Paiement
> Montral



Tue, 25 Oct 2005 07:32:22 GMT
 
 [ 7 post ] 

 Relevant Pages 

1. Text Field -> Repeating Calculation (Text) Field

2. modifiable subselect field

3. Usable scroll-bars in a non-modifiable field

4. 'This field is not modifiable'

5. Modifiable fields

6. Formatted text in a calculation field

7. Text Attributes in calculation field and export to MS Word

8. <beginner> Text field calculations/summaries

9. Calculations in text field

10. why no text ruler for calculation fields?

11. Allow text entry into Calculation field?

12. Calculation fields versus Insert Calculation


 
Powered by phpBB® Forum Software