 | |
Calc field requiring multiple pushes
comp.databases.filemaker comp.databases.filemaker
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Calc field requiring multiple pushes -
02-25-2007
, 02:50 PM
#2
| |||
| |||
|
|
Hello, Why would a calc field require more than one push of a required field content entry? I have a portal where a value list selection populates the field content. In order for the calc field to include the parent in the calc the value needs to be selected more than once... Confusing, Lara OSX Filemaker 8.5 |
table 1 has name field and name2 field
talble 2 is parent of both 1 and 3 (one table one to many table 2 -
one table three to many table 2)
table 3 has line items for table 1 and names that pull from table
1...ie table 3:name; table3:type; table3:code (=table1:name2 &
table3:type)
layout for table one has portal from table 3
#3
| |||
| |||
|
|
On Feb 25, 3:50 pm, "Carpeflora" <l... (AT) liquidpointdesign (DOT) com> wrote: Hello, Why would a calc field require more than one push of a required field content entry? I have a portal where a value list selection populates the field content. In order for the calc field to include the parent in the calc the value needs to be selected more than once... Confusing, Lara OSX Filemaker 8.5 Ok...clarification table 1 has name field and name2 field talble 2 is parent of both 1 and 3 (one table one to many table 2 - one table three to many table 2) table 3 has line items for table 1 and names that pull from table 1...ie table 3:name; table3:type; table3:code (=table1:name2 & table3:type) layout for table one has portal from table 3 |
Ended up setting the field contents via a "so called" set code
button... works...if anyone knows why I'm having a "glitch" I'm
still a curious cat.
Lara
#4
| |||
| |||
|
|
On Feb 25, 4:15 pm, "Carpeflora" <l... (AT) liquidpointdesign (DOT) com> wrote: On Feb 25, 3:50 pm, "Carpeflora" <l... (AT) liquidpointdesign (DOT) com> wrote: Hello, Why would a calc field require more than one push of a required field content entry? I have a portal where a value list selection populates the field content. In order for the calc field to include the parent in the calc the value needs to be selected more than once... Confusing, Lara OSX Filemaker 8.5 Ok...clarification table 1 has name field and name2 field talble 2 is parent of both 1 and 3 (one table one to many table 2 - one table three to many table 2) table 3 has line items for table 1 and names that pull from table 1...ie table 3:name; table3:type; table3:code (=table1:name2 & table3:type) layout for table one has portal from table 3 Fixed it... Ended up setting the field contents via a "so called" set code button... works...if anyone knows why I'm having a "glitch" I'm still a curious cat. |
the way FileMaker fields work.
Data is not actually entered into the system until you leave the field.
In a normal field this is easy to see. You start typing and the cursor
stays in that field until you leave it.
In a field formatted as checkboxes, pop-up menu, etc. it's more
difficult to see since the field doesn't display the text cursor, but
you are still in that field.
To have FileMaker accept the data into the field you have to leave it
by any one of various methods:
- tab to or click in another field,
- click a button,
- click empty space on the layout,
- press the numeric keypad's Enter key
- perform a script
- use some menu commands (obviosuly something like
choosing Bold for selected text doesn't leave the field)
- etc.
If the field is using checkboxes or radio button format, then you can
put little "invisible" buttons over each option that run a script to
set the appropriate value without actually entering the field, and
therefore FileMaker will update automatically when the script ends.
Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)
#5
| |||
| |||
|
|
In article <1172438723.329140.156... (AT) t69g2000cwt (DOT) googlegroups.com>, "Carpeflora" <l... (AT) liquidpointdesign (DOT) com> wrote: On Feb 25, 4:15 pm, "Carpeflora" <l... (AT) liquidpointdesign (DOT) com> wrote: On Feb 25, 3:50 pm, "Carpeflora" <l... (AT) liquidpointdesign (DOT) com> wrote: Hello, Why would a calc field require more than one push of a required field content entry? I have a portal where a value list selection populates the field content. In order for the calc field to include the parent in the calc the value needs to be selected more than once... Confusing, Lara OSX Filemaker 8.5 Ok...clarification table 1 has name field and name2 field talble 2 is parent of both 1 and 3 (one table one to many table 2 - one table three to many table 2) table 3 has line items for table 1 and names that pull from table 1...ie table 3:name; table3:type; table3:code (=table1:name2 & table3:type) layout for table one has portal from table 3 Fixed it... Ended up setting the field contents via a "so called" set code button... works...if anyone knows why I'm having a "glitch" I'm still a curious cat. If I understand this correctly, then it's not a "glitch", it's simply the way FileMaker fields work. Data is not actually entered into the system until you leave the field. In a normal field this is easy to see. You start typing and the cursor stays in that field until you leave it. In a field formatted as checkboxes, pop-up menu, etc. it's more difficult to see since the field doesn't display the text cursor, but you are still in that field. To have FileMaker accept the data into the field you have to leave it by any one of various methods: - tab to or click in another field, - click a button, - click empty space on the layout, - press the numeric keypad's Enter key - perform a script - use some menu commands (obviosuly something like choosing Bold for selected text doesn't leave the field) - etc. If the field is using checkboxes or radio button format, then you can put little "invisible" buttons over each option that run a script to set the appropriate value without actually entering the field, and therefore FileMaker will update automatically when the script ends. Helpful Harry Hopefully helping harassed humans happily handle handiwork hardships ;o) |
bit much. I'll place buttons. Easy enough to do and will provide the
user with immediate results.
Lara
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.