Hi All, As of TMS 2018, when a new field is added to an existing Flex Field group it will be added to all previous records that already contain the group so you do not need to run any SQL scripts to add the new field manually. Cheers, Graeme Graeme Housego | Client Care Specialist [log in to unmask]<mailto:[log in to unmask]> | 646.733.2239 x235 GallerySystems | https://nam02.safelinks.protection.outlook.com/?url=www.gallerysystems.com&data=02%7C01%7CTMSUSERS%40SI-LISTSERV.SI.EDU%7Ce572d15a95894778187f08d70ae16005%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989835414240803&sdata=G2CUqP0gs8ZoknrF8Fy720xaernKyng5uPI2%2FSmXVXU%3D&reserved=0<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.gallerysystems.com%2F&data=02%7C01%7CTMSUSERS%40SI-LISTSERV.SI.EDU%7Ce572d15a95894778187f08d70ae16005%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989835414240803&sdata=OsZu2cSUSVrz1FBwrubP3gdFSvZ4sAdvetq0KAZbigE%3D&reserved=0> From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Chad Petrovay Sent: Wednesday, July 17, 2019 11:49 AM To: [log in to unmask] Subject: Re: Adding to Flex Field Groups EXTERNAL: Do not click links or open attachments if you do not recognize the sender. 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]<mailto:[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%7Ce572d15a95894778187f08d70ae16005%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989835414240803&sdata=JdEalciS2xK7%2Bt90sIx9MofHOfDPbKskp1h7J%2Bh3YTo%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%7Ce572d15a95894778187f08d70ae16005%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989835414250807&sdata=%2FZHVlCndxygnkCtuDKMCyOf7tqtHDAZsRhHkLc4UuXk%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]<mailto:[log in to unmask]> https://nam02.safelinks.protection.outlook.com/?url=www.rom.on.ca&data=02%7C01%7CTMSUSERS%40SI-LISTSERV.SI.EDU%7Ce572d15a95894778187f08d70ae16005%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989835414250807&sdata=CySh3YYJ8a5igb5riEq6cvHvFi28JVnZM1yuBBFgq08%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%7Ce572d15a95894778187f08d70ae16005%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989835414250807&sdata=NlKH9s9%2B5IdyiLN71PzTQuqGpvTzYdzGP23JyNMSQ74%3D&reserved=0> From: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Shepherd, Rupert Sent: Wednesday, July 17, 2019 7:53 AM To: [log in to unmask]<mailto:[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]<mailto:[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 removed by sender. 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%7Ce572d15a95894778187f08d70ae16005%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989835414250807&sdata=0lRa7qlzSIC%2BK055mjw%2FwFsbzK1CFXJFk%2Fh9PoRCBpU%3D&reserved=0> [Image removed by sender. “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%7Ce572d15a95894778187f08d70ae16005%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989835414250807&sdata=xVkfsvLM3IDNuDQ4aOae7uafZJAUDuZwQRBPZfPPLxc%3D&reserved=0> 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. 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%7Ce572d15a95894778187f08d70ae16005%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989835414250807&sdata=QttAvsTiV9N4lPAm4XT5ZqzIgp8b6ba4W8Zne7bDRLc%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%7Ce572d15a95894778187f08d70ae16005%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989835414250807&sdata=vQP0Ouojeh%2FG1ws8PnUw1xtjklprADzK6S9c5F8rDh0%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%7Ce572d15a95894778187f08d70ae16005%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989835414250807&sdata=5iHa5bA1H3P0CRZS1Goe%2FK2MUbTsuU8bzoNDpt20lKs%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%7Ce572d15a95894778187f08d70ae16005%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989835414250807&sdata=XLLfPmURlUnfa%2FNJdpwdzUVr74zSTImzxZCGrc1ZLpY%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%7Ce572d15a95894778187f08d70ae16005%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989835414260816&sdata=MTCoZ6FmWBcjnLFOMjcRK2a4Qg9IVKmuIpKWUJK4%2Blk%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%7Ce572d15a95894778187f08d70ae16005%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989835414260816&sdata=Ix3qcfT07d%2FQy8ZfS5e%2BWPGLUczhlMj2S9%2Fn20kagUw%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%7Ce572d15a95894778187f08d70ae16005%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989835414260816&sdata=gWXviS%2Fzt%2F94jZT3jzxlfcxLFQVMBqaL%2FTiMsz3VPIk%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%7Ce572d15a95894778187f08d70ae16005%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989835414260816&sdata=RAQcFXngBAY3JtBCTez%2Bx31412AQMTvu34bYDVSYrL0%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%7Ce572d15a95894778187f08d70ae16005%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989835414260816&sdata=7kRAL%2BxxY8F0O%2BbftiCDBEURAYpwfVgVJTDwHo0YXzE%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%7Ce572d15a95894778187f08d70ae16005%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989835414260816&sdata=wpUWADOIlJlEQuxSsrIyHxHYMFDgGy7EIwTSt9FKHYE%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%7Ce572d15a95894778187f08d70ae16005%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989835414260816&sdata=BsvU04lR1LzGz3j5Ib%2BsOdqSEvPb0BLt6OYUed9wQ68%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%7Ce572d15a95894778187f08d70ae16005%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989835414260816&sdata=oc%2FF0i4P3kUvwbiMrwHYAI9Ma1xMc376SiDRXJaU1JY%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%7Ce572d15a95894778187f08d70ae16005%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989835414270825&sdata=pG6Y9qfGpIiwOFXbFdVC9Y8mothxMBozTzbu3yiKN4s%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%7Ce572d15a95894778187f08d70ae16005%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636989835414270825&sdata=CbOy4XnLKvjw8Mzoo6s%2FoElcZp%2F%2Bta%2FA7NBgvvbHSgw%3D&reserved=0> 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.