New flex fields that are added to a group will not appear in records where
the group has already been added. You will need to execute a SQL script to
insert the new field(s) into existing instances of the group.
On Wed, Jul 17, 2019 at 10:43 AM Brad Hubley <[log in to unmask]> wrote:
> Hi Rupert;
>
>
>
> Danielle has posted a request for this capability in the their Ideas forum
> at https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcommunity.gallerysystems.com%2Fs%2Fideas%2308741000000bmeRAAQ&data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7C71c1ff4de47e4104d15b08d70ace4d5e%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989753492555552&sdata=PUqHT0kgr0vcw99%2Bv%2BdgDphTjwwL0NoRmXwiXSDZ99E%3D&reserved=0
> <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcommunity.gallerysystems.com%2Fs%2Fideas%2308741000000bmeRAAQ&data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7C71c1ff4de47e4104d15b08d70ace4d5e%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989753492555552&sdata=PUqHT0kgr0vcw99%2Bv%2BdgDphTjwwL0NoRmXwiXSDZ99E%3D&reserved=0>
> .
>
>
>
>
>
> *Brad Hubley*
>
> *Entomology Collection Manager*
>
> Natural History – Entomology
>
> Royal Ontario Museum
>
> 100 Queen’s Park
>
> TORONTO ON M5S 2C6
>
> CANADA
>
>
>
> Phone: 1-416-586-5674
>
> Email: *[log in to unmask] <[log in to unmask]>*
>
> *https://nam02.safelinks.protection.outlook.com/?url=www.rom.on.ca&data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7C71c1ff4de47e4104d15b08d70ace4d5e%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989753492555552&sdata=OQL8OyiUkTOHJTK6YGguWR8Uqo1akixFYtTp8j2UQ%2BM%3D&reserved=0 <https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.rom.on.ca&data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7C71c1ff4de47e4104d15b08d70ace4d5e%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989753492555552&sdata=D5veysp2jOlW7pkL3%2Fyqx0dH7zp%2FJ5pARrQDzrU4D%2Fk%3D&reserved=0>*
>
>
>
>
>
>
>
> *From:* The Museum System (TMS) Users <[log in to unmask]> *On
> Behalf Of *Shepherd, Rupert
> *Sent:* Wednesday, July 17, 2019 7:53 AM
> *To:* [log in to unmask]
> *Subject:* Adding to Flex Field Groups
>
>
>
> Dear colleagues
>
>
>
> Does anyone have any experience of adding to Flex Field Groups once
> they’ve been implemented and data has been added to them? I’m planning to
> implement an FFG for all Constituent records, to which I expect I will need
> to add further, as yet undefined, fields in due course; can this be done
> without loss of data; and how would one go about adding that new field to
> the group, for records where it’s already been added and populated?
>
>
>
> With thanks and best wishes
>
>
>
> Rupert
>
>
>
> *Rupert Shepherd, PhD FSA*
>
> Collection Information Manager
>
> [log in to unmask]
>
> Tel: +44 (0)20 7747 5921
>
>
>
> Please note that I usually work from home on Fridays; calls to the number
> above should still reach me.
>
>
>
> [image: The National Gallery, Trafalgar Square, London WC2N 5DN]
> <https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.nationalgallery.org.uk&data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7C71c1ff4de47e4104d15b08d70ace4d5e%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989753492565549&sdata=QuhX5ipp24BO86E3DO4hCul7C7eynz%2B8%2B1pSYK71fQw%3D&reserved=0>
> [image: “Bartolome]
> <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.nationalgallery.org.uk%2Fexhibitions%2Fbartolome-bermejo&data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7C71c1ff4de47e4104d15b08d70ace4d5e%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989753492565549&sdata=N%2Fa1eEfW6xz1f5MYccHBJOLP7ual5dZsJkkSBlK4tC8%3D&reserved=0>
>
> 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.
>
> *ON NOW*
> Treasures of a Desert Kingdom: The Royal Arts of Jodhpur, India
> <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.rom.on.ca%2Fen%2Fexhibitions-galleries%2Fexhibitions%2Frajasthan&data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7C71c1ff4de47e4104d15b08d70ace4d5e%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989753492565549&sdata=M496LbHz0RKpK3E7G3GDETGO0VfnGAOiCLbVlZCSBcg%3D&reserved=0>
> In the Age of Rembrandt: Dutch Paintings from the Museum of Fine Arts,
> Boston
> <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.rom.on.ca%2Fen%2Fexhibitions-galleries%2Fexhibitions%2Fin-the-age-of-rembrandt-dutch-paintings-from-the-museum-of-fine&data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7C71c1ff4de47e4104d15b08d70ace4d5e%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989753492565549&sdata=Ag6cUPh2y15Kn6ZAESTiehANLpzO0vjFGlpvFe2YT8Q%3D&reserved=0>
> It's Alive! Classic Horror and Sci-Fi Art from the Kirk Hammett Collection
> <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.rom.on.ca%2Fen%2Fexhibitions-galleries%2Fexhibitions%2Fits-alive-classic-horror-and-sci-fi-art-from-the-kirk-hammett-0&data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7C71c1ff4de47e4104d15b08d70ace4d5e%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989753492565549&sdata=PIg21eBU%2B%2FebIdvKzyDfpUIePBRgzext8jLOEwPlCic%3D&reserved=0>
> Gods in My Home: Chinese New Year with Ancestor Portraits and Deity Prints
> <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.rom.on.ca%2Fen%2Fexhibitions-galleries%2Fexhibitions%2Fgods-in-my-home-chinese-new-year-with-ancestor-portraits-and-deity&data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7C71c1ff4de47e4104d15b08d70ace4d5e%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989753492565549&sdata=KY5pNllaM5XLxEa9qs%2BzlkyoXWdk6F2neFjnqgs7JBM%3D&reserved=0>
> Being Japanese Canadian: reflections on a broken world
> <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.rom.on.ca%2Fen%2Fexhibitions-galleries%2Fexhibitions%2Fbeing-japanese-canadian&data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7C71c1ff4de47e4104d15b08d70ace4d5e%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989753492565549&sdata=Th%2FJm6z4k6%2BtchRdzzo7Jtl0SqQDBmZ2Vg5gej4uvkM%3D&reserved=0>
>
> *COMING SOON*
> November 16, 2019 | Bloodsuckers: Legends to Leeches
> <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.rom.on.ca%2Fen%2Fexhibitions-galleries%2Fexhibitions%2Fbloodsuckers-legends-to-leeches&data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7C71c1ff4de47e4104d15b08d70ace4d5e%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989753492565549&sdata=jbNJWKJUoaX9O4A3denRZALa66Qli2U267t1pSuZVRE%3D&reserved=0>
> March 7, 2020 | Egyptian Mummies: Exploring Ancient Lives
> <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.rom.on.ca%2Fen%2Fexhibitions-galleries%2Fexhibitions%2Fegyptian-mummies-exploring-ancient-lives&data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7C71c1ff4de47e4104d15b08d70ace4d5e%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989753492575547&sdata=tEWQlwRKKXu4nhgyrKJ24NcumALTBlD0ys6ldkgzFRo%3D&reserved=0>
> ------------------------------
>
> *À L’AFFICHE*
> Trésors d’un royaume du désert : les arts de la cour de Jodhpur, en Inde
> <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.rom.on.ca%2Ffr%2Fexpositions-et-galeries%2Fexpositions%2Ftresors-dun-royaume-du-desert-les-arts-de-la-cour-de-jodhpur-0&data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7C71c1ff4de47e4104d15b08d70ace4d5e%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989753492575547&sdata=kKPLinxTn4AACj2aYKTGjscIZIbtKXXThkYgWpOaDzw%3D&reserved=0>
> Au temps de Rembrandt : Les peintures hollandaises du Musée des beaux-arts
> de Boston
> <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.rom.on.ca%2Ffr%2Fexpositions-et-galeries%2Fexpositions%2Fau-temps-de-rembrandt-les-peintures-hollandaises-du-musee-des&data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7C71c1ff4de47e4104d15b08d70ace4d5e%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989753492575547&sdata=lgphWfx0%2Be%2FFerFFpGrGgOVp93X20Hk2LQjkW8n%2BovE%3D&reserved=0>
> Sauve qui peut! L’art des grands films d’horreur et de science-fiction de
> la collection de Kirk Hammett
> <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.rom.on.ca%2Ffr%2Fexpositions-et-galeries%2Fexpositions%2Fsauve-qui-peut-lart-des-grands-films-dhorreur-et-de-science&data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7C71c1ff4de47e4104d15b08d70ace4d5e%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989753492575547&sdata=cMWWeuqQQVuLRM6eKIHydSpvPxIfNQqfp9OJlfNrXGE%3D&reserved=0>
> Accueillir les divinités : Portraits d'ancêtres et estampes de dieux pour
> le nouvel an chinois
> <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.rom.on.ca%2Ffr%2Fexpositions-et-galeries%2Fexpositions%2Faccueillir-les-divinites-portraits-dancetres-et-estampes-de&data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7C71c1ff4de47e4104d15b08d70ace4d5e%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989753492575547&sdata=PbMvRuo2vFEerOS%2FnbCqq%2B3yDf8ThjqWbHOqX2urT%2Fc%3D&reserved=0>
> Je suis Canadien d’origine japonaise : réflexions sur un monde déchiré
> <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.rom.on.ca%2Ffr%2Fexpositions-et-galeries%2Fexpositions%2Fje-suis-canadien-dorigine-japonaise&data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7C71c1ff4de47e4104d15b08d70ace4d5e%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989753492575547&sdata=P7qJ9hM8qqCuXAM%2FS2f0SwvDMdTLtu8gutCGd2Ry15M%3D&reserved=0>
>
> *À VENIR*
> Le 16 novembre 2019 | Soif de sang
> <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.rom.on.ca%2Ffr%2Fexpositions-et-galeries%2Fexpositions%2Fsoif-de-sang&data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7C71c1ff4de47e4104d15b08d70ace4d5e%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989753492575547&sdata=r8%2BJwBtBxhAwUxbh62wiEHbvpQw0xQL8io0Y6S74wdE%3D&reserved=0>
> Le 7 mars 2020 | Les momies égyptiennes : À la rencontre des Anciens
> <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.rom.on.ca%2Ffr%2Fexpositions-et-galeries%2Fexpositions%2Fles-momies-egyptiennes-a-la-rencontre-des-anciens&data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7C71c1ff4de47e4104d15b08d70ace4d5e%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989753492585540&sdata=RyMglYV%2F71AZU9vSGvo3QLSGVpSEbptjiOkbvc9yvHs%3D&reserved=0>
> 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.
>
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.