Jump to content


  • Posts

  • Joined

  • Last visited

Profile Information

  • Title
    technical Director Electronics
  • Industry
  • Gender
  • Location
    Manchester UK
  • Interests
    running my own business and Manchester United. Oh and Holidays

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version

Recent Profile Visitors

2,045 profile views

baweld123's Achievements


Contributor (5/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. Hi, I have a question and was wondering if its possible. I have some desktops with FM14 and some with FM16 Ive just had my yearly bill and its going to cost a bit to upgrade all to 16. I love the new card feature as it makes data entry really easy and it stops people pressing a lot of the wrong buttons. The trouble is 14 doesnt support card it just opens another layout window? So i was wondering if i could have a script on a button saying if FM14 open layout 1 else open card 1. is this possible? or am i going about this the wrong way?
  2. hello , I have a script that makes a new record on my iphone . It works well except when your making a record for the first time. it makes on "inactive" record and on "Active" record. Thos is because the status field is empty for the first record. what would i insert to check if its empty , if so new record , if not make "Inactive" Thanks
  3. Hi thanks for help, the idea is to collate all the PDFs together and this it used to do? now i only get the first two even though he has passed all seven. So say before if he only passed 5 modules all the modules saying passed would be placed on my desktop in one readable PDF. Then i created an extra script part to email this collated pdf out. Now i only get two certs the 3rd and 4th in the collated pdf even though he has passed spot which are the 1st 2nd. I also now dont get a pdf at all on my desktop. this script doesnt work full stop. both are the same script its just email has the send email part on at the end as shown. hope that clarifies my english is bad :-) what i was trying to say is there are two scripts one that pdfs onto desktop in a collated pdf (all in one) And one with an email step to the script. Both have worked for 3 years ok. Now the save as PDF one doesnt even place a pdf on my desktop and the email one only collates 3rd and 4th even though 1st and 2nd have been passed and they are earlier in the script. The email part works but i only get 2 pdfs even though he has passed 4 or 5 modules. I appreciate they do appear to overwrite the one before it but as i say it worked perfect before. So i guess what im asking is how do i write a script that will collate 5 pdfs into one pdf for one person and email it out if so desired. Thanks
  4. Hi Thanks for that, ive tried it and nothing it still only saves 2 of them not 5
  5. Hi all, i have a script that is for certificates , its simple really if the person has passed that test then a cert would be printed. I have the same script for PDF on Desktop. The email one doesnt print the spot certs even though he has passed . The PDF script doesnt even save it to desktop.This all worked before but seems to have stopped working after last update. Any ideas? Oh also minimise doesnt minimise in script anymore especially if you use CARD. as i say they did before.
  6. hi Bruce , just too let you know i think ive sorted it . Ive created an Active/Inactive field and included or omitted this in the search criteria. I looked at the script more closely after what you explained and understood more of the steps i was asking it to do. I now have a script that i can either select 7 ,30,60 day windows of only ACTIVE files . Thanks for the pointers
  7. ha ha as you can see im pretty useless at scripts. This is a make up of stuff i found by searching . I try and walk through manually what i want the script to do then try and replicate it in the script. what you are seeing here though (as i sent it quick while working ) was me trying lots of stuff . okay i have a customer layout and attached to this is service. The customer layout is the main hub for the database. I wanted to create a layout pop up that would automatically search for services that are due in 30 days time ( so that office staff could then call them and organise re-service). I want this new popup layout to Omit those that have already been re-serviced though. I only want it too show whats outstanding in that week window. This would then be a creeping barrage of jobs week by week. I also wanted to then make buttons so that you could search month and quarter for a bigger picture. My ultimate would be then to put these services into areas of the country ( but thats for later) I have fields for ServiceDate ReTestDate, CreationDate. too explain the above ( which is brilliant by the way :-)) Th set field (service::Retest Date) script part i got from another post and it seems to work in finding those dates in that week window. New record request i was guessing as i thought i needed to do a new search. Thinking about the creation timestamp your right now i see the problem with that. Multiple i was again guessing The if get found count again that was on a post. Thanks bruce for looking at it and i hope im making sense now.
  8. can you not simply do it live ? i used to do MirrorSync but my guys now use the solution straight from there phones or ipads to my server. We have FM15 server and 5 licenses. We simply log in over wifi or through tethering to there iphones and use the phones data allowance. works a treat
  9. hello Bruce , Thanks for reply. Ive enclosed what ive been playing with since . Ive tried to Omit records and if i ask it to omit last years 2016 it works . Starting to go round in circles now ;-( I much appreciate your help Screen Shot 2017-04-07 at 11.52.06.pdf
  10. hi thanks for that ive taken off restore and its still showing services that have been done. So its still picking up the older services.
  11. Hi everyone. I was wondering if you could help me . I have a database of service certificates and i wanted to create a script that would run when the admin logs in. Ive started it and it does what i want to a fashion (ive not added the admin part yet) but ive hit a problem and i cant figure out how to get around it. The problem i have is that its not taking into consideration that a new service has been done . Its picking up the old retest date not the latest one for that customer. i need to find ONLY the ones that havent been re-serviced yet. Im doing a find on the retest date 30 days before the certificate runs out so that i can organise the service to be done . Any ideas? Thanks
  12. Hello, ok that works perfect but i must have my database setup wrong as it doesnt insert customer ID it starts a blank service but fills in all the data as required . service is connected by customer id match field . the portal is in the customer layout. Hope that makes sense
  13. okay i take onboard what your saying ill give it a go. ill also rename the field correctly
  14. Hi guys you may have done this before but i cant find it so i was wondering if you can help. I wish to create a button that when pressed creates a new record in a portal . I then wanted to go to this new portal line and copy from the same field in the previous line to this new line and so on. I tried this and couldnt get it too work so i did this. I created fields in the customer layout with the names and serials of the equipment on that site. I then created the script to do a new portal row ( works fine) then copy from the customer field to the new portal row field . Basically im trying to duplicate the record . but with the new date. im probably going about this the wrong way hence my question. Please ignore the difference with the go to portal row last previous that was me experimenting . Thanks for help
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.