Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About ratherbsailing

  • Rank

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
  1. Thanks for all this, Comment! I did end up figuring out the SQL within a script, which was quite clean within a popover. Your clarification really helped. However, after that I decided that I'd want to be able to click on that info and go to the related record on another layout... so I ended up making a portal how you described above. It's still relatively clean and gives me the additional formatting options that portals provide. Thanks again for your assistance !
  2. It sounds like using SQL is the way to go, since I'd love to avoid adding more TO's with more TO's tacked on... etc. That being said, it sounds like I need to move on from using a portal to display the info and actually just use a new field? SQL is completely new to me, so I'm just working off what I've researched today. It sounds like what you're describing is adding a new field that would be an auto-enter calculation using an ExecuteSQL() function, and I could display that field (list?) either below the main Portal where I've selected a person, or as a popover? (The popover is a great
  3. Basically the setup is as follows: 3 Tables: People, Join-PeopleTask, and Tasks The Join-Table relationships are working well to manage individual people attached to a Task. Adding new Tasks happens in a Form Layout based on the Tasks Table. It shows a detail view of each Task and then the people attached to it (in a portal). We are curious if we can add a way to click on (select) a person from this portal and based on that selection, have another portal below display what other tasks that person is attached to. Logically, if we click off the portal ("no selection"), we'd like that p
  4. Brilliant. Aha! Multiple Single-Row Portals, essentially turning off all of the Fill & Line attributes, should give me lots of flexibility to mess with the fields I do want individually. That's a step in the right direction, for sure. @comment Thanks for your solution as well! I will try them both out and any other suggestions that come in. Your List() using tab characters might be the easiest to manage everything at once. Understandably so, and thanks for pointing that out. I will say that if you had the full context, it would make more sense as to why they do it that
  5. As a new user, even the basic structure of a solution seems to have hundreds of options for getting started. I'm hoping someone can enlighten me on how to achieve the following: I have a Main Menu layout that works off of a "Main Menu" Table. I have a "Team Contacts" table and layout that shows the 5-8 people that are working on a given project. There are simple fields in this table: Role, FullName, Cell #, Email. Due to the nature of these projects, sometimes additional specialists are required (and are temporarily brought on for different tasks). This is why I set up the "Team Contacts"
  • Create New...

Important Information

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