Jump to content
The site is updated on a beta version. Maintenance tasks are running so search and index may not function at this time. ×
  • 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. Past hour
  2. I could not possibly answer such a wide question in a forum post. I suggest you read the help to understand what each of these does and if you encounter a specific question or problem, ask here. I will give you one hint, though: Perform Find[] is the generic way to find records; both Find Matching Records[] and Perform Quick Find[] are shortcuts for specific situations.
  3. 1. Find Matching Records Looks for all values in that selected field for matching record with the contents of that field 2. Perform Find Executes the perform find after entering find mode or by criterion entered in the dialog 3. Perform Quick Find Searches all fields on the layout local or related for a value entered ( same as using the search box in the upper right corner of the window)
  4. thanks! In the meantime, what's the difference between: 1. find matching records 2. perform find 3. perform quick find
  5. Today
  6. To find all records that have "Phone" in the Category field, do: Enter Find Mode [] Set Field [ YourTable::Category; "Phone" ] Perform Find [] To find records in the current found set that have "Apple" in the Producer field, do: Enter Find Mode [] Set Field [ YourTable::Producer; "Apple" ] Constrain Found Set [] If you want, you can reduce each of these scripts to a single step by storing the find request within the Perform Find / Constrain Found Set step. As already noted above, you can find all records that have "Phone" in the Category field AND "Apple" in the Producer fi
  7. I want to find all Phones (from the Category field) and further narrow down to Apple phones. And I need two separate buttons for this purpose.
  8. so are you looking for Phone numbers? or record that have a category "Phones" ? If its the latter you its a simple AND type find enter "Phones" in the category field and enter "Apple" in the producer field you should have a found set of only that criteria.
  9. "phones" belong to Category field "Apple" belongs to Producer field
  10. It is a little unclear what it is you're asking where are the "phones" located in one field, multiple fields, in a dedicated table? could you explain further your use case.
  11. Gents, I am a bit confused with Find and Search functions in FM. I need two buttons: 1 - find all Phones from DB 2 - find among those phones an Apple items What functions I have to apply in this case?
  12. Ahhh, the panacea of being able to improve my FileMaker database offline, then simply applying all the dev changes to the live production file. This is the great promise of the new FMUpgradeTool. It was released along with FileMaker 19 and it's a bit hard to dig into. Unless, you have the time like I did. Fortunately, I'm going to save you the many hours of slogging through the documentation and the trial-n-error which comes with learning any new tech. In this video, I spend an ample amount of time covering the FMUpgradeTool and how it might impact us in the future. I'd gather that, like Add
  13. Ahhh, the panacea of being able to improve my FileMaker database offline, then simply applying all the dev changes to the live production file. This is the great promise of the new FMUpgradeTool. It was released along with FileMaker 19 and it's a bit hard to dig into. Unless, you have the time like I did. Fortunately, I'm going to save you the many hours of slogging through the documentation and the trial-n-error which comes with learning any new tech. In this video, I spend an ample amount of time covering the FMUpgradeTool and how it might impact us in the future. I'd gather that, like Add
  14. When i choose script workspace from the drop down menu, the display does not show on the screen. It shows that a window is open but there is no display. It happened once before and re-booting fixed it but not this time. Any ideas on what it could be? Thanks.
  15. How often do you need to do this?
  16. Thanks works like a charm, now i have to deal with a speed issue, since i end up having over 3 Million records on this table alone. Thank Jay
  17. Yesterday
  18. Hi Mike, It seems that your sample file does not work with FM17. Can you please have a look ? Thank you
  19. No, I don't think so. Operations will often (if not always) force casting into the type expected by the operation, regardless of the originating field's type.
  20. That's right, but operations on the data in a field very often will force casting into underlying field's data type. Which is why it is often important to know the field's data type so that you know what it is supposed to be.
  21. I hate to continue this, but: Field type is not data type. As you yourself said, Filemaker permits inputting the wrong data type into fields.
  22. If it is a field: by querying the FileMaker_Fields metatable with executeSql(), or by using the FieldType() design function. If it is a variable: you can't. Much like other environments where you declare a variable 'untyped' by doing something like 'var myVariable', FM works the same. Except that you don't have a TypeOf() equivalent. As a developer you need to know what you put in the variable. When in doubt just use the right GetAs...() function.
  23. Last week
  24. With a plugin. Please stop hijacking this thread.
  25. Interesting, how can I retrieve the data type from the object?
  26. Hmm, you're the second person to tell me the same thing in the last 12 hours. So it must be some magic touch that I have ...😉
  27. When you say we can use a global field , I have tried this in the past and not been successful. I will try again if you think it should work. Yes this just runs on my desktop, it is not hosted. Hey, that works! Huzzah! Funny that it has not worked for me in the past, I can't think of what I was doing differently. Many thanks for your assistance.
  1. Load more activity
×
×
  • Create New...

Important Information

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