CalMaverick

Thanks, this has me going in the right direction. Can you tell me what is wrong with this calculation? [ confirmedby::Event date ">=" (confirmedby::todays date) ] this is really where I struggle. Understanding how the calculation language works. Any suggestions on where I can learn this lingo? I appreciate the help!

Thanks for the fast reply! I'm using four different fields. Fields are: DJ Status Video Status Photo Status Dance Floor Status The report layout is based off of all the call log info. In the end I am trying to click a button that runs this script the will find "confirmed" in any one of the four fields about. The show only the records from todays date forward. Then go to my report layout that will show all found records in order by date. Does this help? Thanks again!

I am on FM7 and trying to run a script that will find all records that show "confirmed" on any of 4 different services I offer. Then I want it to only show records from todays date going forward. Right now I have the script Perform Find Sort by date Go To Layout (where I have a report) Can anyone tell me the script to constrain my find and show only confirmed events from todays date forward. I think this should be simple. Any help would be a huge help. THANKS FM FORUMS!

I did that and found this post. Does anyone else have some specific instructions that I can follow? Thank you for your time!

I need help to create list based off of a selection in a field. For instance. If an employee selects that a client is "confirmed by phone" I want it to populate that record in a list on another page layout that I create. Or if an employee selects "confirmed by email" it should populate another list. I have a few other selections to, but that is the idea. Thank you!!!

I am looking for someone who can integrate a calendar with my FMP. I need to show on the calendar booked events and set meetings. I'd also love reminder emails sent to the staff assigned to each booked event. Can anyone out there handle this quick job? what would it cost me? email me at apiaaron@gmail.com

I'm resposting this because I'm told this is a "filtered portal" question. I'm trying to figure out how I can populate a list of all client names when "status" field reads "Confirmed by Phone" or "Confirmed by e-mail". I have over 2000 records. I offer a service for weddings. When a client calls or emails me to tell me they want to book I change their record "status" to "Confirmed by phone" or "Confirmed by e-mail". Sometimes people can be flakey and I need a reminder to call them about getting contracts and deposit's in. I would like to have a field that will poplutate a list of names from peoples records that read "Confirmed by phone" or "Confirmed by e-mail" and then when I get the contract and deposit I change the status to just "Confirmed" and their name no longer shows in the list. I would love to have any assistance I can. I've learned a lot about FMP but have not dealt with this just yet! Any help would be great! Thanks all! Aaron

I'm trying to figure out how I can populate a list of all client names when status field reads "Confirmed by Phone" or "Confirmed by e-mail". I need to be able to follow a lead that is supposed to be sending a contract for service. Sometimes I will lose track once they say "confirm". Any help would be great! Thanks all! Aaron

WOW! Very nice! You just made the first 6 months of this year!!! THANK YOU SIR!

I am trying to simplify by automating this task. I have a field that says "staff name". I also have a field that says "staff email". I did a script that will insert a email if "staff name" is selected, but I have to somehow make the script execute. Can someone tell me how to make it auto execute the script when I select "staff name"? -OR- Give me a better solution to make this happen? Thanks everyone! Love this forum!

Can anyone else chime in with some advice? Rob helped me a lot but I haven't heard back from him. I have it to the point where my database will find all confirmed files but I can not get it to omit files that are past today date. I've tried to put into the script and option to omit, but it does not execute the omit. Any help would be great! Aaron

Hey Rob, that worked perfect, but I can't combine them to work together. Can they be done together so they find all confirmed services and then omit the ones that are past this date? Thanks for the help. I'm learning some good tricks for FMP thanks to you! Aaron

Thanks, that was perfect for finding future records. Can you or anyone tell me how to keep only the records that say "Confirmed" on any of the four services we offer? It didn't seem to let me find only the "Confirmed" Aaron

Hi all I am trying to create a script that will find records that show "confirmed" on any of the services we provide and then omit records that are past todays current date. From there it will go to another layout and list all up and coming "confirmed" events. I am having trouble omitting records that are past due. Right now in my script I select to omit multiple records and then specify a calculation where I thought it would just be this "${1-4-2005NEW}:Event date ≤ ${1-4-2005NEW}::todays date" Thats not working. Any help would be great!

I have started a layout of family contacts. Does anyone know if there is a premade template out there that I can use for a family tree? I'd like to keep it all in FMP. Thanks! apiaaron@gmail.com

Does anyone know if using "pause" script will work for runing a script that follows through multiple different emails. I'm trying to automate my email follow ups with clients that contact me for a service quote. Example... 1.Create initial record 2.Start script for 2 day follow up 3.have an option to stop this process 4.if script is not stopped then send a 5 day email 5.have an option to stop this process 6.if script is not stopped then send next follow up e-mail. I'm sure this can be done. Can anyone confirm this? Any idea's how to set this up? Thanks! apiaaron@gmail.com

Does anyone know if using "pause" script will work for runing a script that follows through multiple different emails. I'm trying to automate my email follow ups with clients that contact me for a service quote. Example... 1.Create initial record 2.Start script for 2 day follow up 3.have an option to stop this process 4.if script is not stopped then send a 5 day email 5.have an option to stop this process 6.if script is not stopped then send next follow up e-mail. I'm sure this can be done. Can anyone confirm this? Any idea's how to set this up? Thanks! apiaaron@gmail.com

Does anyone know if using "pause" script will work for runing a script that follows through multiple different emails. I'm trying to automate my email follow ups with clients that contact me for a service quote. Example... 1.Create initial record 2.Start script for 2 day follow up 3.have an option to stop this process 4.if script is not stopped then send a 5 day email 5.have an option to stop this process 6.if script is not stopped then send next follow up e-mail. I'm sure this can be done. Can anyone confirm this? Any idea's how to set this up? Thanks! apiaaron@gmail.com

Wow, funny that I missed something so obvious! Thanks!

Wow, funny that I missed something so obvious! Thanks!

Wow, funny that I missed something so obvious! Thanks!

Does anyone know how to end an email script that loops? I want it to stop on the last record. Right now it keeps generating emails... Thanks everyone! Great forum! Great program! apiaaron@gmail.com

Does anyone know how to end an email script that loops? I want it to stop on the last record. Right now it keeps generating emails... Thanks everyone! Great forum! Great program! apiaaron@gmail.com

Does anyone know how to end an email script that loops? I want it to stop on the last record. Right now it keeps generating emails... Thanks everyone! Great forum! Great program! apiaaron@gmail.com