Jump to content

All Activity

This stream auto-updates     

  1. Yesterday
  2. Changed file to rolling 30 days, from today to 30 days into the future, using Relationship rather than filtered portal. Retest_ExpiryModSM2.fmp12
  3. Not sure of the terms that you're using here. A calculated flag field would be one that doesn't get set by script. ESQL does not use fully qualified field references. That is, do not use table_occurrence::field_name, but rather field_name. Here's the template from FileMakerStandards.org that I typically start with: Let ( [ ~sql = " SELECT ~field FROM t1.~table1 JOIN t2.~table2 ON t1.~field = t2.~field WHERE ~field=? ORDER BY ~field "; $sqlQuery = Substitute ( ~sql ; [ "~table1" ; SQLTableName ( Table1::fieldName ) ]; [ "~table2" ; SQLTableName ( Table2::fieldName ) ]; [ "~field" ; SQLFieldName ( Table1::fieldName ) ] ) $sqlResult = SQLDebugResult ( ExecuteSQL ( $sqlQuery ; "" ; "" ; $value ; $value[2] ; $value[$n] ) ) ]; If ( $sqlResult = "?" ; False ; True ) ) If you're looking to have a script set a number field in a parent, then I would suggest using a OnRecordCommit trigger. Not sure I'd even bother using SQL, since a simple calc will let you know if any children = 1. Btw, the TEST: YesFlag__lxt field should be a number. It's either 1 or null, correct? It can be formatted to show the word "yes" using the inspector. If ( list ( parent_to_child::PassedYN))
  4. Thanks Dough & Steve...I really appreciate it...
  5. Google Charts not printing in FileMaker 16

    i will use mbs plugin to solve the problem.
  6. As you can see in the image i create from filemaker the google map and the points of address. Using the polygon function I delimited the area that include the addresses. as i create the polygon i get into a div the coordinates of the polygon. I should pass them to filemaker and it has to find the addresses included into the polygon. To find them i should loop all the records to check if the address of each is in the polygon bound. I didn't find the formula to get this result, there are custom function for circle or rectangle area but not for a polygon. Does any can help me? Polydata_test1.html
  7. You don't provide much context about what you expect to happen. Just based on looking at your file, I'm curious as to why you chose this path of 2 relationships to dashboard via a 'Constant' (1). This is more of an outdated approach as now you can use the Cartesian relationship to do the same thing. I guess your goal is to display what is due for retest and what is about to expire on your dashboard? It might be easier just to ditch all the relationship hoops and use 2 self join relationships with filtered portals. As a side note, you may want a rolling expirations/retest dates, so on the last day of the month you know what's happening tomorrow. Modified file Retest_ExpiryModSM.fmp12 Edit: I see doug posted the same time as me :)...2 different approaches.
  8. See if this helps Retest_Expiry_dh.fmp12
  9. Hello All, How can I capture all the materials that are going to expire and for retest this month. My problem is with my present graph relationship (Retest) it will not capture all the materials that are due for retest this month. it only capture today's date and future dates and also it captures the next month dates same with my expiry relationship. I have attached the file that Im working on for your reference Thank you so much.. Retest_Expiry.fmp12
  10. I have a solution running on a Filemaker 16 server. I have accessed the server via VPN on a remote Mac and now want to access the data via ODBC on that remote Mac. I have turned ON ODBC/JDBC for ALL USERS in the Filemaker file I have downloaded ODBC Manager – the free version But when I try access the Filemaker "System DSN" in the ODBC Manager, nothing appears. This is a mystery to me as this exact (and rather simple) setup works perfectly on my local network. I originally set up the local network some time ago, so: • Have I missed a step? • Does the ODBC not work across a VPN as opposed to local network where it works great? • Does the ODBC manager I am using not work on iOS Sierra? • Is there something else that I am missing? Notes: Filemaker 16 Mac OS Sierra ODBC Manager: 1.0.12
  11. High Sierra wierdness

    Not only appear a Java app when starts FileMaker... also is very unstable. In my MacBook whit High Sierra is closing one time and another.
  12. Brilliant! that works. thank you very much Olger!
  13. Hi, I've got a form that using check boxes to update a summary text box with information based on which check boxes have been checked. However, if one is checked in error and then unchecked I would like to remove the text from the summary text field. I've tried to use the Substitute the text with just a blank and all it seems to do is keep the text but put it in lower case. I had bullet points but then removed these to see if that would help but didn't I'm not sure where to go from here. Ideally I would like to keep the bullets but if they need to go that fine. Any help would be greatly appreciated. TIA
  14. We have a complex MySQL and PHP; multi-tenanted application which we are now looking at syncing to an offline portable FileMaker model. I have essentially solved every problem thus far and have MirrorSync running properly. My challenge is this: Our main MySQL database works in tandem with a second MySQL database; the second database contains 25 million property records. The working set of data which needs to be synchronised is a small subset of data from the primary; and a single record from the secondary database into the mobile version of the application which consists of a single FileMaker file with identical tables to that of the primary mysql database and a table identical to that of that of the secondary. How do sync the two seperate databases in a single configuration? Or is that even possible. I could see that I could generate two seperate configurations; and perhaps split the mobile version into two seperate FileMaker files; i'm just wondering if there is a smarter way to go about what I need to achieve.
  15. We have a complex MySQL and PHP; multi-tenanted application which we are now looking at syncing to an offline portable FileMaker model. I have essentially solved every problem thus far and have MirrorSync running properly. My challenge is this: Our main MySQL database works in tandem with a second MySQL database; the second database contains 25 million property records. The working set of data which needs to be synchronised is a small subset of data from the primary; and a single record from the secondary database into the mobile version of the application which consists of a single FileMaker file with identical tables to that of the primary mysql database and a table identical to that of that of the secondary. How do sync the two seperate databases in a single configuration? Or is that even possible. I could see that I could generate two seperate configurations; and perhaps split the mobile version into two seperate FileMaker files; i'm just wondering if there is a smarter way to go about what I need to achieve.
  16. Last week
  17. Launch script from calculation

    That seems to have done the trick!! thanks for the suggestion. Will not know for sure until this Sunday when I will be using the database again, but for now, it seems like it's working. Thanks again.
  18. You can also use a WebViewer for animated text indication or icon. see this CF for a html ticker: http://www.briandunning.com/cf/1761 or this to use a Base64 encoded animated GIF: http://www.briandunning.com/cf/1766
  19. Most of my medium to heavy scripts are now performed on server. To give the users some feedback while they wait, I wanted a method that was simple and subtle. In this example I ; added a popover button with '+' icon set the feedback message in the popover title bar formatted, sized and positioned the popover added a OnObjectEnter script tigger to the popover in the script I add a PSoS step with Wait for completion set to 'On' last step of script is Close Popover
  20. Halt Server scheduled script from OnWindowOpen

    What if you 'exit application'? I would expect that to work.
  21. When it comes to hosting your FileMaker solution, there are a lot of options out there. You can host it yourself onsite, you can host with a service, or you can explore FileMaker Cloud. Let’s assume that you’ve decided the hassle and costs associated with hosting your solution yourself are too prohibitive and you’ve decided to host with a service. Now you’re looking at plans. There is shared hosting and dedicated hosting and concierge services for FileMaker Cloud (not discussed in this blog, but follow this link for more info). Shared Hosting Shared hosting is the most economical option available on the market and very appealing to a lot of people looking to host their FileMaker solution. In order to figure out if shared hosting is the right option for you and to help you choose between our Starter or Professional Plan, let’s start with a few questions: First: What version of FileMaker Pro is your solution currently running on? What version of FileMaker Server are you currently using and what version of FileMaker Pro and FileMaker Server do you want or need to be on? Okay, that was technically three questions, but they are all important. Our shared hosting plans support FileMaker Server 11-14 and FileMaker Pro (client) 7-16. The compatibility chart below details what FileMaker Pro versions are available on the different FileMaker Server versions. If don’t want to or don’t need to upgrade to FileMaker Server 15 or above, a shared hosting plan could be perfect for your needs. Second: How many files do you want to host (and how big are your files)? The Starter plan is ideal for one file and up to 1 GB of data. If you need to host more than one file, the Professional plan supports up to five database files and 5 GBs of storage. Third: Do you need FileMaker WebDirect or FileMaker Go connections? If yes, you need to go with the Professional plan. Our Starter plan does not support WebDirect or Go connections. Dedicated Hosting If you want or need to be on FileMaker Server 15 or higher, you need to go with dedicated hosting. We offer four plans (Micro Team, Small Team, Medium Team, and Large Team – henceforth referred to as Micro, Small, Medium, and Large) designed to cover, accommodate, and service a wide variety of needs and requirements. Let’s review some of the factors that go into deciding which plan is the best fit for you. 1. File size Each plan allows you to upload up to 125 database files, but the size of your files is a determining factor in deciding which plan is right for you. Our dedicated hosting plans offer varying quantities of disk space to accommodate the overall size of your files. Our Micro and Small plans have limited storage. If the files being hosted are too large, it becomes difficult to provide redundant backups without incurring additional costs. If your files’ total sizes are less than 5 GB, you are probably okay going with the Micro plan. With 60 GB of disk space available, anything larger than 5 GB becomes too big for the standard backup routines that are included with the plan. What if your FileMaker files are just a little too big for the Micro plan? Then the Small plan should work for you since it can host files up to 10 GB. With either of these plans, you can also purchase additional blocks of 100 GB for $20 a month. If you have files over 10 GB, then you may want to consider a Medium or Large plan. These servers can hold files up to 150 GB – giving you lots of room for your FileMaker file and even external data too. 2. Performance What kind of performance do you need and what do you intend to do on your server? If you plan to run continuous routines or regular audit systems, you are going to want to opt for the Medium or Large plan. With more RAM available, these plans are better equipped to handle complex processes that won’t result in lag. Interested in learning more about FileMaker performance when hosting? Check out this video Marc Larochelle, our CEO, did: Click here to view the embedded video. 3. Bandwidth Depending upon how you use your solution, you may need a lot of bandwidth. Several things can determine if you need unlimited bandwidth: A. if you work with a lot of interactive containers B. if you plan to regularly download data to your local machine C. if you use custom web publishing D. your backup is going to Dropbox All of these use a lot of bandwidth, so we’d suggest our Medium or Large plan. If you use your solution more for regular data entry and as storage for historical documents that you are not downloading daily – you’ll be fine with a Small plan (or maybe even a Micro). 4. Number of FileMaker users / WebDirect access Here are two more things to consider. Do you have less than 10 FileMaker Pro users? Look at the Micro Plan. Anything over 10 users, your options are wide open with the Small, Medium or Large plans. While all plans support FileMaker Go access, only the Small, Medium, and Large Team plans support FileMaker WebDirect access. If you intend to have more than 10 users connecting to your solution via FileMaker Go or you want to use WebDirect, also stay with any plan above the Micro plan. The Small, Medium and Large plans come with 8 GB or 16 GB of RAM, respectively – which is needed if you intend to have a larger number of users connecting remotely. 5. Backups Each of our dedicated plans have a robust backup schedule. Your ideal plan will depend on your backup needs. The Micro and Small plans keep a daily backup for 7 days. At any point, your oldest backup will be from one week ago. Additional backups or DropBox storage (for archive purposes) may be requested for an added cost. If you need more longevity on your backups, you can consider a Medium or Large plan. These plans hold backups for up to one year. Both plans (Medium and Large) include twice daily backups completed at 12:30 pm and 1:00 am. These daily backups are kept for one (1) week. We then run weekly backups that are kept for one (1) month and monthly backups that are kept for up to one (1) year. For redundancy and disaster recovery, all backups are stored on a 1 TB external drive and a daily backup is uploaded to a dedicated folder on Dropbox (see #6). If you are considering creating your own backup schedules, we highly recommend the Medium or Large plan. Additional backups can be costly on the Micro or Small plan, due to the fact both are running on AWS. AWS charges per GB of space, as well as bandwidth usage. 6. Dropbox Do you want your backups available via Dropbox and do you want the ability to access a Dropbox backup up to 365 days later? Dropbox is automatically included with Medium and Large plans. Dropbox is available with our Micro and Small plans, but it does cost extra. With Dropbox, we can provide you with backups that are up to 365 days old. Dropbox also allows for more redundant storage of your backups. 7. SSL Certificates We include a wildcard SSL certificate with all of our plans. If you would like a customized SSL cert for a custom domain name or other requirements, this options is available for an additional fee. One last piece of advice. Before contacting a hosting provider, you should know: 1. How many users you will have using FileMaker Pro, Go, and WebDirect. 2. How many files you want to host, as well as the size of those files. 3. What version of FileMaker Pro and Server you plan to use. If you’re interested in hosting your solution with us, give us a call today (760-510-1200) and talk to one of our hosting engineers. We’ll discuss your requirements and specifications and get you on track with exactly what you need. View the full article
  22. Could not initialize JavaScriptConnector

    I have this issue too - tabs don't work, but otherwise all seems to be OK. Just get the error flashing up at the beginning on Safari.
  23. Happy holidays, everybody! Simple request: I want to set a calculated flag in a parent table's field so if any of that parent record's children has the word, Yes, in a specific text field it would set a value in the flag field. I tried the following but the syntax is getting the better of me; as always, your help is greatly appreciated! The flag calc is easy; the ExecuteSQL syntax is hard. Of course, if there's a native way in FileMaker Pro to do it I'm all for it! Parent table name: TEST Child table name: STANDARD_1 Fieldname in TEST: YesFlag__lxt Fieldname in RESULT: PassedYN__lxt ExecuteSQL ( "SELECT COUNT ( STANDARD_1::PassedYN__lxt ) FROM RESULT WHERE STANDARD_1::PassedYN__lxt = 'Yes' " ; "" ; "" )
  24. Once you have Core5 connected to QuickBooks, you can import QuickBooks data. 1. Click the 'Import Items' button. 2. You will be notified how many items were imported into Core5. 3. Click the 'Import Taxes' button. 4. You will be notified how many sales tax items were imported into Core5. 5. Click the 'Import Customers' button. 6. You will be notified how many customers were imported into Core5. 7. Click the 'Import Vendors' button. 8. You will be notified how many vendors were imported into Core5. 9. You can verify items and taxes in Core5 by going to their respective tabs. 10. You can verify customers and vendors in Core5 by going to the Contacts module.
  25. If you are using QuickBooks, you will need to add or modify the items in your QuickBooks company file first. Then, open the Core5 preferences and re-import the Items. This will not delete any existing items, but will update existing items and add any new items into Core5. If you are not using QuickBooks, go to the Items tab in the Core5 Preferences. You will see a '+' button to the left of the labels. Press the '+' button and enter in the item name, item description, and unit price.
  26. If you are using QuickBooks, you will need to add or modify the tax items in your QuickBooks company file first. Then, open the Core5 preferences and re-import the Taxes. This will not delete any existing taxes, but will update existing taxes and add any new taxes into Core5. If you are not using QuickBooks, go to the Taxes tab in the Core5 Preferences. You will see a '+' button to the left of the labels. Press the '+' button and enter in the tax name, tax description, and rate.
  27. There are two ways to push contacts to QuickBooks from Core5. If you wish to push a single contact, please see Workflow 1. If you wish to push a set of contacts, please see Workflow 2. Workflow 1: 1. Navigate to the contact you wish to push to QuickBooks in the Contacts module. 2. Make sure that a Type is specified for the contact. Customers and Leads will be pushed to Customers in QuickBooks. Vendors will be pushed to Vendors in QuickBooks. 3. Make sure that the contact has a first and/or last name. Contact pushed from Core5 to QuickBooks will use a combination of First and Last Name to label the contact in QuickBooks. ie. (John Smith). 4. Make sure QuickBooks and your company file are open. 5. Press the button labeled 'Push to QB'. 6. Once pushed to QuickBooks, the contact record's icon will turn green. 7. You can view the contact in QuickBooks by pressing the 'View in QB' button. Workflow 2: 1. Navigate to the Dashboard module. 2. Click the side navigation button labeled 'Contacts' to view Contacts. 3. Apply any filters you wish to have. 4. Make sure QuickBooks and your company file are open. 5. Press the button labeled 'Push All to QB'. 6. Once pushed to QuickBooks, the contact' icons will turn green. 7. You can view each individual contact in QuickBooks by navigating to the contact in the Contacts Module and pressing the 'View in QB' button.
  1. Load more activity
×

Important Information

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