As usual, great tutorial but as I am sure you would agree... Using containers is fine for a few files but time consuming when you have to add each image, file or media file one at a time. And when you are dealing with gigabytes of related data... frustrating. I've been using.... *Save Records as pfd* ...to create a folder structure on my _'Google Drive'_ related to each and every new record in my database. And within each record is a button with the script... *Open URL* ...which opens the related folder on _'Google Drive'_ that was created by the previous script at the creation of the record. So once a new filemaker record has been created, I just press the button to access the folder created on _'Google Drive'_ associated with that record, where I can dump or access gigabytes of data in any type of file structure I wish. If your database is going to be accessed by both Macs and PCs all you have to do is use... Get(SystemPlatform) within an _'IF statement'_ to make it chose the Mac or Windows path in your script. It is a fantastic way to dump both related data on mass, such as whole folders or selections of files just as you do on your computer, and access them at a later date having quickly found the Filemaker record to access the button that will open the related data for that record on your Google Drive. Hey, Guy... how about doing a tutorial on how to do this for a database accessed by both Mac's and Pcs? I for one would love to see how you go about it plus am interested if I might have missed some function that would make my version better.
Hi, I am new to filemaker pro and found your videos very helpful. I inserted mutiple images and it was working well. Then for some reason after I had inserted images into the portal; when I clicked outside of the any data box (i.e. onto the "white space" of the screen or went to another record) the images disappeared. When I change to table view it shows a column for image but doesn't have anything in it. I have started from scratch (i'e' deleted the portal and re installed) . I must have changed something but can not find out what. Any suggestions?
8 років тому
Thank you for sharing,,,,Can I send a record of pictures at once with email (multiple attach)..Or how to compress to zip for one file? Şemsi Saracoğlu
+Şemsi Saracoğlu You can only attach one file to an email with Filemaker. I would create a layout where you have multiple pictures, save that as one PDF and attach that to the email. But that way you don't have the images as image files. Greetings Guy
8 років тому
+Guy Stevens Actually it can be made with mandrill membership.But I want to solve with FileMaker..Your suggestion that it worked.I save as PDF and sent...Thank you very much for your help... Respects Şemsi Saracoğlu
Hey Guy, I've been following your video as well as watching your lessons on Udemy. Great stuff. I was wondering if I could ask you a couple questions related to our companies database when you have a free second?
Ken Bernock Why don't you post your question on the Filemaker Forum and let me know the link. That way you can get the opinion of multiple people: forums.filemaker.com/hives/12f66388aa/summary
What are the chances you would want to share the database? This has everything I need to capture images of company paper based records. Thanks in advance for your consideration.
I am curious why in this one, it needs me to use the next and back buttons up in the top of filemaker. Wouldn't adding some next and previous buttons along with some kind of text that says image 1 thru # allowing people to put in a number of the image help with this. If this were to go in a app for instance, people wouldn't have filemaker to forward those images, so you need some kind of button to get to the next image. I actually like this image related "slideshow" type over the other that I just have created and thought is it possible to just use the next and previous buttons like you did in the Image Grid video? Would it be possible to show the name of the image also underneath the image? I hate asking you to show me how to accomplish that task, but would appreciate it, or even allowing us to add the ability to name the image when it's added would be super. I really appreciate your videos, I have learned so much from them. Thank you so much.
Hi Marian, Yes of course you could add buttons for navigation. And you can name your images and show the names as well. My intention here was simply to show a basic technique. All the bells and whistles that you would need to make your solution work can simply be added. In the pictures table you could add a text field for the name of the picture. And that field can then be placed on your layout. Greetings Guy
i just want to ask about how to import the photos one by one to multiple records without inserting , i was working on adatabase where i was only writng the number of the photo and it was directly added to my record but i don,t know how they did that link
Well, if you don't know what was done then I can't know how it was done :) I also have no idea how they did that :) It's possible to import a whole bunch of pictures in a table, give them a number and then you could enter this number in a field to create a relationship and hence make the picture show up on a related record. You could enter a number and then import a bunch of pictures, look for the one with that number and then remove the rest. But that seems rather impractical. If your images are in folders then maybe the folder name could be used to only import images from that folder. But as I said. I have no idea on what was done and how. Greetings Guy
Dit is precies wat ik nodig had. Echter het zou mooi zijn dat ik op basis van de naam en de aanmaakdatum de bestanden in een externe map kan opslaan. Is daar ook een truc voor? Daar worstel ik namelijk mee dat kan alleen op basis van relaties
Hey Albert, Je kan je container files opslaan in een externe map en je kan daar zelfs mappen en submappen maken waar je waarden uit velden kan in gebruiken. Dit zit hem in File - Manage - Containers. Daar kan je externe locaties opgeven. Dan moet je in de settings van je container veld zelf ook nog kiezen in welke locatie er moet opgeslagen worden. Groetjes Guy
Guy, Dank je wel. Voor de naam van de map wil ik namelijk ook de FloweridFK gebruiken. Dat is nu gelukt en werkt goed als ik één afbeelding in het portaal toevoeg. Maar als het script gebruik wat natuurlijk heel handig is, wordt het idFK pas naderhand ingevuld en wordt de map niet aangemaakt. Wellicht wel heel ingewikkeld nu maar dat is wat ik probeer uit te vogelen. Dat is helaas nog niet gelukt Gr. Albert
Als de IDFK te laat wordt aangemaakt, kan je dan niet de ID van de hoofdtabel gebruiken? Of tijdens je script de ID ergens tijdelijk in een global field plaatsen? Groetjes Guy
Dat heb ik geprobeerd id in variabel en dan in globaal veld. Dat gaat prima als ik 1 record aanmaak dan gaat het goed. Helaas niet als ik het via het script doe :(
Ik zou het eens moeten proberen. Ik kan zo niet zeggen wat nog een andere optie zou kunnen zijn. Ik zou dan de file moeten namaken met external storage. Groetjes Guy
Sorry, Im stupid, you answer this later in the video. Hello Guy, I watched this video which is great. As you inserted the very first Rose picture in the video you actually insert the picture. Is this better than storing a reference? My pictures are all quite big. The main database is for storing information related to models, actors, locations and props for filming. My FMP knowledge comes from 15 years ago and I am just getting back in to it. I have dragged my database through the FMP version upgrades. The reason i store a reference is because early versions could only store 200Mb of info. What is the best way today. Im using FM Pro Advanced 13
There are different pro's and con's here. If you store a reference your Filemaker File stays nice and small and is more easily backed up. But if you move your image files the links could be broken. If you store your Images inside Filemaker then you can move the Filemaker file around and your images will remain inside. I guess it depends on your needs. If you are putting a load of pictures in there I would probably also suggest to store them externally. No matter how it's done right now you can simply change the storage and Filemaker will move the files inside or outside Filemaker. Greetings Guy
Thanks, this is useful. I will keep everything on a 2Tb external disc. I have thousands of images, so to start with I will continue to reference them. I have a second question that I will start a new thread for. Thanks again
I am working on a solution were I need to be tracking offsprings a particular cow through to nth generation, with more emphasis on the female offsprings. Have you worked on something like in past that I can look at.
+Charles Katjivirue Hi Charles, I'm sorry but I seem to have missed your post. I don't have anything exactly like that. What is it you need to do exactly? Do you need to track a cow, it's offspring and then the offspring of those cows as well? Greetings Guy
+Charles Katjivirue Hi Guy Thanks a long for your response. I really appreciate what you are doing. You are pretty much right. I want to be able to tracking the matrilineage offsprings of my original cow.
+Charles Katjivirue I haven't tried this and this should maybe be tested before you can really see if this would work or not. But I would guess you could maybe do this with a simple join table. I think this would probably be most flexible for entering the parents and grandparents of the calf. You will need a table for all the cows. There you enter both male and female cows. Then you create a join table to relate the cows table with another table occurrence of itself. Then you can relate a cow to another cow in the join table. You can also add fields to define the relationship. Like the mother and father of the cow could be in there but also the grandparents. And because of the join table you could add as many relationships as you want. And as many generations as you want. You could add the birth date etc. You could also add brothers and sisters. Again, I haven't tried this, so I don't know if this is the best possible way to go about doing this. Check out this video for an explanation on a join table: ua-cam.com/video/n0BRKaHgKn8/v-deo.html
Watched 2 hours of tutorials. This one did it in 10 mins. Excellent. "This is good". Thanks.
Fantastic video! Very well explained, I managed to do the magic all by myself with your advice, and I'm not an IT person! :)
thank you. with your tutorial finally, my simple FMP database is working :)
Thanks, this video really came as a blessing. I will be one of the my permanent reference video, it is loaded wit lots of good tips.
This video solved all my problems. This video was a great help. Thanks again for your help. :D
Great, I'm glad it helped :)
Greetings
Guy
Thank you for the video! Very good instruction.
As usual, great tutorial but as I am sure you would agree...
Using containers is fine for a few files but time consuming when you have to add each image, file or media file one at a time. And when you are dealing with gigabytes of related data... frustrating.
I've been using....
*Save Records as pfd*
...to create a folder structure on my _'Google Drive'_ related to each and every new record in my database.
And within each record is a button with the script...
*Open URL*
...which opens the related folder on _'Google Drive'_ that was created by the previous script at the creation of the record.
So once a new filemaker record has been created, I just press the button to access the folder created on _'Google Drive'_ associated with that record, where I can dump or access gigabytes of data in any type of file structure I wish.
If your database is going to be accessed by both Macs and PCs all you have to do is use...
Get(SystemPlatform) within an _'IF statement'_ to make it chose the Mac or Windows path in your script.
It is a fantastic way to dump both related data on mass, such as whole folders or selections of files just as you do on your computer, and access them at a later date having quickly found the Filemaker record to access the button that will open the related data for that record on your Google Drive.
Hey, Guy... how about doing a tutorial on how to do this for a database accessed by both Mac's and Pcs? I for one would love to see how you go about it plus am interested if I might have missed some function that would make my version better.
it,s avery important video thank you very much
Hi, I am new to filemaker pro and found your videos very helpful. I inserted mutiple images and it was working well. Then for some reason after I had inserted images into the portal; when I clicked outside of the any data box (i.e. onto the "white space" of the screen or went to another record) the images disappeared. When I change to table view it shows a column for image but doesn't have anything in it. I have started from scratch (i'e' deleted the portal and re installed) . I must have changed something but can not find out what. Any suggestions?
Thank you for sharing,,,,Can I send a record of pictures at once with email (multiple attach)..Or how to compress to zip for one file?
Şemsi Saracoğlu
+Şemsi Saracoğlu You can only attach one file to an email with Filemaker.
I would create a layout where you have multiple pictures, save that as one PDF and attach that to the email.
But that way you don't have the images as image files.
Greetings Guy
+Guy Stevens Actually it can be made with mandrill membership.But I want to solve with FileMaker..Your suggestion that it worked.I save as PDF and sent...Thank you very much for your help...
Respects
Şemsi Saracoğlu
Thank you for sharing! groetjes uit Miami, Florida
Nederlandstalige groetjes uit Miami Florida.
Da's wel speciaal :)
Groetjes
Guy
Hey Guy, I've been following your video as well as watching your lessons on Udemy. Great stuff. I was wondering if I could ask you a couple questions related to our companies database when you have a free second?
Ken Bernock You can always ask. I can't guarantee I'll have any descent answers :) Greetings Guy.
Great! What's the best channel to ask you? email, twitter? etc... It's a little longer than just writing a comment
Ken Bernock Why don't you post your question on the Filemaker Forum and let me know the link. That way you can get the opinion of multiple people: forums.filemaker.com/hives/12f66388aa/summary
What are the chances you would want to share the database? This has everything I need to capture images of company paper based records. Thanks in advance for your consideration.
The chances are pretty good seeing as how the download link is in the description. :)
Greetings Guy
I am curious why in this one, it needs me to use the next and back buttons up in the top of filemaker. Wouldn't adding some next and previous buttons along with some kind of text that says image 1 thru # allowing people to put in a number of the image help with this. If this were to go in a app for instance, people wouldn't have filemaker to forward those images, so you need some kind of button to get to the next image. I actually like this image related "slideshow" type over the other that I just have created and thought is it possible to just use the next and previous buttons like you did in the Image Grid video? Would it be possible to show the name of the image also underneath the image? I hate asking you to show me how to accomplish that task, but would appreciate it, or even allowing us to add the ability to name the image when it's added would be super. I really appreciate your videos, I have learned so much from them. Thank you so much.
Hi Marian,
Yes of course you could add buttons for navigation. And you can name your images and show the names as well.
My intention here was simply to show a basic technique. All the bells and whistles that you would need to make your solution work can simply be added.
In the pictures table you could add a text field for the name of the picture. And that field can then be placed on your layout.
Greetings Guy
Very good video :)
i just want to ask about how to import the photos one by one to multiple records without inserting , i was working on adatabase where i was only writng the number of the photo and it was directly added to my record but i don,t know how they did that link
Well, if you don't know what was done then I can't know how it was done :)
I also have no idea how they did that :)
It's possible to import a whole bunch of pictures in a table, give them a number and then you could enter this number in a field to create a relationship and hence make the picture show up on a related record.
You could enter a number and then import a bunch of pictures, look for the one with that number and then remove the rest. But that seems rather impractical.
If your images are in folders then maybe the folder name could be used to only import images from that folder.
But as I said.
I have no idea on what was done and how.
Greetings
Guy
Dit is precies wat ik nodig had. Echter het zou mooi zijn dat ik op basis van de naam en de aanmaakdatum de bestanden in een externe map kan opslaan. Is daar ook een truc voor? Daar worstel ik namelijk mee dat kan alleen op basis van relaties
Hey Albert,
Je kan je container files opslaan in een externe map en je kan daar zelfs mappen en submappen maken waar je waarden uit velden kan in gebruiken.
Dit zit hem in File - Manage - Containers.
Daar kan je externe locaties opgeven.
Dan moet je in de settings van je container veld zelf ook nog kiezen in welke locatie er moet opgeslagen worden.
Groetjes
Guy
Guy, Dank je wel.
Voor de naam van de map wil ik namelijk ook de FloweridFK gebruiken. Dat is nu gelukt en werkt goed als ik één afbeelding in het portaal toevoeg.
Maar als het script gebruik wat natuurlijk heel handig is, wordt het idFK pas naderhand ingevuld en wordt de map niet aangemaakt. Wellicht wel heel ingewikkeld nu maar dat is wat ik probeer uit te vogelen. Dat is helaas nog niet gelukt
Gr.
Albert
Als de IDFK te laat wordt aangemaakt, kan je dan niet de ID van de hoofdtabel gebruiken? Of tijdens je script de ID ergens tijdelijk in een global field plaatsen?
Groetjes
Guy
Dat heb ik geprobeerd id in variabel en dan in globaal veld. Dat gaat prima als ik 1 record aanmaak dan gaat het goed. Helaas niet als ik het via het script doe :(
Ik zou het eens moeten proberen. Ik kan zo niet zeggen wat nog een andere optie zou kunnen zijn.
Ik zou dan de file moeten namaken met external storage.
Groetjes
Guy
Claris should make adding multiple images to one record much easier.
its kinda cool
Sorry, Im stupid, you answer this later in the video.
Hello Guy, I watched this video which is great. As you inserted the very first Rose picture in the video you actually insert the picture. Is this better than storing a reference? My pictures are all quite big. The main database is for storing information related to models, actors, locations and props for filming. My FMP knowledge comes from 15 years ago and I am just getting back in to it. I have dragged my database through the FMP version upgrades. The reason i store a reference is because early versions could only store 200Mb of info. What is the best way today. Im using FM Pro Advanced 13
There are different pro's and con's here.
If you store a reference your Filemaker File stays nice and small and is more easily backed up.
But if you move your image files the links could be broken.
If you store your Images inside Filemaker then you can move the Filemaker file around and your images will remain inside.
I guess it depends on your needs.
If you are putting a load of pictures in there I would probably also suggest to store them externally.
No matter how it's done right now you can simply change the storage and Filemaker will move the files inside or outside Filemaker.
Greetings Guy
Thanks, this is useful. I will keep everything on a 2Tb external disc. I have thousands of images, so to start with I will continue to reference them. I have a second question that I will start a new thread for. Thanks again
It doesn't work with more than 1000 pics.
I am working on a solution were I need to be tracking offsprings a particular cow through to nth generation, with more emphasis on the female offsprings. Have you worked on something like in past that I can look at.
+Charles Katjivirue Hi Charles, I'm sorry but I seem to have missed your post.
I don't have anything exactly like that.
What is it you need to do exactly?
Do you need to track a cow, it's offspring and then the offspring of those cows as well?
Greetings
Guy
+Charles Katjivirue
Hi Guy
Thanks a long for your response. I really appreciate what you are doing. You are pretty much right. I want to be able to tracking the matrilineage offsprings of my original cow.
+Charles Katjivirue I haven't tried this and this should maybe be tested before you can really see if this would work or not. But I would guess you could maybe do this with a simple join table.
I think this would probably be most flexible for entering the parents and grandparents of the calf.
You will need a table for all the cows. There you enter both male and female cows.
Then you create a join table to relate the cows table with another table occurrence of itself.
Then you can relate a cow to another cow in the join table. You can also add fields to define the relationship. Like the mother and father of the cow could be in there but also the grandparents. And because of the join table you could add as many relationships as you want. And as many generations as you want. You could add the birth date etc.
You could also add brothers and sisters.
Again, I haven't tried this, so I don't know if this is the best possible way to go about doing this.
Check out this video for an explanation on a join table: ua-cam.com/video/n0BRKaHgKn8/v-deo.html
+Guy Stevens
Thanks, it will take sometime before I can give you real feedback.
+Charles Katjivirue
Mr. Stevens, would you mind if I send a sample of the solution that I am working, maybe it will enable you to give focused advice?