this guy is amazing! being from Hong Kong, he efficiently uses his English to explain those complicated concepts of FM science. Thanks for keeping things simple!
Hi! Great material. I decided on this “stay at home” mandatory fashion to learn something new and exciting for my business. First course and great results for my brand new ticketing system. Will be following you. By the way, I visited HK many times and have many friends there, great people, educated-as you- and committed to success. Congrats.
Hi, Sunny. Thank you for your video tutorial. I'm new in Filemaker and wondering how to use it. But then I watched your video and it gave me so many knowledge to use it. Thank you
Which FMP version would work best with Mac OS 10.15.6? This operating system requires 64 bit apps. My current FMP 10 is a 32 bit app. And will not work on the upgraded computer.
Appreciate having shared your experience/knowledge to inform. Found helpful to refresh and absorb aspects of relevant routines applied to a database in development.
First of all, I wanna say thank you for this great job. It saved so much time of learning! Then I need help, I stuck on step when you add in medical record new record , it doesn’t appear automatically in patient layout… what can be the reason?
Hi, very useful video. I do understand the need for ID when the names in this case might be the same. But in the case where we know all our records will be unique, do we still need to add this ID column? I am working on uploading biodiversity data and for example I want to do a relation between survey result table and species. I do not think I need to have an ID column as the species table, all entry are unique. Is that correct or is there another reason for the ID column that could still be useful in our case?
Normally in a NEW flat database, you just make all of the fields. In the this example, do you: 1. Make all the fields first and then select which ones go into each table? OR 2. Make the two tables and populate each separately with their unique fields?
Dear Sunny. Great tutorial. I used it to make my own portal for new visits during the antenatal control of a patient. But, is there a way to update the gestational age of the pregnancy in every consecutive visit when i click on the New record button? I found a formula that calculates GA in weeks and days using LastMenstrualPeriod date and CurrentDate. Currently I have to input LMP date in every record to make the calculation for each new row or visit
Dear Sunny, I used your script in my portal so I could open new records for consecutive visitsfor the same patient. It does work properly. But I need to give the patient a report for each new visit via email or printed layout. I tried several scripts that I found here and there without any success. Can you give me a hand with this? TY
Hi, I'm having some trouble with Filemaker. I have several layouts that each collect unique data, each layout is a separate part of a space ship. I have each layout connected as a relationship with the last layout which is a summary of the whole ship. I then created a field and/or a portal that would reference items from other layouts. It worked, but not well. It worked perfect 1 time. However every future open cell that could be associated to another layout were also populated with the accurate data from the same layout. So I ask... How do you import several primary keys from the same layout onto a separate layout?
Thank you for your great tutorials. Love them. I am having a problem with FM. When I create a portal everything is grayed out and I cannot select a different record from on the top. I use the free trial do you think that is the reason? Thanks for your help
Hi Sunny this is a great video, I would like to ask you and working with the same exercise, create 2 profiles, one is the admin can delete the records for patients and Second profile, that can add records but after commit button (save) this profile cannot be able to delete or modify the records, can you help me with this question? thanks a lot
I don't have a tutorial for that yet, but you should be looking at security setting in manage > security. And your direction should be to create 2 sets of priviledge set.
I find that the easiest way to make a simple relational database is to get Filemaker 5.5 which can be found cheaply on Ebay. It works with Windows 10 (but not Filemaker Server 5). The early version is much less bloated and easier to understand. I used to have fun programming, but now it's becoming a chore.
Bonjour Sunny, Tes tuto sont super. A quand un auto sur les actions extérieures comme exporter un pdf et le classer dans un dossier ? Bien cordialement, AMC
Hi Anne, I don't exactly understand your language but thanks for the "sont super"! And I think you have a question on export PDF too?? Maybe you can check out my "PDF script" tutorial and it might give you some idea.
Bonjour Sunny, Je vous remercie pour votre réponse. J’ai résolu le problème que je rencontrais dans un autre de vos tutoriels, par l’utilisation d’une variable. Vos tutoriels me permettent de : - rationaliser et de simplifier mes scripts et calculs - d’apprendre des astuces très utiles, comme la recherche dynamique, - d’apprendre l’anglais ... Prenez bien soin de vous, AMC
Hello sunny, everything worked very fine with this tutorial but I have insert a print script that will print each content from the prortal row, I can print the first record without any problem but when printing the second record then am getting this error ( " __PkTicketsId " is defined to contain unique values. You must enter a unique value ) my script: set variable [$Ticketid; Value: Tickets::__PkTicketsId] Go to Layout ["Tickets_Print_Layout " (Tickets); Animation:None] Set Field [Tickets::__PkTicketsId; $Ticketid] Print [Restore: Microsoft Print to PDF; With dialog:On] Go to Layout [original layout; Animation:None] I hope you can help.. Thanks
@@FMBeginner I have a lot of different email scripts- that are under one main theme. I would like to select the theme... then under the "fly-out" function the right email... that will open immediately
this guy is amazing! being from Hong Kong, he efficiently uses his English to explain those complicated concepts of FM science. Thanks for keeping things simple!
Finally someone who explains things simply and precisely, thank you...TOP+++++
Every time you made a tutorial I have so many ideas i know. Thank you very much I new FM user.
Hi! Great material. I decided on this “stay at home” mandatory fashion to learn something new and exciting for my business. First course and great results for my brand new ticketing system. Will be following you. By the way, I visited HK many times and have many friends there, great people, educated-as you- and committed to success. Congrats.
Thank you Heriberto! Hope you all the success too!
Hi, Sunny. Thank you for your video tutorial. I'm new in Filemaker and wondering how to use it. But then I watched your video and it gave me so many knowledge to use it. Thank you
Good job, I'm very happy by this tutorial in learning filemaker (sorry for my english)
Just had to say Thanks! very nice tutorial
Which FMP version would work best with Mac OS 10.15.6? This operating system requires 64 bit apps. My current FMP 10 is a 32 bit app. And will not work on the upgraded computer.
Appreciate having shared your experience/knowledge to inform. Found helpful to refresh and absorb aspects of relevant routines applied to a database in development.
First of all, I wanna say thank you for this great job. It saved so much time of learning!
Then I need help, I stuck on step when you add in medical record new record , it doesn’t appear automatically in patient layout… what can be the reason?
Hi, very useful video. I do understand the need for ID when the names in this case might be the same. But in the case where we know all our records will be unique, do we still need to add this ID column? I am working on uploading biodiversity data and for example I want to do a relation between survey result table and species. I do not think I need to have an ID column as the species table, all entry are unique. Is that correct or is there another reason for the ID column that could still be useful in our case?
Normally in a NEW flat database, you just make all of the fields.
In the this example, do you:
1. Make all the fields first and then select which ones go into each table?
OR
2. Make the two tables and populate each separately with their unique fields?
very nice way to add records using variables and limiting mistakes thank for this great video and explanation.
Another outstanding job! Thank you!
Dear Sunny. Great tutorial. I used it to make my own portal for new visits during the antenatal control of a patient. But, is there a way to update the gestational age of the pregnancy in every consecutive visit when i click on the New record button? I found a formula that calculates GA in weeks and days using LastMenstrualPeriod date and CurrentDate. Currently I have to input LMP date in every record to make the calculation for each new row or visit
Dear Sunny, I used your script in my portal so I could open new records for consecutive visitsfor the same patient. It does work properly. But I need to give the patient a report for each new visit via email or printed layout. I tried several scripts that I found here and there without any success. Can you give me a hand with this? TY
Nice and helpful, thanks
Great explanation, thanks! How would I create this one to many when both tables are on their own layout and not together on a single layout?
Is there a returns table for Karen?
Hi, I'm having some trouble with Filemaker. I have several layouts that each collect unique data, each layout is a separate part of a space ship. I have each layout connected as a relationship with the last layout which is a summary of the whole ship. I then created a field and/or a portal that would reference items from other layouts. It worked, but not well. It worked perfect 1 time. However every future open cell that could be associated to another layout were also populated with the accurate data from the same layout. So I ask... How do you import several primary keys from the same layout onto a separate layout?
Thank you!
Great video Sunny. I couldn't find links to download the before and after files. Can you post them please?
It's within the link in description
How to create print sub from two table?
Thank you for your great tutorials. Love them. I am having a problem with FM. When I create a portal everything is grayed out and I cannot select a different record from on the top. I use the free trial do you think that is the reason? Thanks for your help
Love his videos. I wonder if he is still uploading new content?
Excellent
Thanks Sunny for the great videos. I could not find the before and after files within the link. Please advice. Thanks
Should be in the link in a yellow box area
Can you show how to add two different portals on the same layout and have them both show all the data in the table they are pulling from.
Hi Sunny this is a great video, I would like to ask you and working with the same exercise, create 2 profiles, one is the admin can delete the records for patients and Second profile, that can add records but after commit button (save) this profile cannot be able to delete or modify the records, can you help me with this question? thanks a lot
I don't have a tutorial for that yet, but you should be looking at security setting in manage > security. And your direction should be to create 2 sets of priviledge set.
Many thanks for this excellent video!!!
Glad you like it Giberto!
Great stuff, Thanks
Very nice. Pls create more videos.
I find that the easiest way to make a simple relational database is to get Filemaker 5.5 which can be found cheaply on Ebay. It works with Windows 10 (but not Filemaker Server 5). The early version is much less bloated and easier to understand. I used to have fun programming, but now it's becoming a chore.
Super Sunny, I was very happy with invoce part.
will use it in mine database.
Hey Sunny, I still don't get it, ( see response on fmbeginner) .
Thanks sunny!
Hi, Do you have a Many to many course?
Sunny great video. thanks.
Thanks Joao, glad to see you around!
Thanks bro,
Bonjour Sunny,
Tes tuto sont super. A quand un auto sur les actions extérieures comme exporter un pdf et le classer dans un dossier ?
Bien cordialement,
AMC
Hi Anne, I don't exactly understand your language but thanks for the "sont super"! And I think you have a question on export PDF too?? Maybe you can check out my "PDF script" tutorial and it might give you some idea.
Bonjour Sunny,
Je vous remercie pour votre réponse. J’ai
résolu le problème que je rencontrais dans un autre de vos tutoriels, par l’utilisation d’une variable.
Vos tutoriels me permettent de :
- rationaliser et de simplifier mes scripts et calculs
- d’apprendre des astuces très utiles, comme la recherche dynamique,
- d’apprendre l’anglais ...
Prenez bien soin de vous,
AMC
Hello sunny, everything worked very fine with this tutorial but I have insert a print script that will print each content from the prortal row, I can print the first record without any problem but when printing the second record then am getting this error
( " __PkTicketsId " is defined to contain unique values. You must enter a unique value )
my script:
set variable [$Ticketid; Value: Tickets::__PkTicketsId]
Go to Layout ["Tickets_Print_Layout " (Tickets); Animation:None]
Set Field [Tickets::__PkTicketsId; $Ticketid]
Print [Restore: Microsoft Print to PDF; With dialog:On]
Go to Layout [original layout; Animation:None]
I hope you can help..
Thanks
I don't have a full scope of your database but my feeling is, you should be setting the ___Fk field instead of the PkTicketsld.
Hy Sunny, thanks you make a great Job! I love your Videos. But I have one question... I need a dropdown menu with flyout option.... is ist possible?
not too sure what is a "flyout option"?
@@FMBeginner www.ostraining.com/blog/webdesign/different-types-of-multi-level-menu/
@@FMBeginner please check the Link... there you will find a picture
@@FMBeginner I have a lot of different email scripts- that are under one main theme. I would like to select the theme... then under the "fly-out" function the right email... that will open immediately
How can I have this relationship with 2 Layouts instead of a portal in 1 Layout?
You will need to apply the same principle to create "foreign key" for your second table as well. (if they are also 1 to many relationship)
whats a portal , whats it for ?
Its a tool in FileMaker to help you show related record
If you are ever in London I need to buy you a drink
orange?
Nice and helpful, thanks