Jump to content
  • Welcome To FMForums

    Welcome to our community, full of great ideas on developing your FileMaker solutions effectively,  for peer-to-peer support of the FileMaker Platform and related products and services. Register and join the conversation!

All Activity

This stream auto-updates     

  1. Past hour
  2. I am afraid I got lost trying to understand all that. See if the attached can help get you started. PriceByCountry.fmp12
  3. Today
  4. Hello Comment, I have never used Global fields either. When you ask: In which context do you need this? Could you clarify what you mean by this? I'm going to give an answer based on what I think you are asking me. There is a main table named Products and all other table are related to that table in some way with joins. The idea is on the Products layout that I can show the price of the product from each country based input fileds on the layout, that are them selves from other tables. Products - Countries Products - Dimension ( Length, Height, Width) Weight Products - Brand type Products - Suppliers So everything comes from the context of the product. But here is the one area that it has deviated for the first time. With this calculation, I am putting the context from the suppliers table, so I want to see that toy from that supplier with the country price attached to it. So each toy the supplier has, I can see how much it is for sale in each country. Toy name France Germany UK Italy Spain Disney prince 40% 72% 25% 18% 74% Each country will be showing a calculation of the ROI. What is now need is to be able to put a calculation in each of those countries whilst the calculation chooses the correct Toy, country, supplier combination. Hope this brings more clarity. I have everything else created and running, but this last part with setting the correct country with supplier and toys is the last thing, for now. Thanks in advance, Robert
  5. I will go into more detail after you answer my question. I spoke about a global field, not variables.
  6. Hi all, Really hoping someone can help me with this database. It is being used to collect marine mammal data from aerial surveys. Each survey has many environmental records and each environmental record can have many sightings. Because the iPad GPS is not very reliable for elevation, I import a separate table of GPS waypoints from an external GPS and use Lookup to pull Latitude and Longitude and Altitude information based on matching or near matching timestamps. Some formulas use the GPS information (i.e. plane position) and an angle to the sightings to create a position for the sighting. I would love to map the GPS positions and the sighting positions in a WebViewer (Google Maps). Having different icons colors for different species or labels would be great as well. I added the EasyMaps layouts and scripts but I am not proficient enough to know how to modify that to show the sighting information. The best I could do was plot the latitude and longitudes in scatter plots. Is anyone willing to assist? It's for a great cause - the aerial surveys are needed to get an abundance estimate of humpback whales in Hawaii, an urgent need given anecdotal evidence over th past two years suggesting they are in decline. File attached. Much appreciated. Maui_Nui_Aerial_Survey_Data_Collection_FEB2019.fmp12.zip
  7. Hello Fitch, When I remove the table name I get the error: <Table Missing>
  8. Is Scribe fully compatible with Filemaker Cloud?
  9. Remove the table name from the WHERE clause: WHERE _MarketplaceIDfk = 2 Except SQL doesn't like starting field names with an underscore so you have to use quotes and when you use quotes inside a string you have to escape them, so: WHERE \"_MarketplaceIDfk\" = 2
  10. Hello Comment, What you explained there went over my head. I haven't used global variables as of yet.
  11. Hello Ocean West, I am trying ExecuteSQL, but running into errors. I am getting this error in monitor: There is an error in the syntax of the query. I've going at it for about an hour now, but I still don't see it. Here is the code: $FranceSellPrice = ExecuteSQL ( " SELECT SellPrice FROM Joi_AsinMarketplacePrice WHERE Joi_AsinMarketplacePrice::_MarketplaceIDfk = 2 " ; "" ; "" ) ;
  12. I have some problems importing the Mirrorsync data onto the new server 1.Installed Mirrorsync on the new server 2.Imported the configuration 3.Copied the SyncData4_MirrorSync folder from the old server to new one When I try to sync I get the following error Solution ?
  13. Hi John, could you post code you mentioned? I have the same problem after upgrade to SM 5.1 and FM17. Best regards, Marek
  14. Going back to the beginning: Have a look at the attached file, where I use a 5x5 window to look at a 16x16 grid. I don't think can it get any simpler than that. Another option would be to use 5 portals of 5 rows each, arranged side-by-side to form a grid, and filtered to show the corresponding records from the large grid. SmallWindowToLargeGrid.fmp12
  15. This quite confusing and very difficult to follow. I picked these three sentences: Let's say you have a field in Table B that holds a return-delimited list of names. And that there is a Name field in Table A. If you define a relationship matching on these two fields, then the record in Table B will see all the records in table A whose name appears in the list as related - and can get their information. For example, a calculation of: List ( Table A::Color ) would return a return-delimited list of 81 colors. How to use such list is another question and I am afraid I did not understand your description well enough to provide an answer. -- P.S. I am not sure what is your overall purpose here, and I suspect there may be a better way to approach this.
  16. Why not create a layout with 9 button bars, each 9 buttons (to accommodate your 9x9 grid) and drive the values with a json variable? Json is essentially an array and you can create your 9x9 grid quite easily (without using a table). A button bar has the advantages that you can calculate the value it shows on the button (normal buttons can't though there are workarounds), and you can drive the conditional formatting easily through the json variable. The json variable should have 81 subarrays, which can then each hold various properties, such as colour.
  17. Here is my situation. I have a 25x25 grid - let's call it a map. Think of it like a game board, like Battleship or perhaps an Excel spreadsheet. I have a 9x9 view of this grid since it is not possible for a phone user to practically view 25x25, but 9x9 seems to work fine. And I have the concept of Current_Location on the map, which is dynamic and changes based on other factors. In TABLE1 I have records of all the "cells" in the 25x25 map that hold information about the cell (for example, the color of the cell). There is other information stored here that includes, for example, whether you can "see" other cells from this particular location in the grid. So in the record for, say, cell B5, I have a field that houses a return-delimited list of the other cells that can be "seen" from this cell (B5 in this instance). Another table, TABLE2 has records that are also have a field for Current_Location, and it tells me which cells (of the 25x25 grid) should be displayed in the 9x9 grid. Usually, the Current_Location is the middle cell in the 9x9 grid, but if the Current_Location is on the edge of the 25x25 grid, then the 9x9 view is adjusted accordingly and the Current_Location is shown on the edge of the 9x9 grid. The user can also change their orientation so they can view the map from a different direction. The way I store this information is in a field that simply lists (return-delimited) all the cell that should be shown in the 9x9 grid. So in our previous example of B5, the record for B5 has a field called Grid that is a list of the 81 cells that should be shown in the 9x9 grid. For other reasons, I cannot combine these two tables even though they both are based on the concept of relating information to Current_Location. TABLE1 is actually not as simple as described, but I'm trying to limit the scope of my question. So here is my question: I have 81 (sigh) objects on my layout for this 9x9 grid. I need to access information in TABLE1 for each of the cells that are represented in the 9x9 grid. For example, let's again assume that my Current_Location is B5 and by using TABLE2 I know the names of all the cells shown in the 9x9 grid (they are stored in a list in a field in TABLE2). How do I then get information about each of those 81 cells out of TABLE1. I.e., each of the 81 cells should be colored according to information in TABLE1. So, for the top-left cell in the 9x9 grid (which appears as the FIRST item in the list field in TABLE2), I need to be able to look up the color in TABLE1, and use it to drive Conditional Formatting of the cell. So if Color(B5)=3, then make the background color of the cell green. I can grab the cell name, and could easily write a script to figure out the color, but I need to *look up* the color to use it in Conditional Formatting. I was trying to generate another field somehow that was an analogous list of 81 items that showed the color of each of the 81 cells (in the correct order), but 1) I couldn't figure out how to do that without running a script (which would take too long since these things are changing frequently and I really just need a data lookup); and 2) I think there must be a much cleverer way. I am still very new to join tables, but I think the answer is in that arena somewhere. The other idea I had was trying to write a Custom Function since I can easily grab the name of the cell, B5. But I don't know how to create such a function since it needs to access a particular table and it seems like functions don't really work that way. Thanks in advance for any help!!
  18. Sorry... I replied to this once already, but I'm not sure why it didn't post. I don't understand this answer. Simply put, I have a graphic on the page that I'd like to pinch and zoom without going to another layout. It needs to stay in the same place and not spawn a bunch of other controls. Perhaps this is not possible? Thanks as always for any help.
  19. Hi All, please could you give some background? I am working in layout FactoryAllocations. I have a drop down with records from my ATA Table my second drop down is from the FactoryPrice, but I only want to see part with the same ATA as selected in the first drop down. I have my relationship, Factory Price and ATA tbl with relationship between ATAChapter I have created a second bable instance for FactoryPrice and linked to ATA - ATAChapter In my second drop down, I Use value from the FactoryPrice_ATA Tbl and only include values starting from ATA. Still I get all record and not filtered. Is my understanding of this incorrect?
  20. Yesterday
  21. Installing the plugin on FMS does not give you access to it in the FileMaker Pro script workspace regardless if the file you are accessing is hosted or not. This is the case for any FileMaker plugin. Installing on the server only makes the plugin available for scheduled scripts or scripts executed with the Perform Script on Server (PSOS) script step. This means that either your scripts will need to be executed as a schedule or with the PSOS script step unless you want to install the plugin on all user machines. As Josh said, in order to write the scripts, you will need to install the plugin in FileMaker Pro to have access to the functions. See this page for installation locations.
  22. To use the functions with FileMaker Pro Advanced on your local machine, you also need to install the plugin on your local machine. The server install only allows the FileMaker Server Script Engine to use the functions. And there is a separate location if you are using the plugins with Custom Web Publishing.
  23. I installed the plugin on the server, activated it from admin console but there is no way to get it work. I cannot write an email register step to activate the license as I Filemaker Pro does not provide me the 360 functions in the script/functions editor. How can I bring the plugin to life?
  24. RWoods: Yes! This helps immensely! I've tried this and it now works! Thank you so much for taking the time to make this file and help a newbie. (It took me a bit to understand that //... isn't part of the formula. Yes, I'm THAT new. Lol.) Apparently, I was way overcomplicating. (I wish there was (maybe there is and I just couldn't find it) a tutorial with multiple practice examples that one could learn from. Example.: Solve this problem: 'Using a checkbox, make a text field text color change from black to grey when the texbox is checked.' And then the answer on another page.)
  25. Hi Dellana Since you seem so new to all this, and may be approaching this the wrong way, I did you a little sample file so you can take a look at how it might be done. Hope it helps. Checkbox.fmp12
  26. WidgetStudio makes it easy to use, design and share powerful interface widgets, like calendars, gauges, charts, and timers. Pick from the constantly growing set of included widgets or build your own. Freely share them with your customers or friends. The post Announcing WidgetStudio – FileMaker WebViewer Widgets appeared first on Geist Interactive. View the full article
  27. No, not currently. I can see that this could be confusing. For clarification, a Java Runtime Environment is still required to run our plugins because they are written in Java. Our latest framework no longer requires that you install Java on your system. Rather, the plugin will download a sandboxed JRE that will only run when the plugin is enabled and does not require you to install it.
  1. Load more activity
  • Create New...

Important Information

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