 | |
#1
 
| |||
| |||
|
Insert a record -
10-05-2011
, 03:06 PM
#2
| |||
| |||
|
|
On Wed, 05 Oct 2011 16:06:44 -0400, Bill Steele wrote: By default, records appear in table view in creation order, so new records appear at the bottom. Is there any way to insert a new record higher up the list? Or a way to move rows up or down? sort. |
want it, like in Excel.
#3
| |||
| |||
|
|
By default, records appear in table view in creation order, so new records appear at the bottom. Is there any way to insert a new record higher up the list? Or a way to move rows up or down? |
layout is determined at layout generation time and the new records will
move to their sorted place on commitment.
But as Martin says you can resort anytime you like, to for instance,
get the latest record to the top.
--
John G.
#4
| |||
| |||
|
|
In article <slrnj8pf2t.2js2.t-usenet (AT) ID-685 (DOT) user.individual.de>, Martin ɱrautmann <t-usenet (AT) gmx (DOT) net> wrote: On Wed, 05 Oct 2011 16:06:44 -0400, Bill Steele wrote: By default, records appear in table view in creation order, so new records appear at the bottom. Is there any way to insert a new record higher up the list? Or a way to move rows up or down? sort. Not the whole page. One record at a time. Insert a new row where you want it, like in Excel. |
to a button on each row of your table that will create the new record,
set "order" on the new record to the value from the original record in
that row and renumber all successive records.
It would, quite frankly, be easier to use Excel to do what you want.
Then, if you need that data in FM, import it into an empty clone of the
DB so that the creation order will match the row order in Excel. Clunky,
though, since you'll end up with a new copy of the DB every time you
want to add a single new record.
#5
| |||
| |||
|
|
Bill Steele formulated on Thursday : By default, records appear in table view in creation order, so new records appear at the bottom. Is there any way to insert a new record higher up the list? Or a way to move rows up or down? In later versions of FMP ( cant remember which) the sort order of a layout is determined at layout generation time and the new records will move to their sorted place on commitment. |
--
http://clk.ch
#6
| |||
| |||
|
|
By default, records appear in table view in creation order, so new records appear at the bottom. Is there any way to insert a new record higher up the list? Or a way to move rows up or down? |
So if you sort in creation order, go to the record above where you want
to insert the new one, that should work.
However, moving rows would require sorting into the desire order,
exporting all, deleting all, and reimporting.
I'm not sure why just sorting isn't good enough. Perhaps a better
description of the problem you're trying to solve?
--
Lynn Allen
--
www.semiotics.com
562.938.7890
Member Filemaker Business Alliance
FileMaker 10 Certified Developer
#7
| |||
| |||
|
|
On 2011-10-05 13:06:44 -0700, Bill Steele <ws21 (AT) cornell (DOT) edu> said: By default, records appear in table view in creation order, so new records appear at the bottom. Is there any way to insert a new record higher up the list? Or a way to move rows up or down? A sorted table will create a new record immediately after the record you're on. So if you sort in creation order, go to the record above where you want to insert the new one, that should work. However, moving rows would require sorting into the desire order, exporting all, deleting all, and reimporting. I'm not sure why just sorting isn't good enough. Perhaps a better description of the problem you're trying to solve? |
list will display items in an arbitrary order determined by business
decisions (i.e., what the boss wants).
#8
| |||
| |||
|
|
Want to use the table as the source for a value list, where the dropdown list will display items in an arbitrary order determined by business decisions (i.e., what the boss wants). |
definition, not the order of the records within the Table.
Taking a Value List from a Field (one field) will sort the options in
alphanumeric order. To sort them into a different order you'll need to use
a second field and set-up the Value List definition to use that as the
sort order.
For example if the Table contains Fields with data:
Fred
Barney
Betty
Wilma
BamBam
Peebles
Then the Value List will display as
BamBam
Barney
Betty
Fred
Peebles
Wilma
If you add a second field to the Table and Value List definition, you can
have them displayed in whatever order you want by setting the new second
field to have data in your desired numerical order.
e.g. by gender, grouped by Flintstone family first and Rubble family second
01 Peebles
02 Wilma
03 Betty
04 BamBam
05 Fred
06 Barney
Helpful Harry
)
#9
| |||
| |||
|
|
In article <ws21-0B7E21.13214124102011 (AT) newsstand (DOT) cit.cornell.edu>, Bill Steele <ws21 (AT) cornell (DOT) edu> wrote: Want to use the table as the source for a value list, where the dropdown list will display items in an arbitrary order determined by business decisions (i.e., what the boss wants). The order of the options in a Value List is determined by the Value List definition, not the order of the records within the Table. Taking a Value List from a Field (one field) will sort the options in alphanumeric order. To sort them into a different order you'll need to use a second field and set-up the Value List definition to use that as the sort order. For example if the Table contains Fields with data: Fred Barney Betty Wilma BamBam Peebles Then the Value List will display as BamBam Barney Betty Fred Peebles Wilma If you add a second field to the Table and Value List definition, you can have them displayed in whatever order you want by setting the new second field to have data in your desired numerical order. e.g. by gender, grouped by Flintstone family first and Rubble family second 01 Peebles 02 Wilma 03 Betty 04 BamBam 05 Fred 06 Barney |
Of course, you don't HAVE to add a second Field. You could just alter the
data in the original Field to have the number prefixes and get the same
result, although you may then need a new Calculation field somewhere along
the line to remove the prefixes for reports, etc.
Helpful Harry
)
#10
| |||
| |||
|
|
In article <yourname-2510111326270001 (AT) 203-118-185-196 (DOT) dsl.dyn.ihug.co.nz>, yourname (AT) yourisp (DOT) com (Your Name) wrote: In article <ws21-0B7E21.13214124102011 (AT) newsstand (DOT) cit.cornell.edu>, Bill Steele <ws21 (AT) cornell (DOT) edu> wrote: Want to use the table as the source for a value list, where the dropdown list will display items in an arbitrary order determined by business decisions (i.e., what the boss wants). The order of the options in a Value List is determined by the Value List definition, not the order of the records within the Table. Taking a Value List from a Field (one field) will sort the options in alphanumeric order. To sort them into a different order you'll need to use a second field and set-up the Value List definition to use that as the sort order. For example if the Table contains Fields with data: Fred Barney Betty Wilma BamBam Peebles Then the Value List will display as BamBam Barney Betty Fred Peebles Wilma If you add a second field to the Table and Value List definition, you can have them displayed in whatever order you want by setting the new second field to have data in your desired numerical order. e.g. by gender, grouped by Flintstone family first and Rubble family second 01 Peebles 02 Wilma 03 Betty 04 BamBam 05 Fred 06 Barney Of course, you don't HAVE to add a second Field. You could just alter the data in the original Field to have the number prefixes and get the same result, although you may then need a new Calculation field somewhere along the line to remove the prefixes for reports, etc. Helpful Harry ) |
and the value list *does* adopt the order of the items in the field.
What I need is a way to make it easy for a user to change the order. The
ideal would be something like the Filemaker script editor, where you can
grab a line and move it up or down. (Can that be done in the Xcode
interface builder?)
 |
« 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.