asked on

FileMaker Pro 3.0 Portals

Is there any way to use Data from a specific line (here from the last line) of a portal in a formula or for exporting the data?

Background to this question: In a database for software support I need a list of customers with their newest version.
I can't use Max(Installation::Version) because the version number is a text field, and using Max(...) FM will interpret the strings as numbers and this way version 2.01 will be treated as newer than 3.0 (it's the German version, we have a decimal comma, and so 2.01 is interpreted as 201)

I know that there is a script command to go to the last line of a portal, but having a specified field in the master database which is updated regularily with a script would take too much time.

paulvaneykelen

Why don't you input version 3.0 as 3.00

That would solve your problem 300>201

mdietz

ASKER

First: I don't know if the numeration schema is staying as it
is now. What if a version number 2.3.51 appears?
Second: This database is an existing database with too much
entries to check and change manually (OK, this could be done
by a script)
Third: The database is also used for delivery notes, license
agreements and maintenace contracts, so we can't just put a
number different from the original version number in the
database.

ASKER CERTIFIED SOLUTION

heathenchild

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mdietz

ASKER

Thanks!

Why doesn't Claris say that in the manual or online-docu? There the function Last was only mentioned with repeating fields...