Dear GS,
As a recent user of TMS and Flex Fields, we’ve encountered so far a huge frustration with them regarding the fact that cross-searching FF is a nightmare but could be so useful.
We use them a lot already for our audit features and searching items that are:
- Viewed (FF) but in a bad shape (FF)
- viewed, in good shape but in need of a recent photograph (FF)…
- so on
would be great to organize post-audit operations.
Am I missing something, am I the only one ?
Thanks Rupert, you can count me on the list ☺
Thank you very much Chad for this report !!!
Elsa
Elsa Badie Modiri
Chargée de projet – Administrateur de la base de données M’Osaïque
Gestion informatisée des collections – Service de la Conservation
Musée d’Orsay
62, rue de Lille
75343 Paris Cedex 07
Tél. : + 33 (0)1 40 49 49 87 – Fax : + 33 (0)1 45 49 05 54
Email : [log in to unmask]<mailto:[log in to unmask]>
Consultez le catalogue complet des 97 000 oeuvres du musée d'Orsay <http://www.musee-orsay.fr/fr/collections/bienvenue.html?S=0>
De : The Museum System (TMS) Users [mailto:[log in to unmask]] De la part de Jon Thristan
Envoyé : jeudi 19 avril 2018 16:00
À : [log in to unmask]
Objet : Re: Including Flex Field Data in Crystal Reports
Hi Rupert
Thanks for your suggestion, below. The changes you suggest will be included in TMS 2019.
Best wishes
Jon
Jon Thristan MBCS | Project Consultant
[log in to unmask]<mailto:[log in to unmask]> | +44 20 7993 8402
GallerySystems | www.gallerysystems.com<http://www.gallerysystems.com/>
From: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Shepherd, Rupert
Sent: 18 April 2018 10:04
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: Including Flex Field Data in Crystal Reports
Chad, thanks – this’ll be very useful as we use Flex Fields more and more.
But – is anyone else frustrated by the fact that these views only contain the main ‘Value’ Flex Field, and not the Date and Remarks fields that accompany the Value? When I’m using Flex Fields, I quite often use all three at once. I’ve raised it with our UK GS reps as a feature request, but if anyone else wanted to reply to this email and add their names to the list of people who’d find this useful, I’m, sure it would encourage GS t5o make the change.
Best wishes
Rupert
Rupert Shepherd, PhD FSA
Collection Information Manager
[log in to unmask]<mailto:[log in to unmask]>
Tel: +44 (0)20 7747 5921
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Chad Petrovay
Sent: 17 April 2018 17:37
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Including Flex Field Data in Crystal Reports
I'm not sure when this feature was added, but TMS automatically creates SQL views in the database whenever you a new Flex Field is defined in the system.
If you want to include Flex Field data in your Crystal Reports (Hey, who wouldn't? Am I right?), these views make your life much easier. There is no need to write complex Record Selection formula; all you need to do is join
The problem is that you need to find the view that includes your desired flex field. This can be complicated, since the view names are based upon key values from table records.
Attached is a Crystal Report I developed that shows you which view and field name corresponds to your Flex Fields. They are organized by Context and Group name, for easy reference.
Please enjoy, ~Chad
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.