Jump to content

Leaderboard


Popular Content

Showing content with the highest reputation since 05/30/2019 in all areas

  1. 3 points
    This year 2020 will be one of Change and Challenge for the Claris FileMaker Community. It will require Commitment, Confidence, and Community Effort to see it to a successful conclusion. Herewith, in outline form, are some of the Challenges I foresee we will face: 1. We will need to develop a finer level of audit logging of Personally Identifiable Information (PII). Most logs currently focus on system level activity. A finer level of focus will assist in achieving compliance with various privacy requirements. Prompt response timelines for breaches will be an issue as well. 2. We will need to improve data level protection via encryption. The UI layer is insufficient for this purpose. But in the process of doing this, we must maintain system usability. 3. The practice of sending SMS text messages to mobile devices to achieve Two Factor Authentication (2FA) needs to end. It is inherently insecure, and there are better alternatives. 4. A better approach to 2FA is to adopt hardware tokens of various types. These can be made to work with the FileMaker Platform—indeed they already do so—using expanded oAuth Open ID Connect services. 5. We are going to need to adopt context—based authentication. Not just Who are you? and Are you who you say you are? But also, How do we know this? And from where are you seeking access, on what device, to what asset? This is not particularly easy to adopt; however, it can be done. 6. Mobile accessibility is due for a change. We are at the beginning of end of Wi-Fi. In 2020 we will begin to see adoption of what is called Citizens Broadband Radio Service (CBRS). This is not to be confused with the old CB Radio from the 1970’s. Adoption of CBRS is likely the beginning of Connectivity as a Service. 7. We will begin increasingly to see the containerization of applications and services, e.g. FileMaker Server. a. Unlike virtual machines, they don't need a full OS to be installed within the container. b. Once the container has been created, it can easily be deployed to different servers. From a software lifecycle perspective this is a great help, as containers can quickly be copied to create environments for development, testing, integration, and production. 8. We need to adopt processes that facilitate how data owners can assure they exercise due diligence on cloud-hosted data. The owner is the responsible party here. And it is the owner who likely would suffer the bulk of the onus of any breach. In order to exercise this due diligence, data owners must expect and insist on transparency from hosting and PaaS providers about security processes including who does and does not have access to and knowledge of encryption keys. This will not be a straightforward process. 9. As we experience more and more instances of Machine Learning, we will need to be aware of, and to guard against, manipulation of the Training Data that underpins this process. Such data are susceptible to attack and to manipulation that poisons the data. Even a very small amount of such alteration can affect the machine learning process. 10. The Human Element has always been at the center of effective FileMaker Platform Security. That will become even more the case in 2020 and beyond as we move to Federated Identity Management and to Digital Transformation. The culture of any organization is a governing element for its success. We will have many challenges here properly to account for and to plan for the Human Element. Steven H. Blackwell Platinum Member Emeritus
  2. 3 points
    Well, I suggest you put some restriction on the number of allowed values, because otherwise this gets (even more) complicated. Some background: Your question is a variation of the subset sum problem, which in turn is a special case of the knapsack problem. Both are VERY difficult problems to solve programatically. Even worse, the known solutions are difficult to implement in Filemaker, because its calculation engine has no arrays. Fortunately, with a small number of values, a naive brute-force solution is feasible: enumerate all possible combinations of the given values, calculate the sum of each combination, and compare it to the target sum. The attached demo is designed to deal with up to 7 values. It has 127 records to enumerate the 2^7 -1 = 127 possible combinations, and a repeating calculation field with 7 repetitions to list the values of each combination. You can extend the limit by adding more records and more repetitions, but - as I said - this is a brute-force approach and it will get slower as the number of values increases. SubsetSum.fmp12
  3. 3 points
    Could it be = C * Tan ( Radians ( A ) ) + B ?
  4. 2 points
    In layout mode, put the fields you want on the Body part, and Ctrl-i to bring up the Inspector. Here you have a couple of options: 1. If you just want to keep the fields from printing, select them and use the Hide when printing checkbox. 2. If you want to hide the fields in Browse mode, use the Hide object when option, with a formula of True -- and leave the Apply in Find mode checkbox empty. If you're not wanting to even have a Body part, then forget all the above and just use a different layout for the Find. Welcome to the forums.
  5. 2 points
    A better alternative, IMHO, is to use characters designated for such purpose. Here are some you can choose from: Char ( 31 ) - UNIT SEPARATOR Char ( 30 ) - RECORD SEPARATOR Char ( 29 ) - GROUP SEPARATOR Char ( 28 ) - FILE SEPARATOR Char ( 8233 ) - PARAGRAPH SEPARATOR Char ( 8232 ) - LINE SEPARATOR There are also non-characters "intended for process-internal uses": Char ( 65534 ) Char ( 65535 )
  6. 2 points
    There exist several variations of the CSV format. The variation that Filemaker uses encloses all fields in double quotes. This allows exporting fields that contain commas, carriage returns and double quotes. According to the RFC 4180 specification: Any field may be quoted (with double quotes). Fields containing a line-break, double-quote or commas should be quoted. (If they are not, the file will likely be impossible to process correctly.) If double-quotes are used to enclose fields, then a double-quote must be represented by two double-quote characters. It should be noted that Filemaker's implementation does not fully conform to these requirements (or perhaps better put, it exceeds them) because it converts in-field carriage returns to vertical tabs, for no good reason. You need to create your own. The available methods depend on the version in use - see: https://fmforums.com/topic/106027-need-to-export-a-text-file-with-each-field-on-a-separate-line/?do=findComment&comment=479210 If you're indeed using version 11, then XML/XSLT is your only option - unless your target application can read UTF-16 encoded files. If it does, you can have a script write the CSV into a global text field, then export the field's content. Or, if you're willing to limit yourself to the Mac platform, you could use AppleScript to create the file (you could probably use OS-level scripting in Windows, too - but then you would have to put in twice the work). -- P.S. Your profile says version 11 on Catalina; I believe that's a very unstable combination. PP.S. What's up with the title?
  7. 2 points
    The easy way to solve such problems is to: 1. Enter the "native" version of your AppleScript into a text field: display dialog "Hello \"world\" " 2. Open the Data Viewer and enter: Quote ( YourTable::Textfield ) 3. Paste the result into your calculated AppleScript formula: "display dialog \"Hello \\\"world\\\" \" "
  8. 2 points
    Here is my documentation on word break rules, taken mostly from discussions here on FMForum over the years and MOSTLY from Comment 🙂 The ampersand and hyphen are word delimiters - but they are not the only ones. There are many more, first and foremost a space, of course. I don't know if there's a comprehensive list, but at least !@%^()≠+[]{}<>≤≥`~|\? are all word delimiters. Word delimiters are not words, so you cannot get them with the MiddleWords() function. space * # ; " = $ € & / ≈ ∏ ‡ Detailed feedback: If I go to FileMaker Pro 11 Help for MiddleWords, the example uses spaces and the note refers to ampersand(&) and hyphen(-) to identify the beginning of a new word. No other symbols are given. I was curious about what other symbols might be able to be used. I created an Excel spreadsheet with the ASCII 255 characters and created text with separators using each of the characters. When I imported it into FileMaker Pro, I used MiddleWords in my calculation, I found that a period (char 46) did not work, I did find the following symbols did work: Char 9 is ", "Char 10 is ", Char 11 is , Char 12 is , " Char 13 is ", Char 32 is , Char 33 is !, Char 34 is ", Char 35 is #, Char 36 is $, Char 37 is %, Char 38 is &, Char 40 is (, Char 41 is ), Char 42 is *, Char 43 is +, Char 44 is ,, Char 45 is -, Char 47 is /, Char 58 is :, Char 59 is ;, Char 60 is <, Char 61 is =, Char 62 is >, Char 63 is ?, Char 64 is @, Char 91 is [, Char 92 is \, Char 93 is ], Char 94 is ^, Char 95 is _, Char 96 is `, Char 123 is {, Char 124 is |, Char 125 is }, Char 126 is ~, Char 128 is €, Char 130 is ‚, Char 132 is „, Char 133 is …, Char 134 is †, Char 135 is ‡, Char 136 is ˆ, Char 137 is ‰, Char 139 is ‹, Char 147 is “, Char 148 is ”, Char 149 is •, Char 150 is –, Char 151 is —, Char 152 is ˜, Char 153 is ™, Char 155 is ›, Char 161 is ¡, Char 162 is ¢, Char 163 is £, Char 164 is ¤, Char 165 is ¥, Char 166 is ¦, Char 167 is §, Char 168 is ¨, Char 169 is ©, Char 171 is «, Char 172 is ¬, Char 173 is ­, Char 174 is ®, Char 175 is ¯, Char 176 is °, Char 177 is ±, Char 180 is ´, Char 182 is ¶, Char 183 is ·, Char 184 is ¸, Char 187 is », Char 191 is ¿, Char 215 is ×, Char 247 is ÷, NOTE: The character ` acts as a word separator on the Macintosh but not in Windows. RULE 1 (period .) one.two = 1 word one.2 = 2 words 1.two = 2 words 1.2 = 1 word RULE 2 (slash / hyphen - colon : comma ,) one-two = 2 words 1-two = 2 words one-2 = 2 words 1-2 = 1 word RULE 3 (single quote ') one'two = 1 word one'2 = 2 words 1'two = 2 words 1'2 = 2 words I think it is very important information. The old links are no longer available from what I can tell, which is why I'm just posting my 'combined-gathered' rules here again.
  9. 2 points
    It depends not only on the character following the punctuation mark, but also on the character preceding it: WordCount ( "A-1" ) = 2 WordCount ( "1-1" ) = 1 And these results are not necessarily the same for all punctuation marks.
  10. 2 points
    Perhaps I am missing something here, but ... the SQL query is nothing more than a text string. If you know the name of the table, you can enter it as literal text; if you have it in a variable, you can simply concatenate the variable to the rest of text, so that instead of: "SELECT * FROM ITEM" you have: "SELECT * FROM " & $table_name Adding both Quote() and Evaluate() to the mix does not accomplish anything. Evaluate ( Quote ( text ) ) returns the original text unchanged. However, if the name of the table does not begin with an alphabetical character, you must enclose it in double quotation marks. Here, the Quote() function can be helpful: "SELECT * FROM " & Quote ( $table_name ) So to summarize, setting the variable to: BE_FileMakerSQL ( "SELECT * FROM " & Quote ( $table_name ) ; "," ; ¶ ; $fm_file ) should work for you.
  11. 2 points
  12. 2 points
    I am not sure this is the best place to start, but let's try. And let's start with a Sunday: Mod ( 4 - 1 ; 7 ) = 3 That's 3 days until Wednesday. Next, let's take a Monday: Mod ( 4 - 2 ; 7 ) = 2 That's 2 days until Wednesday. Now, Tuesday is of course 1 day before Wednesday:: Mod ( 4 - 3 ; 7 ) = 1 and I think it's clear that 4 - 4 will result in 0 days to move from Wednesday to Wednesday. So far, we have simply subtracted the day-of-week of today from 4 (Wednesday). Applying mod 7 to the result did not change it. Now this is where it starts to get interesting. If today is a Thursday, then the difference is -1 (as in you need to go 1 day back to get to a Wednesday). But Mod ( - 1 : 7 ) returns 6, telling us we need to go 6 days forward to get to the next Wednesday: Mod ( 4 - 5 ; 7 ) = 6 Similarly (as you already calculated), it's 5 days from Friday to next Wednesday, and 4 days from a Saturday. So this calculation always tells us how many days to add to today in order to get to the next Wednesday. --- A note is required here: in many programming languages, Mod ( - 1 ; 7 ) returns -1 instead of 6. And so did Filemaker before version 7. The v.7 team made a very smart and untypically bold decision to change the behavior in order to conform to the recommendation of Donald Knuth. Before this change, you always needed to add some multiple of 7 to the dividend in order to avoid a negative result - for example, Mod ( -1 + 7 ; 7 ) would return the wanted 6 instead of the useless -1. And this is perhaps the most significant aspect of the Mod() function: Mod ( 3 ; 7 ) = 3 ; Mod ( 10 ; 7 ) = 3 ; Mod ( 17 ; 7 ) = 3 ; Mod ( 24 ; 7 ) = 3 ; ... As you can see, adding a multiple of 7 does not change the result. IOW, the Mod() function is cyclical - and that's why it's so useful for date calculations: our calendar is cyclical too.
  13. 2 points
    The way your find works is this: first, it finds records with duplicate values in the QItemSerial field. Next, it finds records with duplicate values in the Type field. Finally, it returns the intersection of the two sets. So for example, if you had 3 records in a table: Field A Field B A 1 A 2 B 2 your find would return a found set of one record: A 2 because that's the only record that has a duplicate value in both fields. If you want to find record that have matching values in both fields, you will need to define a calculation field that combines the two fields, e.g. (result is Text) = QItemSerial & "|" & Type then search for duplicates in this field.
  14. 2 points
    Hi Dave - we’re working on a change to MirrorSync to include our own Java, separately from whatever else is installed for the operating system. For now, it might be necessary to stick with Oracle java for a month or so.
  15. 2 points
    I am not sure what exactly I am looking at. To move this forward, I suggest you do the following: Enter some dummy data into your FMP file (if necessary, use a copy of the real file). Make sure you have at least two records; Export the fields you need as XML, using the FMPXMLRESULT grammar, with no XSLT stylesheet applied; Write an XML document, using the same dummy data, in the format you need for importing. Then post the two files here. Note: I am asking for at least two records, because the files you have shown so far seem to have only one record and no provision for multiple records in their structure.
  16. 2 points
    Oh the irony AutoUpdate out of date
  17. 2 points
    Do note however: in a found set sorted by Category, where category can be be either A or B or C, a calculation field = sTotalValue - 2 * GetSummary ( sTotalValue ; Category ) when placed in a trailing grand summary part, will return the equivalent of: sub-summary value of A + sub-summary value of B - sub-summary value of C This is because the calculation will be evaluated from the context of the last record in the found set, which belongs to category C.
  18. 2 points
    Hello, You would need to make use of the MimeMessage class's setHeader() function. You can set the e-mail as plain text with call msg.setheader("Content-Type", "text/plain") https://stackoverflow.com/questions/12511744/custom-mail-headers-using-mime-in-java You may also need to specify "text/plain" as the second parameter in your [body object].setBody() call. The proper key to set an Unsubscribe List is "List-Unsubscribe". At the link below, someone applies it, and also includes a loop the prints all the headers to the console. https://stackoverflow.com/questions/21959235/javamail-api-listing-header-doesnt-work You can probably set a list of headers to a return variable to test out your function call, something like: String headersList; Enumeration headers = msg.getAllHeaders(); while (headers.hasMoreElements()) { Header header = (Header) headers.nextElement(); headersList += "\n" + header.getName() + ": " + header.getValue()); } return headersList;
  19. 2 points
    Hello, During the process of setting up a MirrorSync configuration, MirrorSync generates a FileMaker script that gets pasted into the syncing solution. In this script are all of the fields you specify to include in the sync. If changes are made to the structure of the database of which MirrorSync is not aware, it could result in an error. If a field is added to a sync layout---the layout specified in the configuration as the interface by which MirrorSync syncs data---changes to that field will be ignored. However, any changes to that field would trigger the modification timestamp to change, so MirrorSync will pick up on this discrepancy between the hub and spoke mod timestamps---the driving factor for processing changes---not find any field value changes, and may perform a slow deletion scan or run in recovery mode, which will slow down the sync process. If a field is added or the name changed, FileMaker will probably throw a "missing field" error because the Set Field script step in the MirrorSync script will try to write to a missing field. This will cause the sync to abort, or for changes to not sync properly. MirrorSync logs all sync activity, especially errors. Major errors like a sync failure can be reported to an e-mail specified in the sync configuration if you select this option. Any changes in the database configuration that affect the sync or cause it to fail will just register as a errors with MirrorSync. MirrorSync does not do a separate evaluation of the databases on both sides of a sync to ensure the schemas match up perfectly. This is assumed. How often are you wanting to back up your information? Are you wanting to perform a minute-by-minute back up to maintain data integrity? This is the scenario I imagine where using MirrorSync to back up your data would be advantageous. Otherwise, if you just want something like an hourly backup, if you're looking for a 3rd party app to back up your databases, we offer SafetyNet(https://360works.com/filemaker-offsite-backup/) which backs up FMS hosted solutions to Amazon S3. On the topic of schema changes, we also have a product, 360Deploy(https://360works.com/filemaker-deploy-versions/), that makes deploying new FileMaker database versions to your prod server very easy. I hope that answers your questions. Let me know if you have more!
  20. 2 points
    Just subtract your date from Get (CurrentDate). Make sure the calculation is unstored, so that it updates as time goes by.
  21. 2 points
    Have look at the attached demo. It does two things: First, it looks for the occurrence of known patterns in the given text. When any of the known patterns is found, the corresponding code is retrieved. This part is accomplished using a looping script. I could have used a custom function for this, but I am not sure how well this would perform with an unstored calculation going over a large list of patterns at every screen redraw.. The second step is highlighting the found patterns. This is done in a calculation field, so that the original is preserved. Here I am using a pair of custom functions (could be just one, but I also wanted to preserve the original case, so I did not use Substitute()). Most importantly, the file separates data and logic: the patterns and the corresponding codes are kept in a table and both the script and the calculation access them there, with no hard-coding of data in calculation formulas.. MultiPatternCount+Hilite.fmp12
  22. 1 point
    Download : http://www.gokselgokce.com/index.php/2020/05/26/claris-filemaker-icin-php-kodlayicisi/
  23. 1 point
    No. You can however see if you can't replace that part with a card window so that it doesn't show the whole time but you only call it when it is time to sign. That way you can create a layout that will be used in the card window and will be shared with all layouts where you need this functionality.
  24. 1 point
    Good. Perhaps I should add that the formula will be one day off for dates in the months of January and February in the year 1900 (i.e. numbers 1 thru 60). This is because Excel incorrectly considers 1900 to be a leap year. It's possible to make a correction for that, but I did not bother.
  25. 1 point
    There isn't. But it sounds like there is an opportunity to change the design a little. If you find that many fields are repeated across the panels then add them outside the tab panel object so that you don't need to repeat it. Resize the tab panel and use it only for those pieces of information that are different.
  26. 1 point
    Most APIs these days offer functionality over and beyond just moving data. Once you have the basics of the API connection set up, tapping into the extra functionality is a piece of cake. In the next few days for instance we'll have a series of blog posts on how to use the Office 365 APIs. Sure you can get and send email using SMTP natively and through POP/IMAP with a plugin but the APIs offer that and much more. Access to your OneDrive for instance, or a simple endpoint to convert a Word doc you have there into a PDF... adding data to an Excel sheet without having it on your computer. Besides that, many providers are actively moving way from old technology and protocols, you won't find many that let you touch their underlying data tables directly through ODBC. They provide an API so that there is level of abstraction that allows them to change things on their backend. As a result our integration is more robust.
  27. 1 point
    Same thing happened to me on just one machine and simply copying the certificates over didn't fix the problem as FileMaker repeatedly overwrote root.pem with its own incomplete copy. Broken root.pem only contains a single certificate which belongs to FileMaker. Working root.pem contains a lot more certificates belonging to certification authorities. certifiedroot.pem will be completely missing as well. The band-aid fix is a bit unwieldy but it works. save a copy of root.pem and certifiedroot.pem from a working installation or attached to this post to Downloads folder, then open a terminal and issue the following commands chmod u+x ~/Library/Application\ Support/FileMaker/FileMaker\ Pro\ Advanced/18.0/ cat ~/Downloads/root.pem > ~/Library/Application\ Support/FileMaker/FileMaker\ Pro\ Advanced/18.0/root.pem cat ~/Downloads/certifiedroot.pem > ~/Library/Application\ Support/FileMaker/FileMaker\ Pro\ Advanced/18.0/certifiedroot.pem chflags uchg ~/Library/Application\ Support/FileMaker/FileMaker\ Pro\ Advanced/18.0/root.pem The cert problem has been with FM for ages, apparently. A similar problem occured in version 9 and 11. Why it had to re-appear now is anyone's guess. certifiedroot.pem root.pem
  28. 1 point
    In your OnOpen script, detect whether you are logged in with Full Access and use the "install menu set" for the default menu set and toggle the option to use as file default.
  29. 1 point
    No, it cannot. Well, in theory, you could program the AppleScript to perform a developer's role by mimicking key presses and mouse movements - but I don't think you would get very far with this in practice.
  30. 1 point
    To extract the item ID: Let ( [ start = Position ( FEEDBACK::F1 ; "Item ID: " ; 1 ; 1 ) + 9 ; end = Position ( FEEDBACK::F1 ; "/" ; start ; 1 ) ] ; Middle ( FEEDBACK::F1 ; start ; end - start ) ) To extract the question number: Let ( [ start = Position ( FEEDBACK::F1 ; "/" ; 1 ; 1 ) + 1 ; end = Position ( FEEDBACK::F1 ; "," ; start ; 1 ) ] ; Middle ( FEEDBACK::F1 ; start ; end - start ) ) To extract the item description: Right ( FEEDBACK::F1 ; Length ( F1 ) - Position ( FEEDBACK::F1 ; "Item Desc: " ; 1 ; 1 ) - 10 ) -- P.S. Are you sure the separator between Item ID and Item Desc is a comma, not a semicolon?
  31. 1 point
    It's hard to form an opinion based on so little information. However, one thing jumps out immediately: your structure would allow a user to participate in at most one local competition, one regional competition and one international competition. I would expect to see a join table of Attendance between Users and Events, so that the relationship can be many-to-many (one user attends many events, one event is attended by many users). I also wonder if you really need 3 separate tables for the events. I would think a single table, with a field for the event's type, should be quite sufficient. I am not sure what kind of information is supposed to go into the tables under the Development label, so I can't say anything about that.
  32. 1 point
    I hear ya. Integrating with anything comes at a cost. You can either build or buy. If you build, you bear the responsibility of keeping track of the FedEx changes, make sure you get early notifications and spend some time on those. If you buy you have to do vendor risk management: is the vendor quick to support, are in for the long haul... decisions, decisions...
  33. 1 point
    Finally, after many turns, I've found what's going on: /bin/bash needs to have Full Disk Access privileges. In order to do so I went to Apple Menu > System Preferences > Security & Privacy, selected Privacy tab, unlocked the settings and added /bin/bash to the list. Now I can read and write the mounted share, but even after doing this the script doesn't work when called from FMS17 but that's a different story: first I should upgrade to FMS 18.0.3 or downgrade Catalina to Mojave, as @Wim Decorte suggested
  34. 1 point
    The pattern: X-17 is two words. When you search for: X*17* Filemaker looks for a single word that starts with "X" and contains "17", e.g. "xy217z".
  35. 1 point
    If you get the same error in the Script Editor application, then the problem is not Filemaker related. AFAIK, the correct Applescript command to use with the Terminal application is 'do script', not 'do shell script' (as I tried to tell you in your previous question).
  36. 1 point
    No, just 1 flavor. 'Advanced' means they can charge more, or it's something special...
  37. 1 point
    No. ScriptMaster uses Java (or Groovy, which is a Java variant), not Javascript. Two completely different languages. It runs in a web viewer, not in Filemaker itself. The web viewer is just an instance of Safari on MacOS and Internet Explorer on Windows. In this thread you will find two demo files showing how you can produce QR codes in Filemaker. They both use the same Javascript code available from: http://davidshimjs.github.io/qrcodejs/
  38. 1 point
    Hi Wim! Can you explain this a bit more? How might users collide if creating multiple records? Do you mean because the file was numbering the records or did you have an additional concern?
  39. 1 point
    Have you tried a "freeze window" script step before the "go to layout" script step?
  40. 1 point

    Version 1.0.0

    317 downloads

    FileMaker® Server 16, introduced in April of 2017, brought with it the capability to use three oAuth2 Identity Providers to authenticate Identity Assertions made in attempts to access hosted FileMaker® Pro files. Google, Amazon, and Microsoft® Azure AD were the three Identity Providers. Since then various members of the developer community have sought ways to expand beyond those three providers to employ other Identity as a Service (IDaaS) options. Wim Decorte and I are pleased to advise that we have succeeded in an effort to expand the available Identity Provider services to additional systems. We have documented the underlying mechanism that FileMaker Server uses and have identified at least five new major IDaaS providers whose oAuth2 capabilities we can leverage to permit their use in the FileMaker Platform environment. We hope this means, among other items, that the FileMaker Platform can now be used at locations where heretofore it was disqualified due to lack of support of these Authentication options. We were aided in this endeavor to a substantial degree by assistance from Claris International, Inc. (formerly FileMaker, Inc.) working in a customer environment. This ratifies to a substantial degree the maxim postulated by well-known business author Tom Peters back in the 1970’s that “Innovation doesn’t come from the R&D Department; it comes from the customer base.”

    Free

  41. 1 point
    Try: Sum ( Onhand ; PendingOrders::sTotalQtyByWeekR[1] ; PendingOrders::sTotalQtyByWeekR[2] ; PendingOrders::sTotalQtyByWeekR[3] )
  42. 1 point
    Actually, you only need to "deal" with the "-" operator. The "+" and the comma can be simply substituted with a carriage return to get a list that Filemaker recognizes as a list of values (assuming that's what you want as the result). Iterating from 1 to 5 and creating the intermediate values requires either a custom recursive function or the While() function or a looping script. Please update your profile to reflect your version and OS so that we know which one of these you can use. -- Note: 1. A field where a user is allowed to enter "12+82" or "1-5" or "31,33,35,37" should be a Text field. 2. You may face a difficulty if a user enters a value that does not fit one of your 4 formats listed above.
  43. 1 point
    There are several options to consider. Much depends on how often you need to do this. If it's only now and then, then looping is not a bad choice, because it puts all the required logic in a script and avoids adding fields and relationships to the schema. Otherwise you could add a calculation field to the News table that wraps each story in a div element, and get them using either the List() function over a relationship or a summary field defined as List of [the calculation field].
  44. 1 point
    You initiate the run of a script in the scheduler on the server. You specify a date and time when to run a script. You can run a script once or repeat it every day, every hour, etc. In the script you can then check the current date and time to determine whether it's a last semester day. I'm not sure I understand your question about PSOS. A PSOS script is triggered from a client. Not from the server. You can't run the PSOS script command on the server.
  45. 1 point
    That sounds like you're not working the InDesign end correctly. The thing that puzzles me the most is that you say you are able to make it work with data from Access - but you're not able to tell us what the difference is. I can help you with getting the export from Filemaker to conform to any format that works for you. But I cannot help you with finding out what that format needs to be.
  46. 1 point
    Not sure how relevant it is https://www.filemakermagazine.com/videos/publishing-indesign
  47. 1 point
    You are asking us to debug two scripts we cannot see. The best you're going to get is a guess. Why don't you use the debugger along with the Data Viewer to locate the exact point of failure? In general, I would say that if a script sets a global field to a value and the global field is still empty, then the most likely causes are : the value is empty; you're setting the wrong field; you're reading the wrong field; the user setting the field is not the user reading the field. Since you say you have moved the target table from an external file, the "wrong field" theory (as in "wrong TO") seems the most likely.
  48. 1 point
    I'm not quite sure I follow the part where you try to establish temporary relationships. Some thoughts: - passing information between scripts: using script parameters is a good way to do that, that's what it is there for. But setting global fields should work too - you do not need a relationship to set global fields in a different table; if that is what you are doing then you can scrap the whole mechanism. You can set a global field anywhere at any time, without a relationship.
  49. 1 point
    Google 'FileMaker Time Picker' Here's a few: https://www.filemakermagazine.com/videos/time-picker-widget http://www.modularfilemaker.org/module/time-picker/ http://www.modularfilemaker.org/module/time-picker/ https://hbase.net/2018/09/03/time-picker-for-filemaker-go-on-ios/
  50. 1 point
    Apparently we just needed to restart the app and that fixed it.
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.