adamworking

Does anybody have an updated version of this, for use with Yosemite and Filemaker Pro 11. Many thanks Adam

hi @eos that's brilliant, thank you. Adam

Anyone able to offer any advice on this? Many thanks Adam

Hi all I've edited a wonderful example, previously shared by @comment It basically has a list of orders which shows the date the order was made and the price (£) of the order. If you head to the "Chart" Layout, it shows the number of orders by a certain month, and the value (£) of the orders. Can somebody please how I add a total for each year, so this would show Total Revenue and Total number of orders for each year? Any help massively appreciated. Cheers Adam For some reason it won't let me upload my sample file, but you can access it here: https://www.dropbox.com/s/ywea05bmx1h5q3f/ComparisonChartSlots.fp7?dl=0 This was based on 'ComparisonChartSlots' by @comment found here: ComparisonChartSlots.fp7.zip

Also, how would you edit ChartByMonth.fp7 to show the count of how many transactions per month? Thanks

Hi How would you edit this to report by year, rather than month? Thanks Adam

Hi all I have a db setup that has a certain area for booking appointments. I want to be able to click a button that creates a new event in iCal, using the following fields in my database: Date of event Start time Finish time Client name (would become event name) Payment type (would be inserted into the notes section) Venue (venue) Is there any possible way to do this? Many thanks!

Hi Lee Thanks for your response. Is there anyway that in my table, I can create three new fields, and each field then grabs part of the date. So one part grabs the date, one the month, one the year? Alternatively, I guess I could just change the field from a date field to a text field....

Hi all I have a calculation field that includes a date field within it: & INV::EventDate & However, how can I format this in the calculation field so that it display as DD-MM-YY rather than the default american format of MM/DD/YY Many thanks for your help in advance!

Hi all Is there any easy way to add an event into iCal, via my Filemaker DB? I have fields: Eventdate Start time Finish time I would then also like to add some other fields into the notes section. Look forward to any advice... Thanks Adam

Thank you! Is there anyway to have the email attach both the PDF that the "Email INV pdf" script does, and another standard PDF with terms of order? This is a standard PDF, that won't change and will be the same for every record. Thanks Adam

This is a great example file. Is there anyway to have the email attach both the PDF that the "Email INV pdf" script does, and another standard PDF with terms of order, that will not change for each record? Thanks Adam

ok, so I've added a new field, which is a calculation, which contains lots of my fields. I've then inserted this field into the layout. However, all it displays a strange 9 digit number. However, when I click on this text box, I see my full text, with all the fields inserted correctly. Any ideas? Thanks EDIT: fixed it - it was because my calculation result was a number -)

@bcooney thank you so much for your assistance and help. This is just the sort of thing I'm looking for. However, rather than an invoice, I'm wanting to put together more of a confirmation letter. Is there anyway on a form to include both standard text and field values. For example, a paragraph may read something like: Thank you for your booking on *eventdate* at *venue*. Any advise on best way to do this? Thanks again. A

guys thanks for your help. Sorry for the questions, but I'm fairly new to developing in FM. This is what I now have: A layout which collects booking information. I then want to have a button which puts all of this into a PDF. This PDF will be formatted like a letter, then automatically attached to a new email, addressed to the email address I collect in the original layout, with a customized text on the email. How do I setup the PDF. Do I need to do a new layout? Is there a way to then do the above? Thanks Adam

When using the specify calculation to edit the message of the email, I want to do something like: If value of field "Deposit " = Yes then show: THIS Else Show this Please can somebody advise how to do this using the calculate field ? Thanks Adam

Hi all I have a really simple form which just collects info such as name, address, email address and booking details etc. I want to be able to enter a new record, and hit a button, to send a confirmation email to that record. Ideally, the email will be formatted in HTML, and will contain many of the fields captured in the form. What's the easiest way to do this? I can see I can use the sendmail function, but I believe that this is just plain text, not HTML. Many thanks for your help in advance. Adam