AnsweredAssumed Answered

how to INSERT (not add) a record in a portal?

Question asked by tony.dhoop@telenet.be on Jun 29, 2013
Latest reply on Oct 6, 2013 by tony.dhoop@telenet.be

How to insert a row in portal data?

Example : if a portal would look like

A

B

D

and one wants to insert "C", it would be nice to have it between "B" and "D" .

However, Filemaker will insert it after the "D", which is inconvenient.

A

B

D

C

(in this example sorting on name would work, but there are many other examples where it does not, where one wants a very specific, sometimes subjective, order of portal records).

Thought about adding a field "sort" and sort on that number, giving

A 01

B 02

D 03

C

but then the user needs to change the value of D from 03 to 04 and set C to 03 ... again, not very user friendly... (althought it would work)

A 01

B 02

C 03

D 04

So I'm looking for a clean and easy way to insert a row between two rows of a portal.

Any suggestions?

Thanks!

Tony

Outcomes