We have reset all users FileMaker related profile fields. Please take the opportunity to update your information,  this will provide background to members whom read your posts. Click here.

Jump to content

Mark73

Members
  • Content count

    11
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Mark73

  • Rank
    member
  1. Display screen

    Thanks Comment I had put - 8 and not - 6, I really struggle with dates on filemaker
  2. Display screen

    I tired that but couldnt workout how to find the previous week calculation field (let's call it cWeeksales) = contract date - DayOfWeek ( contract date - 1 ) + 1 Then create the script like you advised about, but what do i put to find previous week Set Field [ Installations::cWeeksales ; Get(CurrentDate) - DayOfWeek ( Get(CurrentDate) - 1 ) + 1 ] This find current week but not sure how to change this to find pervious week thanks
  3. Display screen

    need to do the same as we did for installation I was thinking of showing the total of sale last week ie:20 and then break them down by status ,new job, booked, survey booked etc) and then show the sales this week along with the status of those sales and also the product but not sure if that doable hope that make sense
  4. Display screen

    Now the install screen up and running great thanks Comment I need to work on the sales side of things this will pretty much the same sort of thing but i need to find last weeks and this weeks sales can you help me with the script to grab last weeks data Many thanks
  5. Display screen

    Managed to get it to work, for some reason just woke this morning and understood what you meant so simple don't know why I want getting it thank you for your help comment
  6. Display screen

    Really sorry Comment I just not getting it could you possibly show me an example Thanks for your time I do appreciate it
  7. Display screen

    Finally had time to get back on this little project Thanks to the help about im now able to search for 2 weeks of install not just need help with the best way to show the results on a display screen in the office I need to show how many of each product is booked for install each week and the total installs each week Many thanks
  8. Display screen

    Thanks again for you fast response I have not had time to try this but will let you know How i get on Many thanks
  9. Display screen

    I think i might have over complicated it, I have created 2 fields calculation Current week If( (Start Date= ( Get ( CurrentDate ) - DayOfWeek ( Get ( CurrentDate ) ) + 2 )) or (Start Date= ( Get ( CurrentDate ) - DayOfWeek ( Get ( CurrentDate ) ) + 3 )) or (Start Date= ( Get ( CurrentDate ) - DayOfWeek ( Get ( CurrentDate ) ) + 4 )) or (Start Date= ( Get ( CurrentDate ) - DayOfWeek ( Get ( CurrentDate ) ) + 5 )) or (Start Date= ( Get ( CurrentDate ) - DayOfWeek ( Get ( CurrentDate ) ) + 6 )) or (Start Date= ( Get ( CurrentDate ) - DayOfWeek ( Get ( CurrentDate ) ) + 7 )) or (Start Date= ( Get ( CurrentDate ) - DayOfWeek ( Get ( CurrentDate ) ) + 8 ));1;0) Next week If( (Start Date= ( Get ( CurrentDate ) - DayOfWeek ( Get ( CurrentDate ) ) + 9)) or (Start Date= ( Get ( CurrentDate ) - DayOfWeek ( Get ( CurrentDate ) ) + 10)) or (Start Date= ( Get ( CurrentDate ) - DayOfWeek ( Get ( CurrentDate ) ) + 11)) or (Start Date= ( Get ( CurrentDate ) - DayOfWeek ( Get ( CurrentDate ) ) + 12)) or (Start Date= ( Get ( CurrentDate ) - DayOfWeek ( Get ( CurrentDate ) ) + 13)) or (Start Date= ( Get ( CurrentDate ) - DayOfWeek ( Get ( CurrentDate ) ) + 14)) or (Start Date= ( Get ( CurrentDate ) - DayOfWeek ( Get ( CurrentDate ) ) + 15));1;0) but for some reason its not displaying the install found for the 2 week perieod thanks
  10. Display screen

    Thank you for responding a vertical arrangement would work perfectly fine im sure
  11. Display screen

    HI all First post here so please be gentle, I have a database for all our installation and i would like to put a display screen up that shows the install booked for each product we sell for the current week and next week I have written the script to do the correct search and this is working fine but Im having trouble getting this to display correctly in my install display layout, i have created a sub-summary to sort by product but need help with splitting the install for each week I have attached what i would like the layout to look like I hope this make sense many thanks Mark
×

Important Information

By using this site, you agree to our Guidelines.