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!


    fmf AD.jpg



All Activity

This stream auto-updates     

  1. Today
  2. Good question... I have a window acting as a kind of launcher with buttons. It's only 100 pixels wide. Some of the buttons have popup windows that in turn open a card window that is much larger. Since a new card window is based on the parent, I've done some convoluted math to make sure it appears on the screen near the main window. The problem is, if the user moves the main window, the card may end up off the screen with no way to interact with it. That's why I want to move the main window back to its original location if they move it. I have set a script step that moves the main window when the card window is opened, but that doesn't prevent them from moving it after the card appears.
  3. "it didn't work" doesn't tell us much so you have to be a lot more explicit about what you tried and what the result is and what you expected. Otherwise we're just guessing. Provided that the relationship for the portal is just driven off the single "customerID" predicate then your script will properly create a new related record that will show in the portal. Can you confirm that this part is working? If you want the field "PRV RDG" to be be filled on that new record, with the value from the last related record then you have to capture that value at the start of the script and then set it in the proper field after creating the new record.
  4. See if this helps: https://fmforums.com/topic/105273-searching-related-data-with-and/?do=findComment&comment=476391
  5. Hi. (If somebody feels this question needs to be moved to another section, please advise - I couldn't make it "fit" anywhere else) I have a table with several items in it. One of the fields is "order_num" (a number), the other field is text. What I am looking to do is be able to reorder that list based on the number - which can change. But wait for it... I want to be able to reorder that list with either a increment and decrement button, where clicking them would either increase the order_num number or decrease its position in the list. A script trigger could then re-sort that list based on the new numbers in that list. What I am not sure how to do is increment or decrement the number but not make it the same as any other number. For example: If I have three records where the numbers (in order are "1", "2" and "3"). If I wanted to move the second record to the top of the (ordered) list by making it "1", it would then have the same value as the first record (1,1,3). I would like to do something like decrement every number below it so that there were only unique numbers and the list could be re-sorted. This seems clumsy to me, so figure there must be a more elegant solution. Ideally, I was hoping to have it so I could either use the increment [in list] or decrement in list, or be able to drag the items to a new location in the list - like "between" others. I've sort of had this working with container fields, but never in list re-ordering. Has anybody got any ideas how I could achieve this please? Any suggestions welcome. Many thanks in advance. Greg
  6. this is the code in this layout that will add new data when I click Add Bill. Set Variable [$CustomerID;Value Transaction::CustomersID] Go to Layout["Add_Billing"(Transaction);] New Record/Request Set Field[Transaction::CustomersId;$CustomerID] Go to Field[Transaction::Month]
  7. tried it from the other layout and its the way what i wanted to..but when i tried on this layout it didn't work.
  8. I would appreciate some help if anyone knows how to solve this. I have a database with three tables. The first is a Recipe table, with fields RecipeID, RecipeName, etc. The second is an Ingredient table, with fields of IngredientD, IngredientName, etc. The third is a RecipeIngredient table that joins the above tables together, with fields of RecipeIngredientID, RecipeID that links to the Recipe table, IngredientID that links to the Ingredient table, Amount, etc. The three tables form a typical many-to-many relationship. I have been trying to figure out how to find a recipe that contains two specific ingredients. For example, I tried the Criteria “RecipeIngredient::Ingredient: [Carrot] AND RecipeIngredient::Ingredient[2]: [Potato], but it didn’t work. Any suggestions? Thanks in advance!
  9. This is the first I’ve heard such a request. What’s the use case? Why do you care that the user moved the window?
  10. Yesterday
  11. I'm pretty sure the answer is no, but is there a way to capture the position of a window so that I can do a script that will snap it back to its original position when a user moves it? As far as I know, there are no script triggers that can run when a window is moved, just changed (dimension, mode, etc.)
  12. That could be achieved by hiding the summary field conditionally. True, having the calculation field has the advantage of placing all the required logic in one place. But I also like to eliminate fields as much as possible.
  13. True. However, if I put the calculation field into his data table, then he gets a really good visual representation of when his actual data stops. It neatens things up a treat in that list view.
  14. Come to think of it, you don't need the calculation field. You can perform the same calculation within the chart itself.
  15. You are correct, sir! Thanks very much! Simple and elegant! I will need to remember this one for other purposes!
  16. Well, then I believe my suggestion will work (much to my surprise, I should add).
  17. What he wants, when there's no new amounts in the AC_KTR field (ie, there's no data in that field), for there to be no new amounts in the ACWP summary field (no data to be graphed). So that the graph just stops. What he's trying to do is graph four different running totals of four different data sets, each consisting of a monthly cost and a monthly running total. One of them is a predicted set (what he expects to see, I didn't show that data), the second is the predictions from his contractors, the third is the actual set (the two columns I showed) and the fourth would be a revised prediction. The actual amounts and running totals have the potential to end before the predicted set of records end, and the revised predictions would continue from where the actuals left off. Here's the full sample data set he gave me (out of Excel), that I've imported into FileMaker Would it be easier to do in Excel? Yes.... But he has a whole raft of other analysis he wants to do that he wants to have in FileMaker, where he is currently tracking the progress of 50-some different projects (budgets, correspondence, contacts, expenses and funding, you name it, we're tracking it), so having this in there would make it pretty seamless.
  18. I was suggesting you NOT wrap $layout in quotes. That would be a common mistake. Did you view Comment's file? I suggest you take a look. You can drop all that extra stuff. hahah! We all posted simultaneously! Don't say we aren't quick at assisting folks here on FMForums! 🙂
  19. OK. Well, LaRetta got me to thinking ... "surely I wouldn't need quotes?" So I decided to try it with quotes anyway. As a result I could see in dataviewer that there was a space after the last letter of the $Layout value. So I learned the MiddleValues function included the carriage return as well as the value. I fixed with the following and now all is great! Thanks to you both. Steve
  20. Information that would enable us to reproduce your problem. LaRetta suggested an excellent way to do that. What you have provided so far is insufficient, as you can see in the attached file. Unless the file doesn't work for you - which would mean you have a problem in your system. Test.fmp12
  21. Technically, you could define a calculation field along the lines of: If ( Amount ; sRunningTotal ) Whether this will fit your purpose is hard to say, because I don"t understand your purpose. You say; What does he want to get - and why? In my understanding, a flat line is the correct representation of a running total when there are no new amounts.
  22. Well, I'm happy to provide more information; just not sure what that information would be. I'm setting a local variable "$Layout" with the value of the layout name to which I need to navigate. In this case the layout name is "PD_085". That's exactly the name of the layout. When the script step Go To Layout (layout name by calculation) executes I receive an error "105: Layout is missing". But the layout is there. This happens with every layout I try. Any thoughts? Steve Shiver HI LarRetta! I am NOT wrapping quotes around $Layout. Should I be wrapping quotes around the value that inside $Layout? BTW (my middle name is Rhett):) here's the script
  1. Load more activity
  • Create New...

Important Information

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