Jump to content
  • Welcome To FMForums

    Welcome to our community, full of great ideas on developing your FileMaker solutions effectively,  for peer-to-peer support of the FileMaker Platform and related products and services. Register and join the conversation!

All Activity

This stream auto-updates     

  1. Today
  2. From the console it keeps showing it's not licensed but a second click show it is.
  3. Yesterday
  4. In this video, I want to talk about the top ten features that customers asked me for when trying to build out a CRM system. The number one most obvious feature is contact management. Now the important thing with contact management is that you need to track all the communications with that person, so all the phone calls and emails etcetera should be tracked. Now to make this simpler, you should be able to send e mails directly out of your CRM system. And typically this could be made even better by using some pre can templates that your team has written for specific situations that are common. For example, someone contacts you about asking for some sort of information on one of the widgets that you sell or one of the services that you provide. Well, you probably have an email that you would bring up. Ideally, you customize it a little bit to show that it's not a robot doing the work, and then you send that e mail out.
  5. I have installed Zulu 3 on my Mac FileMaker development server and I am successfully syncing the Zulu2Example database with an iCal calendar. My ultimate goal is to sync one of my databases with and Exchange-Based calendar but I am having no luck setting up the Sync. The calendar in question is already accessible to me on the Mac via an Exchange account set up in iCal, but for the life of me I cannot get it to work with the Sync Admin settings in Zulu using identical credentials. The error I get is "The request failed. Exchange Server doesn't support the requested version." FMS 17 running on Mac OS X v10.14.3, standard Zulu install. The Exchange 2010 server is running on Small Business Server 2011 and is remote from my development FileMaker server. Any clues as to what is causing this error? Thanks Robin
  6. That's useful, and a very elegant way of doing it. I confess I'd got them categorised as a bodge from pre-relational times that is best avoided. But they undoubtedly have their place. I've managed to get the layout finished with much less overhead than I was fearing - thanks mainly to the advice here.
  7. AMAZING, AMAZING, AMAZING. It worked, thank you for your help. LaRetta, thank you also. Both of you have a great day. Love this forum. 🙂
  8. Last week
  9. You should use the same formula - but the field type should be Calculation, not Container. Set the calculation result type to Container, and select 'Do not store ... ' in Storage Options.
  10. Still not sure why it is not working. I can get it to work on Windows 10. But I am trying to stay with my MAC, since I really like it. So I should not be putting the "imagemac:" & Get (DocumentsPath) & "Photos/" & Film::title & ".jpg" in the Auto enter calculation? So how do I run it? I have 715 pictures right now so I would really like to be able to get them to auto fill. I already have the database built with all the information of each film, just need the container to fill the image that is related to that particular movie. The posters are stored in a directory called "Photos" in the Documents folder. Each movie poster is titled with a .jpg extension. Thank you.
  11. If you define the field as auto-entered calculation, it will not update when you open the file on another computer. It needs to be an unstored calculation field. That's an interesting alternative. But then I think the container field must store the image name and extension?
  12. Instead of enter the path in the auto-enter calculation of the container, it needs to go in the Options > Storage (look to the bottom of that Storage tab). I think I misinterpreted your question. Sorry. And no way to delete my own post. 😱
  13. Still not getting this to work. I uploaded a small example of the database. I have the pictures in a folder called Photos and it is in the Documents folder. I cannot seem to get it to show the pictures. Thank you for looking at it. ClassicMovies_DB upload.fmp12
  14. It's also being used in the GetValue expression to pull the proper value in each loop iteration.
  15. Hi Chris, The $i variable is a counter which increases with each loop. When first entering the loop, it sets $i = $i + 1 but because it is starting, the $i will be empty so its value will be 1. Each time it loops to that point again, it will test if it is greater than the value count of the list. If yes, it will exit but if not, it will again increment by 1. It is a cool counter technique. The first two steps inside the loop (the first which sets the $i and the second which tests) can also be written as a single step: Let ( $i = $i + 1 // increment the counter ; $i > ValueCount ( theList ) // and then boolean test if the loop should exit ) In addition, if you are using a counter in multiple loops, it can be useful to clear the $i so it does not conflict with its use in the next loop. It too can be a separate step (after you exit the first loop) or written all as one within the Exit Loop[] as: Exit Loop If [ Let( $i = $i + 1 ; If ( $i > ValueCount ( theList ) ; Let ( $i = "" ; True ) ) ) ] All methods are great; use the one easiest for you. 🙂
  16. I found a turnaround using the GetThumbnail internal function to reduce the image to the correct size before using ScribeDocSubstitute ScribeDocSubstitute( "*Image*" ; GetThumbnail ( Image ; 200 ; 200 )) Hope it helps.
  17. Wow. that was so perfect. I'm not sure what the $i of the script does but I followed along and everything works perfectly. I tried to get my own iterations of a script to work for months now and you just solved it in one day. I can't thank you enough! Thank you!! Have a great weekend! Chris
  18. Roughly: Set Variable [ $eventID; Events::EventID ] Set Variable [ $personIDs; List ( Personnel::PersonID ) ] Freeze Window Go to Layout [ Attendance ] Loop Set Variable [ $i; $i + 1 ] Exit Loop If [ $i > ValueCount ( $personIDs ) ] New Record Set Field [ Attendance::EventID; $eventID ] Set Field [ Attendance::PersonID; GetValue ( $personIDs ; $i ) ] End Loop Go to Layout [ original layout ]
  19. Thank you very much Comment. The first method seems the best for me and I think I can figure out the steps to do that. One question, how do I then use that returned data in the List() function to create individual records in the attendance table? My apologies for not fully understanding your initial directions. Thanks, Chris
  20. If you have an identifier such as the fire company, you could use it to define a relationship to the Personnel table. This would enable you to get all the relevant PersonnelIDs at once using the List() function. Alternatively, you could find the relevant personnel and import them into the Attendance table, then populate the EventID using Replace Field Contents.
  21. Hello, I have a dozen fire departments that manage attendance records (related to an event) and they enter them by barcode scanning or manually selecting their name (ID) from a dropdown and clicking an Add button. I have been asked a few times for them to be able to add all members to the event attendance portal. I'm not too sure how to approach this. The members and their ID's live in the Personnel Record Table, The attendance records are created in the Attendance Table when someone is checked in. What is a good way for me to capture all the firefighters ID's in the personnel records table (or loop through the records) and then create new attendance records with all of those firefighters ID's? Should I create two open windows, one in personnel records and one in attendance, capture the firefighter ID's one by one after I perform a find of all firefighters in that fire company and then go to the attendance window and create a new record with the captured variables for that event and the firefighter ID, then go back to the personnel window and get a new personnel ID. Just wondering if there is a logical way to approach this. Thank you in advance for even looking at this. Chris
  22. Any ideas on date? This is our #1 issue currently and it’s users
  23. Nice post! Definitely the first time I truly understood how a recursive function works and is constructed. Thanks Steve
  24. Externally authenticated [Full Access] Accounts--and that is a bad idea--are not allowed to validate changes to the Security Schema. This is by design. Steven H. Blackwell Platinum Member Emeritus, FileMaker Business Alliance
  25. Our office recently replaced a database server and upgraded to FMS17 from FMS16. Now that FMS17 is being used, the Script Engine process terminates abnormally when 2 scheduled scripts using the Email plugin fire-off at the same time. Individually, the scripts run fine. However, run in tandem, they crash FMSE. Any thoughts on why the 360Works Email plugin would allow simultaneous scripts to run in FMS16 but not in FMS17? Server Version is: Plugin Version is: 3.1 Sample Event Logs: 2019-03-21 17:35:00.166 -0600 Information 148 SERVERNAME Schedule "Email Example A" running. 2019-03-21 17:35:00.166 -0600 Information 689 SERVERNAME Schedule "Email Example A" has started FileMaker script "MyScriptA". 2019-03-21 17:35:00.166 -0600 Information 148 SERVERNAME Schedule "Email Example B" running. 2019-03-21 17:35:00.166 -0600 Information 689 SERVERNAME Schedule "Email Example B" has started FileMaker script "MyScriptB". 2019-03-21 17:35:11.371 -0600 Information 645 SERVERNAME Schedule "Email Example B" scripting error (1636) at "MyFile : MyScriptB : 26 : Send Mail". 2019-03-21 17:35:12.074 -0600 Error 701 SERVERNAME FileMaker Script Engine process has terminated abnormally. 2019-03-21 17:35:12.090 -0600 Error 757 SERVERNAME Schedule "Email Example B" aborted; FileMaker scripts can't be run because FileMaker Script Engine (FMSE) process is stopped. Use the command "fmsadmin start fmse" to start the FMSE process. 2019-03-21 17:35:12.090 -0600 Information 126 SERVERNAME Schedule "Email Example B" scheduled for 03/21/2019 05:45 PM. 2019-03-21 17:35:12.090 -0600 Error 757 SERVERNAME Schedule "Email Example A" aborted; FileMaker scripts can't be run because FileMaker Script Engine (FMSE) process is stopped. Use the command "fmsadmin start fmse" to start the FMSE process. 2019-03-21 17:35:12.090 -0600 Information 126 SERVERNAME Schedule "Email Example A" scheduled for 03/22/2019 05:35 PM. 2019-03-21 17:35:14.231 -0600 Warning 30 SERVERNAME Client "Email Example A (FileMaker Script)" no longer responding; connection closed. (10) 2019-03-21 17:35:25.452 -0600 Information 703 SERVERNAME Starting FileMaker Script Engine process...
  26. A self-join of your table would be convenient, say: Reservations::Date = Reservations 2::Date AND Reservations::TimeIn ≤ Reservations 2::TimeOut AND Reservations::TimeOut ≥ Reservations 2::TimeIn AND Reservations::ReservationID ≠ Reservations 2::ReservationID If there are any related records from Reservations 2, then there's a conflict.
  27. Greets, everybody! Please refer to the attached. What I want to do is set a conditional formatting calc so that if there's an overlap of time for a reserved court (as shown in the attachment), the records within that overlap will turn red to signal the user that there's a time conflict. How do I pull this off? (I have yet to figure how to prevent that from happening in the first place, but I'm guessing I could re-engineer the needed calc so that when a new record is created, it will search for a time conflict before being recorded.) I'm guessing that the answer involves converting the date and time into a concatenated string of numbers then using the MIN and MAX calcs to see if they fall within a range; I also suspect that a self-join table (or e-SQL?) will be needed as well, but I'm just stymied on how to move forward with this thing. TIA for your help!
  1. Load more activity
  • Create New...

Important Information

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