Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About jjjjp

  • Rank

Profile Information

  • Title
    university instructor and program director
  • Industry
  • Gender

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
  1. Thanks for that tip, Ocean. Scripting errors aside, is it bad coding practice to, e.g., make an action conditional on the occurrence of an error on opening a record? The term "scripting error" suggests it is.
  2. Is there a way to change my coding of scripts so that so-called scripting errors don't show up in server logs when a scheduled script is executed on FM Server? I get dozens of such errors for each daily execution, and Using a Set Error Capture [On] script step doesn't seem to make a difference as to whether the "errors" show up in the server log. The kinds of error codes that do show up (101, 401) don't seem to me to be be the result of scripting errors at all. Rather, they are part of ordinary operations (e.g., testing to see whether to stop looping by checking whether a record exists in a fo
  3. I host a database on my university computer to administer a series of group workshops for the undergraduate community in fall and early winter terms. Each morning at 7, FM Server executes a script to send out email reminders to all workshop leaders for their upcoming presentations; provide them with essential information about location; etc. We had a ransomware attack on my College's servers last winter. Fortunately, the attack happened after the workshop schedule was almost completed, but the emails stopped going out successfully after the College recovered from the attack. The error code is
  4. Thanks, this last explanation is much clearer, and I think you've given me the insight I was after. In answer to your question, I do all of the work of expanding and coding locally but the file that matters is hosted. I have created scripts to import all of the data from the hosted version after I make coding changes. In any case, I believe the source of my accidental loss of custom order was local, either as result of items 3 or 5 in your bulleted list. I have been able easily to reproduce the "accident" on a test database. Unless I'm missing a point, however, it seems to me th
  5. Sorry, but I think I need more context to understand you. Based on what you're saying, I'm trying to reproduce the act of changing the custom order to alphabetical all at once and can't do it. In your first paragraph, for instance, are you talking about editing a layout with the left pane open, or are you taking about being inside Manage Database? If one were in Manage Databases, how would one accidentally change a list of 126 fields from the custom order to alphabetical when viewing by custom order other than to do so manually?
  6. Thanks for the response, Ocean, but I'm not sure I fully understand. Where in FM is the field order setting that you refer to? I know that one can always switch how field are ordered. What I'm concerned about is whether it's possible to inadvertently change the custom order to alphabetical. One of my tables once had a logical order that was not alphabetical when I viewed the table in Manage Database by Custom Order. Now the fields do show in alphabetical order when I view it by Custom Order. I'm wondering how this might have happened accidentally. Also, I don't see how the custo
  7. I noticed that a central table in my database, which used to have its own custom order, is now ordered alphabetically. I haven't used my database in some time, so it's possible I decided to do this a while ago (I deliberately put some tables in alphabetical order). But I do not think I would have had any good reason to. The same thing—loss of custom order—appears to have happened to me once before, several years ago. Is it possible inadvertently to impose an alphabetical sort on a previously non-alphabetical order? Knowing how the custom order might have been lost could help help me to av
  8. Sorry, OceanWest not to reply till now. I somehow didn't get, or missed, a notification of the reply. I'm copying to the clipboard for this reason. My database manages academic workshops. Though there is a feature that allows users to send an announcement via email to all of the workshop leaders for the current year and a specific program (schedule), sometimes it's just easier to send an email outside of FileMaker on one's preferred mail client. I created a script that produces an Excel file with first name, last name, and email address for columns. But some mail clients, notably Mac OS's
  9. Thanks. I don't have a good feel for the distinction between data and layout. To me, they have always been enmeshed. Is there a help article that explains the difference?
  10. It wasn't, but it now is. You have solved the problem. Generally, global fields can appear in script steps regardless of whether the field appears on the current layout. The Copy step is clearly an exception. Is there a way to figure out when presence on a layout matters?
  11. In a script, I execute a loop to compute a text string consisting of a comma-separated list of email addresses, which will be used outside of FM to send an email. The string is stored in a local variable, $EmailAddressString. When the string is fully computed, I set a global field to $EmailAddressString, and then I execute the script step Copy with target set to that global field. However, the string doesn't get copied to the clipboard. Instead, the Copy command produces Error 102: Field is missing. But the global field does contain the proper text string. Is there a restriction on Copy—i
  12. Somehow the layout structure in Manage Layouts is out of sync with the structure of the menu that appears on layouts. (see attached.) How do get them back in sync? I'm wondering if this is a legacy issue. I have jumped versions of FM recently—from FM 15 Pro to 18 Advanced Pro.
  13. Thanks, both. Consultant, I can see why you're confused. I can see that I abstracted away important information for understanding the context. The global fields in question are in a table, ProgramsGlobal, whose fields exactly mirror a table of non-global fields called Programs. There are different programs in the database corresponding to different coherent sets of workshop offerings. At the beginning of a session, the user chooses a program. The fields in Programs in effect, represent key settings for a program that don't get changed frequently. Each record in Programs contains the
  14. I want to do something seemingly straightforward, but it seems very hard to accomplish. I have two global text fields that a user sets in a table TGlobal. At some point, I want the user to choose between the text values in the two fields, FieldOption1 and FieldOption2, which represent different options that a user can take at some point in the workflow. So ideally I'd like to create a value list, which can be used to present a user with the two clear choices in an elegant layout that contains a question and a radio button. So here's what I have tried to do. 1. I created a table, VLis
  15. Apologies for that misreading of the code, and thanks for the quick response. I suspect that there’s an underlying cause having to do with the recent changes to our computing infrastructure. Otherwise, why all the script errors? Also, the SMTP settings work when I send from my own computer. I’ll pursue this with my IT staff.
  • Create New...

Important Information

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