RT

Problem is fixed, post above edited to hopefully make more sense. Thanks

Wim. i have not had an email for 24hrs now. hopefully it is fixed i had the client machine to Sleep after 15 mins which is very close to filemaker server disconnect Idle file command of 10mins. i also disabled wake for network access will see how it goes over the next 24hrs

The server machine is always on and never sleeps. The problem is with one of the Clients machine. we have all left our desks and i just got an email from the problem machine but not the others. strange

i have FMS 14 with 4 clients on FMpro i only get this email from one mac sometimes every 5 minutes. Any advice on what to change - screensaver/sleep/power wake for network activity etc.. the server is set up to disconnect after 10 minutes but why the emails from one workstation even if it is in the early morning when no one is at the office. thanks RT FileMaker Server 14.0.4 on xxx-MacServer.local reported the following event:2016-06-17 09:15:42.359 -0700 Warning 30 xxx-MacServer.local Client "xxx (user) [10.0.1.69]" no longer responding; connection closed. (51)

thanks for the answer, i have just started using FMserver and trying to get some PDF reports done in the back ground and as FMserver does not do PDF natively i will try to write an applescript to fire an ical event on the first of the month.

i am trying to write a script which fires on the first of the month. but it always fires no matter what the date. trigger birthdays send If [ Date ( Month ( Get (CurrentDate) ) -0 ; 1 ; Year ( Get (CurrentDate) ) ) ] Perform Script [ “Birthdays report this month” ] Else Exit Script [ ] End If

try this. email timestamp.fmp12.zip

Sure just use the set field step your field and auto enter a time stamp after the email is sent in your script

thanks all done

Hello i have used the piece of code in my solution the field i am using is a date field for the list. i get back 2/1/2016 2/2/2016 2/7/2016 etc would like to get back 1 2 7 how would i edit the calculation to get the sample above thank you

have you port forwarded the routers port. http://help.filemaker.com/app/answers/detail/a_id/9770/~/port-forwarding-information

create a calculation field remember to back up first. Let([adj =Substitute ( YourImportedTextField ; "/" ; ¶ ) ;month = GetValue ( adj ; 2 ) ;day = GetValue ( adj ; 3 ) ;year = GetValue ( adj ; 1 )];Date ( month ; day ; year ))

Thank you so much for your time, i have updated my master file all working great you have saved me a lot of eye ache looking through many line items to see who worked.also learnt a bit aswell

Fitch thanks for the link, the solution looks simple but trying to make this work in my solution has been a no go for me i just cannot get it to work something that looks so simple has got me feeling so frustrated.

Hi everyone. So 9 years ago i started using filemaker. i started by using the attached file as a base as i knew nothing. Over time i have changed it quite a bit but still have a problem i need fixing. 1. On the jobs layout i would like it to show how many times an employee has worked on that job (In the portal). i have managed to sum up how may time entries (total) and how many employees (total) that worked. i have tried calculations and summary but still cannot get it right. thanks Rob. Job Time Tracker FM Forums.fmp12 2.zip

Fixed the problem should have been. i think. ITEM ID MATCH FIELD $$CURRENT_Product_ID = PRODUCTID in the products table

Hello been battling this one for a while. i have the standard starter invoice solution and have copied the stock transactions table from the "inventory solution" so i can get the stock number to decrease when i create an invoice. this did work. see product details layout for the portal. the problem is that i have to create a dummy invoice add the product then i can update the product stock in the portal. otherwise i get This operation cannot be performed because one or more required related records are not available and cannot be created. i have a problem with the relationship i am guessing the only way i can update the value in the portal is if i add every product (500 products) to a dummy invoice. please help with the file or recommend a better way of achieving the result of tracking the product stock as always thanks RT Invoices.fmp12.zip

you need to export the pdf to a temp folder then auto open it. Â Â

That is correct if i look at the main customer layout i can see the name and number for quick reference, if i switch to the iPhone layout i see the same info but with an added bonus of touching the button to call the leader. the relationship has always been between customer and employee but the info was not available until i created a new TO very clever.

Everything working great thank you for helping me. It still amazes me how you pros understand the problem from my brief question and give me an answer i can understand. Thanks Again.

thanks for your time i will have some sleep and get back to you all tomorrow with a fresh brain cell

here is more of a insight. i have customers layout on this layout i have a drop down from employees table which shows Active employees and there phone numbers. this gets stored in a field Calculation - Team Leader- always evaluate storage is ALL this shows up on the iPhone layout. (not a drop down) what i need it to do is to call the number on the iPhone when i press the button so i am looking to drop the name part and just dial the last part of the calculation "the phone number" the button set up at the moment for all my phone fields is currently. Dial Phone Filter ( EMP__Employee.tog::Employee_phone_cell ; "1234567890,+" ) or Dial Phone Filter ( CUS__Customer.tog::Customer_phoneDirect ; "1234567890,+" ) Thanks

Hi everyone. i have a calculation that gives me the employee name and phone number. Name_displayFull.c & "-" & Employee_phone_cell i am putting this calculation on an iPhone layout what i want to happen is when the user clicks on the calculation it calls the employee. here is the script which works for the other phone fields but not on this calculation field Dial Phone Filter ( EMP__Employee.tog::Employee_phone_cell ; "1234567890,+" ) anyone know how to get just the phone number from the calculation field. Thanks

File /manage/ security then go to extended privileges and change the keyword fmreauthenticate61 to what ever time you need i have 61 minutes. I log in on my phone or iPad and do not need to login again for 61 minutes i think the max is around 10000 minutes

thank you so much it worked and saved me lots of time and key presses