Jump to content


Popular Content

Showing content with the highest reputation since 04/22/2017 in all areas

  1. 1 point
    Glad to help. Step back and think data model before diving in always helps. Build a solid foundation.
  2. 1 point
    I've asked my fair share of questions and received tons of help on the forums. But in this case, with an inventory tracking database, bar codes, multiple users (server?), syncing data-it's quite complicated. If it were me, I would consider looking for a FileMaker developer to, at the very least, set this up to get the ball rolling. Proper fields/calculations & relationships are a must. You could spend a huge amount of time going down the wrong path, only to have to start over. I'm not saying you couldn't figure it out, with some help here, and everything will be fine. I'm saying I would at least want the initial (proper) structure set up, and know it's correct.
  3. 1 point
    One more thing I've noticed ... Your Services and Rent History tables do not appear to have a unique ID. You really should have one in every table. If you ever lost your data or had to restore, you would use this unique ID to update/correct or replace the records. It's more than just used for a relational key. Without knowing your business quite a bit more, I am only guessing here but I would consider the RentalHistory more the 'contract period'. If rent can change over time, the rental agreement on the monthly charge would be in Rental History ... charge THIS Tenant THIS much for THIS property for this timeframe. Your Invoices should be related to this RentalHistory table as: 'this invoice is charged to this tenant during this rental agreement for this property. I guess that was two things, LOL.
  4. 1 point
    Even better = BE_RegularExpression ( "AlphaBravoÇharlie" ; "(\p{Ll})(\p{Lu})" ; "g" ; "$1 $2” ) returns: "Alpha Bravo Çharlie" Basically, this looks for a lowercase character (excluding punctuation and digits) followed by an uppercase one, and inserts a space between them.
  5. 1 point
    Cross-post with https://community.filemaker.com/thread/175457 (It's ok to cross-post but it is good form to indicate your post as such since a lot of the people on both forums are the same)
  6. 1 point
    If you just want to "highlight" your search result, you could just add Conditional Formatting to your fields, so if they match what you entered in QuickFind they will be highlighted. Of course, then you want to replace QuiCkFind with a scripted QuickFind so you can temporarily store your search criteria. 360Works' Scribe plug-in also does highlighting text.
  7. 1 point
    I can't figure out what your question is. What is "a calculated list field"? And what exactly does "filtering by a calculated list field" mean? You speak of filtering portals, but then you say "My usual technique is to do by relationship" which makes no sense to me. Most often you filter a portal in order to avoid adding a relationship. Why don't you back up a bit and explain what you're trying to accomplish here, not how.
  8. 1 point
    As an aside; look into using sparse image bundles when installing trial or pre-release software: http://blog.fosketts.net/2015/07/22/how-to-use-mac-os-x-sparse-bundle-disk-images/ cleanup is as simple as just throwing away the image if you don't need it anymore.
  9. 1 point
    Define a calculation field (result is Text) = List ( ProductName ; "All" ) and base your value list on that. You may want to prepend a space to " All", in order to force it to the top of the list.
  10. 1 point
    another option... 24u Software Phidgets Plugin
This leaderboard is set to Los Angeles/GMT-07:00

Important Information

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