Jump to content


Popular Content

Showing content with the highest reputation since 03/28/2019 in all areas

  1. 1 point
    Unstored calc can not be used on the child side of the relationship as a key field.
  2. 1 point
    Use a button bar with one segment and calculate the name.
  3. 1 point
    Those pre canned templates are just that. They are starter solutions. If you are trying to combine 2 of them, you will need to import all the tables, recreate the relationships, import the scripts, and create new layouts ( you can copy and paste from the other template ).
  4. 1 point
    Hi, Those links must be coming from the html email you receive from the CloudMail demo. CloudMail will automatically convert links in html to links that hit your AWS CloudMail instance before relaying traffic to the target address specified in the original html content. If you take a look at the html content section in the demo file, you'll see that the links are specified with <a> tags. You would put your normal <a></a> tags in your html, and they will be converted to "CloudMail links" during the CMQueueMessage call. I hope this answers your question.
  5. 1 point
    Your synopsis layout is based on Cabinet Library. Shouldn't you be using the 'Total Minutes for Door' field from Cabinet Library?
  6. 1 point
    Just from what I have seen from support, a lot of users just use the CloudMail.fmp12 file or they copy/paste the scripts into their own solution and then modify the field references. With that being said, we do have an EmailClient.fmp12 as an example file for the Email plugin that may be close to what you are looking for. You can probably modify that to work for CloudMail but at that point it might be easier to just start from scratch.
  7. 1 point
    Well, then it is a rather simple matter of nesting (not concatenating) the operations. The Let() function is a convenient tool to do this while retaining readability. Consider something like: Let ( [ // REMOVE FORMATS text = TextFormatRemove ( Self ) ; // REMOVE LEADING & TRAILING PUNCTUATION text = LeftWords ( text ; WordCount ( text ) ) ; // EXPAND ABBREVIATIONS text = Substitute ( text ; [ "av " ; "avenue " ] ; [ "av. " ; "avenue " ] ; [ "ave. " ; "avenue " ] ; ... [ "str. " ; "strasse " ] ) ; // CORRECT CAPITALIZATIONS text = Substitute ( text ; [ " d'a" ; " d’A" ] ; [ " d'e" ; " d’E" ] ; [ " d'h" ; " d’H" ] ; ... [ "st-" ; "St-" ] ) ; // HANDLE WHITE SPACES text = Substitute ( text ; [ ¶ ; " " ] ; [ Char (9) ; " " ] ) ; text = TrimAll ( text ; 0 ; 0 ) ; lastSpace = Position ( text ; " " ; Length ( text ) ; - 1 ) ; text = If ( lastSpace ; Replace ( text ; lastSpace ; 1 ; Char (160) ) ; text ) ] ; text ) You can do any calculation inside a script; however, I can see no advantage to scripting this.
  8. 1 point
    It depends whether you're talking about making a living freelancing or working within organization. I've worked in three organizations (a school district, a private high school, and a state college) where I was either the (or one of) the Database Administrators where we used FileMaker Pro (FMP). In all three, I created/managed an SIS (Student Information System) and many other ancillary FMP databases to support the organizations' needs. The pay's awful (because you're working civil service) but then again, you get to play with FMP all day. In a shining example, the school district I worked for purchased PowerSchool, a $30K SIS that couldn't do the job since it's primarily built for public schools, not special-education schools where practically everything is an exception to the rule. We ended up using PowerSchool to warehouse the data then used FMP (including using ODBC) exclusively to do everything we wanted (PowerSchool) to do.
  9. 1 point
    A Forward Look About FileMaker Platform Security Developers and users of the FileMaker Workplace Innovation Platform must be concerned about security of their deployed solutions. Likewise, they must have a forward-looking perspective about key issues in this arena. Security has its major purpose the preservation of Confidentiality, Integrity, Availability, and Resilience (CIAR) of their systems. Liabilities resulting from breaches can substantially affect continued business operations, continued business existence, imposition of civil or criminal sanctions, brand reputation, and customer or client confidence. I see at least ten security concerns that the FileMaker Developer Community must consider going forward for the next few years and development cycles: The Business of Security: What Is Security Supposed To Do? Zero Trust implementation for the FileMaker Platform [https://fmforums.com/blogs/entry/2047-federated-identity-management-zero-trust-and-the-filemaker-platform/] Federated Identity Management and the end of FileMaker Accounts in files Native Multi-Factor Authentication (not SMS) Further implementation of Secure by Default and Rule of Least Privileges for the FileMaker Platform Expansion of Roles-Based Construct in the FileMaker Platform SaaS Security Implementation for the FileMaker Platform Building a Culture of Security in the FileMaker Developer Community Building a Culture of Security among the FileMaker Customer Base The Coming Regulatory and Political Onslaught Against the Tech Sector So as we go through the just-started FileMaker, Inc. Fiscal Year running up to the next version release and the 2019 DevCon, we should keep these elements in mind. Steven H. Blackwell, Platinum Member Emeritus, FileMaker Business Alliance
  10. 1 point
    If you’re a dev, you are a power user. Below are 7 digital tools that are indispensable, and not necessarily for coding. I don’t know if they share any common characteristics, except that when I don’t have access to them, I grunt in frustration. Nanny / LeechBlock / WasteNoTime Distraction is a huge productivity killer. For me, it’s the #1 issue in ‘getting things done’. I’m an info junkie and I have low self control. Me, making a living at a computer, is like being a recovering alcoholic and working at a bar. Except I’m not Sam Malone. I’m not even close. Buying a box of cookies and just ‘not eating’ them doesn’t work. What does work is not buying those cookies in the first place. That’s harder to do when working in a cookies factory. I love to read about a wide range of topics…current events, personal finance, urban planning. So, I’ve got to lock myself away from Facebook, reddit, twitter, washingtonpost.com, wsj, vox, 538, slatestarcodex, Mr Money Mustache, Bogleheads…well, you get the idea. But having access to those during work hours is majorly counterproductive. The solution? Browser add ons. I use one on each of my three browsers (Chrome, Firefox, Safari). These little utilities block access to sites of my choosing during certain hours. Very configurable, they lock away the liquor until it’s after hours. JumpCut JumpCut is handy little utility keeps track of your clipboard history. It ‘buffers’ your clips, keeping a history of up to 99 items that you can access and paste. Say I want to copy and paste four separate items, pieces of code, from a website to a Data Viewer. By default, that process is: copy, navigate to the Data Viewer, paste, navigate back to the website, repeat 3 more times. With JumpCut, it’s copy, copy, copy, copy, navigate to the Data Viewer, paste, paste, paste, paste. It’s one of those things you *have* to try. I’ve configured JumpCut so cmd-shift-V brings up the clipboard popover, then arrow keys move through my history. I use this shortcut at least 10 times every hour, every single day. Boomerang Boomerang is an app that integrates with Gmail and does two very cool and very different things: schedule emails and bounce emails back. Scheduling e-mails is great. I use it in two situations. If I’m emailing at 2 in the morning and I want to reply to client, but I don’t want to look like an workaholic nutjob. I use Boomerang to actually send the e-mail at 7:30am instead, looking like an industrious, early rising professional. The other situation deals with that feeling when as you hit ‘send’ and you think ‘Oh, crud, that wasn’t right’. Gmail has a great ‘Undo’ feature. Start with that. But the max time is 30 seconds. If I’m sending an email and I’m not sure if my choices around tone or content are the best, but I need to move on, I will schedule to send it in 30 minutes, allowing me to ‘let go’ but leaving open the option of revisiting it if I realize I should have rewritten. Your smile when you use boomerang Bouncing e-mails back is super helpful. I’m a fan of Merlin Mann’s Inbox Zero. I use my inbox as a To Do list. If it’s in there, I need to deal with it. *For the record, at the moment my inbox has 12 emails, and I never let it get above 50. Some tasks, however, need to come back on my to do list. For example, I’ve got to get credentials from a client in order to work on their solution. I’ve emailed them but got an autoresponse that they’re away for 3 days. I don’t want that task sitting on my to do list, because I’m waiting on someone else. So I set the email to “Boomerang” in 4 days. The email will leave my inbox and pop up again in 4 days if I don’t already receive a response from the client. Brilliant! MonkeyBread Solutions MBS has produced the Amazonian rainforest of FileMaker plug-ins. With over 4,500 different functions, it’s an entire ecosystem, packed to the brim with medicinal plants. It’s well worth the $149 price. More awesomely, there’s two incredibly useful developer tools built into the free demo version: The ability to search scripts and the ability to search the relationship graph. Install it, you won’t know how you lived without it. LastPass or any password manager If you’re not using a password manager, you’re being unprofessional. LastPass is the one I use. I haven’t tried KeePass or OnePass or any of the others, I’m sure they’re fine. Pick one and use it. Use a super secure master password (try the Correct Battery Horse Staple method with some of your own modifications), then let your encrypted password store of choice do the rest. I’ve got about 600 entries in my LastPass account, so “the rest” covers a lot ground. I don’t use the un-encrypted EverNote, no I use LastPass. With it I: Generate random 16+ character passwords. Updated all my sites so I’m not using the same P455w0rD on each. Create random 6 letter pronounceable passwords to use as the answers to security questions. Store credit card numbers, including the CVV code. Store configuration details for FM Servers. Attach a copy of SSL files to my client’s ‘note’. Store the VIN of my car. Store the make and model of my lawnmower. Mint.com Like most of humanity, financial security is important to me. One of the cornerstones to financial understanding is creating a budget. Whether you think budgets are prescriptive or descriptive, you should see where your money is going. Mint collates all your financial data in one place and allows you to assign income and expenses to categories you define. I have been using Mint since 2007. I check it at least twice a week, sometimes more. f.lux The human brain is a complex organ. There’s growing evidence that using a screen before bed can interfere with sleep, in large part because the screen emits blue light. f.lux adjusts the color temperature of your screen based on the time of day so that at night, your screen shifts red, encouraging better sleep. Now, you shouldn’t be using a screen in bed, but if you’re using it at night, use f.lux. I recommend all of these tools without reservation. Not that they’re perfect by any means, but they are indispensable. View the full article
This leaderboard is set to Los Angeles/GMT-07:00
  • Create New...

Important Information

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