Very well done. You really seem to know how to present complex stuff in a way that it is fun to follow and learn. Keep'em coming. I do have a lot to learn and uncountable problems with FM to be addressed.
Hi Sunny, great tutorial! Learned lots from you past few months. Quick question, is there a way to create a quick search range by "last week", "last month" or even "last year"? For example, today is Monday, I want to be able to click on a button "Last Week Report" and it will automatic shows the result from last Monday to last Friday.
It's possible, the idea is to find a way to calculate the start and end date of "last week" (or last month). There are a number of date function like Year() Month() Day() Weekday() that I recommend to check out that will help you do that.
Hi Sunny, is there a way to filter a portal by date or date range? I've been trying to use a let function in the portal filter but it's not working. Thanks. Nick
Please make a tutorial for developing an app from start to end, using these videos but all for the same app, sell it on the web and I will buy it. Great explanations, visuals and down to earth approach. Udemy sell a course for $90+ and not as good as yours. Sell yours on your own site and make good money for a well presented product. Thanks for all the work...
I've got an FM database where I need to make a script to find all records that have a date between the current date and 30 days time. For example, today is 01/04/2020 and in 30 days it will be 01/05/2020 so I need to find all records that have dates in a date field between those dates (eg, records that dates like 09/04/2020 and 20/04/2020 etc....). I can set it so it can find records that are in 30 days time only (01/05/2020), but I'm stuck how to set it to find all records within the next 30 days. This needs to be an ongoing script and not just used for the 30 days between 01/04/2020 and 01/05/2020. Please can you help?
Hi Keith, If you know how to use a loop, maybe this can give you some inspiration of a potential way to do it: Date ( $month + $count ; 1; $year)... with the $count being the incrementing value
Well its not that difficult. You can just click into the container field, and in the inspector's appearance tab. set the corner radius to a really high number, and it will become circle.
@@FMBeginner thanks, I have another question on how to automatically set a date. in inspection report we put inspection date its easy to set automatically but I tried to get the next inspection date, knowing that next inspection date depending on another criteria is specification, if spec- is NDV or BS12079 the next inspection date after 12 months, otherwise its 6 months so please help me to do it, your advice will be appreciated.
I like all your tutorials, the way you explain things makes things simple, well done Sunny! I have one query here on date range search, I tried and work perfect but you know I just need to combine this date range search with other fields on find mode, lets say I have a gender filed (male or female), and I need to filter males who they were registered on some date range, do you think it is possible?
Yeah,I see it.great work. But I am busy with work and short of time. I am still followed you're emails and tutorials and try stap by stap my database. I still keep current track off it in excel. So I will put my question in the FM beginner group.
Well you will need to setup a search button to find both birthday and anniversary that matches "today". The script is very similar to this tutorial you are viewing, just switch the date range variable to exactly today Get(CurrentDate).
At first, I couldn't get the first variable to accept the start and finish globals. So I removed the global setting, got the start and end variables to accept start and accept finish, then tricked fm by returning start field and end field to global. Strange!
Maybe your reply solved the mystery. I think, in fact, I had put a date in the "to" box before trying to choose that box in the form for creation of the variable.
You know the product and you are the best explaining it.... Than you
Your way of explaining is simply wonderful. Would be expecting more from you on a regular basis.
Very well done. You really seem to know how to present complex stuff in a way that it is fun to follow and learn. Keep'em coming. I do have a lot to learn and uncountable problems with FM to be addressed.
Cheers Sunny, With a few tweaks to run on multiple views on a date range and export to excel this was just what I needed..
I'm a beginner in this field and this helps me a lot, thanks
I know this video tutorial is old but I've been struggling for a few days now to do just this. It's so clear that it's impossible to get it wrong.
Thanx for sharing. Greetings from Costa Rica
Great Explanation for Date scripting.
Great tutorial. Can you show if the find criteria don't match how to pop up a warning message to say (There is no record found for those dates)👍👍👍
Date Range Script is a good presentation of many FM operations: variables, scripting, etc.
Hi Sunny, great tutorial! Learned lots from you past few months. Quick question, is there a way to create a quick search range by "last week", "last month" or even "last year"? For example, today is Monday, I want to be able to click on a button "Last Week Report" and it will automatic shows the result from last Monday to last Friday.
It's possible, the idea is to find a way to calculate the start and end date of "last week" (or last month). There are a number of date function like Year() Month() Day() Weekday() that I recommend to check out that will help you do that.
Another great tutorial. Thank you...Keep them coming.
Thanks Dendis!
Very good tutorial. Keep them coming :)
Thanks Parthiban!
Hi Sunny, is there a way to filter a portal by date or date range? I've been trying to use a let function in the portal filter but it's not working. Thanks. Nick
Yes you will need to set a filter calculation to be of 2 criterias, bigger than start date and smaller than end date.
Please make a tutorial for developing an app from start to end, using these videos but all for the same app, sell it on the web and I will buy it. Great explanations, visuals and down to earth approach. Udemy sell a course for $90+ and not as good as yours. Sell yours on your own site and make good money for a well presented product. Thanks for all the work...
Ho Is it possibile to have after find, a resulti with for example 20 record at a time and a button “next page” for next 20 records?
Yes
@@FMBeginner how is it possible?
I've got an FM database where I need to make a script to find all records that have a date between the current date and 30 days time. For example, today is 01/04/2020 and in 30 days it will be 01/05/2020 so I need to find all records that have dates in a date field between those dates (eg, records that dates like 09/04/2020 and 20/04/2020 etc....). I can set it so it can find records that are in 30 days time only (01/05/2020), but I'm stuck how to set it to find all records within the next 30 days. This needs to be an ongoing script and not just used for the 30 days between 01/04/2020 and 01/05/2020. Please can you help?
Hi Keith, If you know how to use a loop, maybe this can give you some inspiration of a potential way to do it: Date ( $month + $count ; 1; $year)... with the $count being the incrementing value
Thank you for your tutorial.
May i ask you to do a short tutorial how to insert a photo into a circular shape instead of a rectangle please.
Well its not that difficult. You can just click into the container field, and in the inspector's appearance tab. set the corner radius to a really high number, and it will become circle.
@@FMBeginner thank you so much
many thanks bro,
I have little question on how to change the date for (DD/MM/YYYY)
IN FILE MAKER PRO 9
Not sure for FM9, but for the later versions. You can try to change your computer system setting
@@FMBeginner thanks, I have another question on how to automatically set a date.
in inspection report we put inspection date its easy to set automatically but I tried to get the next inspection date, knowing that next inspection date depending on another criteria is specification, if spec- is NDV or BS12079 the next inspection date after 12 months, otherwise its 6 months so please help me to do it, your advice will be appreciated.
sir what if ( - time)
when i type -2 its 2 days not 2 hours
is their a code get(current time)
I like all your tutorials, the way you explain things makes things simple, well done Sunny!
I have one query here on date range search, I tried and work perfect but you know I just need to combine this date range search with other fields on find mode, lets say I have a gender filed (male or female), and I need to filter males who they were registered on some date range, do you think it is possible?
Yes it is, you can use a script called "Constrain Found Set" to limit the found record even further. The mechanics is very similar to "Perform Find"
@@FMBeginner may we have one tutorial regarding this pls 🙏🏾🙏🏾
great video sunny
Thanks Wally! Btw didn't see you here or facebook lately, hows things going?
Yeah,I see it.great work.
But I am busy with work and short of time.
I am still followed you're emails and tutorials and try stap by stap my database.
I still keep current track off it in excel.
So I will put my question in the FM beginner group.
Can I ask a question?
Simply brilliant
Thanks Martial!
Interestingly,we can create a Spaced Repetition Software with the techniques shown in the video! :-P
Hi,
What if you type the FROM date range with greater than TO date, do I get error message ?
You won't get any result that way
sort > go to first > SCROLL WINDOW HOME takes list to first record
Nice tutorial , please can we download the example file, cant find it, thanks
The download file is inside the link within the yellow box
how to print A3 page in filemaker?
Hello
I have made a contact database with date of birth and anniversary field and want list for today's birthday and anniversary
Well you will need to setup a search button to find both birthday and anniversary that matches "today". The script is very similar to this tutorial you are viewing, just switch the date range variable to exactly today Get(CurrentDate).
@@FMBeginner thanks. And i will try and let you know sir.
You stopped making videos nowadays?
At first, I couldn't get the first variable to accept the start and finish globals. So I removed the global setting, got the start and end variables to accept start and accept finish, then tricked fm by returning start field and end field to global. Strange!
That's weird, maybe you put some data into it previously without knowing. Is it working now though?
Maybe your reply solved the mystery. I think, in fact, I had put a date in the "to" box before trying to choose that box in the form for creation of the variable.
Forgot to answer your question... the system is working beautifully.