Jump to content
  • Welcome To FMForums

    Welcome to our community, full of great ideas on developing your FileMaker solutions effectively, or for peer-to-peer support of the FileMaker Platform and related products and services. Please register if you'd like to take part.

All Activity

This stream auto-updates     

  1. Yesterday
  2. beverly

    Cannot get a simple SUM

    ID is a reserved word. Try escape quoting the "name": WHERE Daily_Totals_From_Date = ? ( AND \"ID\" = ? )
  3. filemakerdeveloper40

    Cannot get a simple SUM

    I feel like the answer is right in front of me, but I can't seem to nail it. I keep getting a syntax error. Here is my calc (testing in the data view for now): Let ([ theDate = Totals_Daily::Daily_Totals_From_Date ; ID = Totals_Daily::ID ; query = "SELECT SUM (Daily_Qty) FROM Totals_Daily WHERE Daily_Totals_From_Date=? AND ID=? GROUP BY Daily_Totals_From_Date,ID" ]; ExecuteSQL ( query ; "" ; "" ; theDate ; ID ) ) If I remove the second parameter (ID) and simply sum by the date, I get a result. As soon as I add the "AND ID=?" I get a syntax error.
  4. Thank you so much for helping me, bcooney! When I right click the 'insert PDF' is greyed out. 'Insert Photo' and 'Insert File' are black and usable. I did find the PDF file and inserted it but all I get is an icon and the name.
  5. Ah, okay. I understand and that was what I was looking for. Thanks! From your first comment are you suggesting that it's not necessarily a problem to have empty records within the value table?
  6. The "Assets" starter file has a nice big container to use for testing. I changed its settings to Interactive: then right-clicked to Insert PDF. Can you do the same and test on your workstation? Perhaps this discussion is relevant to your setup? https://community.filemaker.com/message/779329?commentID=779329#comment-779329
  7. If it is important to not have empty records in the values table, then you should attack this on two fronts: In terms of data integrity, you should validate the field as not empty so that the user will be forced to either enter a value or delete the record; In terms of user interface, you can make the user experience smoother by either showing a custom dialog presenting the choices, or just have a script trigger automatically delete the underlying record upon detecting that the field is empty - without requiring any action from the user.
  8. Hi Comment, just another follow up question here. I've implemented the design you said without issue and it works perfectly, thanks so much. How would you suggest setting things up so that you could easily delete a value that was entered? I was just going to put a button on the portal that triggers a script to go and delete that specific answer record, but thought perhaps you'd have a better way of doing this. Thanks again for the help!
  9. I am using Filemaker Pro 17. I have created a container field with 'interactive content (PDF, MP3, etc.)' checked in the Data tab in the Inspector. PDF's won't upload. I've uninstalled and reinstalled Adobe Reader DC. I've tried other PDF files and they just won't load. What am I doing wrong? (I've done is successfully in the past with Filemaker 15 with the exact same PDF files). I'm using a MacBook Pro with MacOS Mojave Version 10.14.2 (18C54).
  10. OlgerDiekstra

    Error reporting for SMTP Email

    With standard FM script steps, you only get error 1501-1507 returned. These errors relate to the communication with the SMTP server you're sending through. If the user mailbox exists on the SMTP server you'll get a 1501 error (authentication failed). But why do you need user authentication details? You can simply send an email with the from email address of whichever user and authenticate to the server using a different email address.
  11. wattmhite

    Error reporting for SMTP Email

    I have several users and passwords set up for sending automated SMTP emails but I am concerned of script failure if a user happens to change his or her password. Therefore, I am building a daily script for the management team that tests each SMTP email and password and reports errors before the script is performed later in the day. Any advice on how to collect and test/report SMTP send errors? Thank you
  12. Last week
  13. Jesse Barnum

    Modified Timestamp Changing

    Try removing the zz_account_create field from the sync layout (be sure to run through the configuration and re-copy script steps after doing this), then see if the problem persists. I don't know what caused those 248 records to be modified in the first place. You can take a look at the MirrorSync audit log records (in the 360Works/applications/logs directory) to see when those records were first written by MirrorSync.
  14. Thank you! I found them and I'm in the process of downloading them now.
  15. KarlW

    Installation error

    Hi Ryan - still having problems, this time with the configuration. My dev files are currently stored locally which means I need to copy and paste scripts into the file(s) to be uploaded. My problem is that when I press the Copy Script Folder button, despite a dialog confirming that the script folder has been placed on the clipboard, the clipboard is empty, so I can't paste into the database. Any idea what I might be doing wrong? Thanks Karl.
  16. FileMaker Magazine

    Advanced JSON Script Parameters

    While many FileMaker solutions will manage multiple parameter passing in very simple and straight-forward ways, there are some solutions which you know will grow over time. Because of this expected growth, you may want to have an additional level of comfort knowing you've implemented a very strict system for managing data transfer between scripts. You also may be interested in working with external APIs and connecting to systems and data which is provided via the currently popular format of JSON (JavaScript Object Notation). Since the release of FileMaker 16, we've had access to the fundamental JSON* functions. With their initial release, there were a number of developers who immediately jumped on the bandwagon. Since FileMaker 16 was released, we've had a good bit of time to codify some methods and helpful custom functions for working with JSON formatted data. This video is all about providing comprehensive initial coverage about how JSON can be used for passing multiple parameters within FileMaker. If you never quite taken the plunge into using JSON for parameter passing then this video and the associated file may very well provide you with the incentive to take a more serious look. At the very least, you'll know what's going on when other developers mention they're using JSON parameters! Click the title or link to this article to view the video. View the full article
  17. FileMaker Magazine

    Advanced JSON Script Parameters

    While many FileMaker solutions will manage multiple parameter passing in very simple and straight-forward ways, there are some solutions which you know will grow over time. Because of this expected growth, you may want to have an additional level of comfort knowing you've implemented a very strict system for managing data transfer between scripts. You also may be interested in working with external APIs and connecting to systems and data which is provided via the currently popular format of JSON (JavaScript Object Notation). Since the release of FileMaker 16, we've had access to the fundamental JSON* functions. With their initial release, there were a number of developers who immediately jumped on the bandwagon. Since FileMaker 16 was released, we've had a good bit of time to codify some methods and helpful custom functions for working with JSON formatted data. This video is all about providing comprehensive initial coverage about how JSON can be used for passing multiple parameters within FileMaker. If you never quite taken the plunge into using JSON for parameter passing then this video and the associated file may very well provide you with the incentive to take a more serious look. At the very least, you'll know what's going on when other developers mention they're using JSON parameters! Click the title or link to this article to view the video. View the full article
  18. Thanks, I was SURE I had tried that but I must have been mistaken because it works perfectly.
  19. Try = If ( Get (ScriptParameter) = "Digital" ; "LINE_ITEMS_Digital" ; "SomeOtherLayout" ) Note that this will break if you rename your layouts.
  20. I have a table called MEDIA_SCHEDULE which displays related records from LINE_ITEMS via a portal. I have a script to create a new LINE_ITEM from the MEDIA_SCHEDULE. It takes the CATEGORY (Digital, Television, Press etc.) as a script parameter to set the category of the LINE_ITEM created. The LINE_ITEM is displayed in a new window. I would like the script to choose the layout of this window via calculation so that if the new LINE_ITEM::Category is digital it is displayed using the "LINE_ITEMS_Digital" layout. I know I could have a script trigger to change layout as soon as the category is set but I thought it would be more elegant to have it done within the New Window script step. I just can't figure out how to form the calculation.
  21. Kaiviti57

    Modified Timestamp Changing

    Hi Jesse, This file is set to most recent change wins. I do not want to leave this user user decides because that would cause huge problems. The records in this table are very rarely changed. In fact, in the past three years I am the only one that has changed anything and it was to maybe three records only. The modification timestamp on nearly all the records should be the same as the creation timestamp. The other thing I can't figure out is if 248 records were modified, why weren't the rest? The 248 records that were modified was done over a 3min 48 second period and this was done during the sync which took 15 minutes to perform. All the 248 records contain jpegs and this slowed the sync down dramatically. I never changed anything in these records and it was all done in the period that the sync was being performed. It is impossible to make changes to 248 in less than 4 minutes - except via a script. These are the auto create fields that I have on each sync table relating to creation and modification. The mod time stamp is the only field that updates when a record is modified. This is most baffling. Hi Jesse, I have attached my configuration file if it helps. PIMS v5 MirrorSync Configuration.txt
  22. I have encountered this situation in two separate instances. 1) In the last company i worked for. I updated them to Filemaker Server 16 2) With a current client of mine which i set them up on Filemaker Server 17 My dilema is the following: I designed two completely different databases, one in each scenario and both have had the same issue. As i am designing the database (locally), i am able to upload pdf files and view/interact with them perfectly. However, as soon as i upload it to the server, i loose the ability to view/interact with pdfs anytime i connect via Filemaker Pro from a mac computer. The rest of the database works perfectly fine, scripts, layouts, fields etc. It works perfectly fine if i connect via Webdirect, Filemaker Go and Filemaker Pro (Windows Only); In any of the previous scenarios i am able to view/interact with pdf content. The only connection that gives me issues is via Filemaker Pro from a mac. In my last company i pitched the idea of building a national expense management database and upgrading to the latest FM version (16 at the time). I was successful in building and implementing this system, however this pdf issue persisted and i exhausted all methods of testing (known to me), i even worked with a Filemaker Engineer (because we had support) for about 3 months and he could not replicate the issue and eventually i just gave up thinking that it was most likely a local problem. But now that i am working as a consultant, i am seeing the exact same issue with my current client and its completely unacceptable! Honestly after working on this issue for so long, the only thing i can think that might have something to do with it is the SSL certificate/Secure connection back to the server. I know that since Filemaker 15 and up, port 443 has been used to insert data into container fields. There is a mismatch in the SSL certificate for some reason (still troubleshooting), but if that was really the case, then wouldnt there be an issue with Go, webdirect and not to mention FM Pro in windows as well? I am very sorry if i wrote too much, this is my first ever post in a filemaker forum. Please help me because this has been truly inconvenient and a major hindrance to any type of system i build. Images are attached (test database, which only has 1 container field to isolate issue). Please let me know if there is anything else you might need to know to clarify things more. Thank You.
  23. I am trying to use the following but I am getting the attached error: GetURLasContainer( "https://generator.barcodetools.com/barcode.png?gen=1&data=A31254&bcolor=FFFFFF&fcolor=000000&qsize=1&xdim=1&w=&h=&fmt=0&mode=0&angle=0&quiet=1&alignh=1&alignv=1" )
  24. yes there are many ways to export the contents of SC. loop and export contents to a new folder structure go to the server and copy the SC folder that will have the all the contents. export the linking information and the url path as excel developer should be able to match files to data.
  25. We are needing to move our uploaded files out of SC, along with their linking information. Is this possible either through the FMP interface or using an alternate method? We have a developer on staff that is creating an application that will custom fit our needs. Thank you Al
  26. Jesse Barnum

    Modified Timestamp Changing

    Those fields should be removed from the sync layout. FileMaker does not allow us to set the modification date, modification account name, or modification username - if we try to set those values (either by script or by xDBC), FM will ignore what we set, and just set the current date / account name / username. You can observe this yourself by trying to manually set them to something else - it's impossible to do, short of temporarily disabling auto-entry options, or doing an import with auto-entry options disabled. Having established that it does no good to include those on the sync layout, let's talk about the downside of including them - the problem is that it causes field-level conflict merging to fail. Without those fields on the layout, if you change the first name of a contact record, while I change the last name of the same record, and we both sync, then MS is smart enough to see that it should merge your first name change and my last name change. However, if there is a modification username field that it's also trying to sync, it's always going to look like you and I both changed that same field on the same record - preventing MS from being able to merge those changes, and forcing it to treat it like a full-blown conflict, which must be resolved according to the conflict resolution setting for that configuration. Therefore, since it does no good to include them on the sync layout, and it prevents MS from being able to do field-level conflict merging, I highly recommend removing them from the layout. Note that it's fine to keep those fields in the table - just not on the sync layout. That way, MS won't know about them and will not attempt to write anything to them, but FileMaker will still keep them up to date.
  1. Load more activity
×

Important Information

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