Hi Sony, i recently found your Video's and find them excellent! As a long time FM User, but not Programmer your Videos show me a lot of potential to improve my FM Databases with more scripting. But why you stop posting Videos?
Hi Sony. You are very good in what you are doing. Congratulation. I have a request for you. Could you make a tutorial that show how to have complete report from inventory that can be customized, i.e. by date, by item with specific filter.
One idea for real duplicates is to create a calculated container field and put every field in it. The MD5 portion will be unique for each record, except duplicates. Find duplicate MD5s in that calculated field.
Thank you for the clear tutorial. I'm using a database of 1000+ records over a server and the second method for finding duplicates has a delay of 3-4 seconds. Is there a faster way?
Unfortunately there is no simple solution to this if you don't have extensive experience in database optimisation. Finding duplicate is by nature a CPU heavy operation, as every record in your database needs to match up against other record to check for duplicate. When you have 1000 records, the calculation needs to be done 1000 x 1000 = 1,000,000 times. Doing this via server is going to be slow.
Please post more often, Sunny. Btw, your graphic design skills are 🎉
c'est vraiment excellent et très formateur merci !
Hi Sunny
Love the videos Im enjoying your approach to training . Thank you for these videos!
a very clear explanation and good alterntives to find or avoid duplicate records. thank you for sharing
as usual, your video is very high quality. i hope you get a ton of views
Thanks. With your video, I checked the relationsship principle :)
Hi Sony, i recently found your Video's and find them excellent! As a long time FM User, but not Programmer your Videos show me a lot of potential to improve my FM Databases with more scripting. But why you stop posting Videos?
i wonder it too, he stop in the middle of pandemic day
great video. sir do you have a sample code in using digital persona without plugins?
Thank you for your tutorial Sony, could you explain how to connect Filemaker pro 18 to external camera for capturing photos? Thanks
I wonder where is sunny right now no update since pandemic day ?
Hi I have a specific question! How do I change the order of the records?
Great work Thank you
could you explain how to send email with attchment from a container field ?
Hi Sony. You are very good in what you are doing. Congratulation. I have a request for you. Could you make a tutorial that show how to have complete report from inventory that can be customized, i.e. by date, by item with specific filter.
One idea for real duplicates is to create a calculated container field and put every field in it. The MD5 portion will be unique for each record, except duplicates. Find duplicate MD5s in that calculated field.
That actually might also be a good way too!
Thank you for the clear tutorial. I'm using a database of 1000+ records over a server and the second method for finding duplicates has a delay of 3-4 seconds. Is there a faster way?
Unfortunately there is no simple solution to this if you don't have extensive experience in database optimisation.
Finding duplicate is by nature a CPU heavy operation, as every record in your database needs to match up against other record to check for duplicate. When you have 1000 records, the calculation needs to be done 1000 x 1000 = 1,000,000 times. Doing this via server is going to be slow.
But what happens when there are 2 homonyms to register?
Hi ... it is possible to provide a tutorial on this ... when a new record is opened for a person. Its color will change
I've got another tutorial about similar topic called "conditional formatting"
@@FMBeginner Thank you....
Thank you
Hello I want tutorial about sending sms to my clients automatically. The free way plz
Your title is "remove", not prevent. Waste of time, wrong title.