Jump to content

stefangs

Members
  • Content Count

    373
  • Joined

  • Last visited

Community Reputation

0 Neutral

About stefangs

  • Rank
    member
  • Birthday 09/25/1959

Profile Information

  • Gender
    Not Telling
  • Location
    Germany

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    13 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    Mavericks

FileMaker Partner

  • Certification
    Not Certified

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Ah yes, that sounds simple enough. Thanks!
  2. Thanks for the demo. This works well, but of course it's not elegant having to select 'client' in a (to the user) unnecessary field before you can select a client. This is the complicated I tried. This worked sort of, but not when I asked to sort the value list by the second field and not show the first field in the 'Manage ValueLists' dialog. - Checking a category in the contacts table populates a calculation field with the category ID (I suppose this could also be literal text instead). Say clients are ID 1. So you check 'client', then that field contains 1. - A different table has globals for each category. The globals contain ID numbers, like 1=client, 2=staff. Create a relationship from each of these globals to the category field in contacts. - Create a value list for each category (all work the same, but have a different category). - Put contact ID field for the required category (e.g. clients) on the layout to popup a list of all clients, but don't show the IDs, only the names. - Overlay this field with a non-editable field of the client name.
  3. Hi all, In my contacts table, I have a check box field where the user can categorize any contact into three categories that are used in several places throughout the solution. So a contact may be in the 'client' or 'personnel' category. Ideally I would end up with three value lists that can be applied anywhere a contact needs to be entered. For example, when creating an invoice the contacts menu would pop up a list of only those contacts that have the 'client' checkbox set. I keep running into problems with globals not being indexable or the popup list showing the contact ID along with the name which I don't want. So obviously I'm approaching this wrong. Thanks for any help, Stefan
  4. That sounds like what Matt Petrowsky might be up to in this video: https://www.filemakermagazine.com/videos/creative-single-checkboxes Mind you, I haven't watched the subscribers part of it.
  5. Thanks again - you're completely correct. Overcomplicating things is actually an area I excel in! I will try both of your suggestions, but I also think that a filtered portal will be a good thing, since I eventually want to also filter by a user field (who is assigned to the task) as well. Didn't know about the GetAsBoolean function. I used to have a script attached to boolean check boxes like SetField (checkbox, not checkbox) Yeah, overcomplicating 😉
  6. A project would hardly ever have more than 50 steps, usually more like 30. I was actually trying to use the 'done' indirectly for the relationship like this: Projects table: If (filter_todo = 1; ID_project & "|" & 1; ID_project) Tasks table: If (done = 1; ID_project; ID_project & "|" & 1) The idea is that if the check box is unchecked, then the match fields would simply contain a duplicate of the primary key. I will have a go with portal filtering next. Thanks!
  7. I have a primary table 'Projects' connected to a child 'Tasks' table in a portal. In the child records, there is a check box labeled 'done' to mark off completed steps. In the Projects table, I also have a check box labeled 'Show to do'. When clicked, the idea is to update the portal with only those records that don't have the 'done' box checked. Unchecking would show all tasks again. I have experimented with all kinds of calculated key fields, but the way I see it, I cannot generate the proper key on the child side without looking at the status of the parent side. At that point, however, I can't index the field any longer and so it doesn't work. Any ideas? Thanks!
  8. In trying to fix a non-refreshing portal in my FMA 13, I also stumbled on Daniel Woods original article "Ditch those Flush Caches, Use Cartesian Join Instead!" at https://www.teamdf.com/blogs/ditch-those-flush-caches-use-cartesian-join-instead In his follow-up article, he mentions that one of the issues with this method is that the cartesian relationship does not allow for records to be created on the portal. Also it's a hack to be creating a field just for refreshing purposes. But while we're hacking, why not hack some more and introduce another field in the child table. Both Refresh_1 fields auto-enter 1 in their respective tables. What do you think about this: Parent_ID = Child_ID and Refresh_1 = Refresh=1 So refreshing now works as well as adding new records in the portal. I know it's a hack for an older version, but since it's the one I'm using right now, it would be interesting to know if perhaps I didn't foresee some completely different problem down the road. Stefan
  9. In addition to the FM tab interface, I also use tabs that looks similar but actually move to different layouts (so that the table focus can change). Is there an easy way (in FM 13) to have the tab buttons change color just like the built-in tabs using a conditional format? Thanks, Stefan
  10. Thanks Wim, actually I don't care which way as long as I can access the data. I thought it might work with GO, but if it doesn't then GO isn't as great as I thought it was. Buying FMS just to access a file is overkill for me. So, as disappointing as the answer is, I'm glad I know and I don't have to dig any further. I probably end up having a copy of the file on my phone and use GO anyway, then update the two files every so often - hassle.... Thanks, Stefan
  11. I'm not a noob at FM, but never did anything on the web with it. I'd like to put a FM file on a web space (like where my homepage is) and access that with my desktop or my phone. This is only personal data used only by me. Searching turns up a lot of info on hosting services, FMS, and stuff I don't understand. In the manual I found what sounded right (using an URL) but I couldn't get it to work. Are there any step-by-step instructions on how to accomplish this? Thanks, Stefan
  12. Just a push really... anyone want to try my template and comment on it? Ideas for improving it? Would be happy to get some feedback! Thanks, Stefan
  13. I'll come back to this line in 2018 It is seriously above my level, but I'm happy to have something to chew on! Thanks, Stefan
  14. Ok, so I put together a template that shows one strategy of going about my localization project. I have included the dialog boxes also, just to show you that part, too. I have used global variables to store the strings which would require an intial script to populate them. This isn't included in the template. Hope that some of you can take a minute to check this out. It works, but I don't know how clunky it will get once I add probably about 100 dialogs and perhaps 200 field labels. @comment: I'd be curious to hear your comments, mostly because I don't quite see the advantage of the variables vs. global fields. Thanks, Stefan Language_demo.zip
  15. Yes, I missed that at first. Thanks for pointing it out.
×
×
  • Create New...

Important Information

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