Jump to content

Clayton King

Members
  • Posts

    14
  • Joined

  • Last visited

Profile Information

  • Slogan
    Work hard. Play Hard
  • Title
    So many things, but office administrator and musical performer are at the top
  • Gender
    Male
  • Location
    Columbia, SC
  • Interests
    Technology, learning, theatre, music

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    19

Platform Environment

  • OS Platform
    Windows
  • OS Version
    Windows 10 Pro

FileMaker Partner

  • Certification
    Not Certified

Recent Profile Visitors

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

Clayton King's Achievements

Apprentice

Apprentice (3/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges

0

Reputation

  1. I was just researching that. I'm on FM18 and would only use the solution on my computer, so not sure that would work for me. Thanks for responding!!!
  2. @comment, thank you so much! Silly mistake! My chart was set up exactly as yours was. To troubleshoot, I copied your chart into my layout and still encountered the same issue. But that led me to dig deeper and I discovered the Tempo field had erroneously gotten changed to a number field instead of text. It now works! I'm going to keep trying to play with the color issues, but this is exactly what I was attempting to do. Thanks for taking the time to put that together. I've learned a lot from this exercise! Clayton
  3. Thanks, @comment. I'm making progres! Below is a grab of the chart being generated. I'm not sure if this is the expected result, or if I didn't explain my desire well... Instead of each record in the portal showing as a slice, I'm trying to get all the songs of the same tempo to be a slice. So at most, I would ever have six slices - Ballad, Moderate, Downtempo, Freeform, Upbeat and Fast. Can you tell me what I've done wrong? As an added challenge, I have conditional formatting in other layouts that change the color of the portal record based on this field. Ideally, I'd like to use that color scheme in the pie slices. But that's also a pie-in-the-sky request (pun intended). Clayton This chart's Data Source has "Individual record data" selected. The one below has "Summarized groups of records" selected.
  4. Sorry to be dense... does the summary field go in the parent table or the portal table? And is the calculation count(Tempo) or something else? I have a few summary fields used for a variety of things (i.e, one for counting portal records in total, or by a couple of other options). Thanks!!!
  5. Hi everyone - I have a portal that consists of many rows - as few as 1 and as many as 50. In each portal record is a field called Tempo, which contains one of six values from a value list. I'd like to create a pie chart consisting of six (or less) slices based on the portal records. In other words, perhaps counting records with Tempo=X and using the result to chart. Is this possible?
  6. BACKGROUND I have a musical performance management solution (Gigs) which contains several tables including Gigs (performance dates, times, etc.), Songbook (information about an actual song performed), gigs_PERFORMANCES which joins the two, and other related tables. Two fields in the Songbook table are large text fields (Lyrics and Chart) which are the lyrics for a song and the guitar/piano chart for the song, respectively. Both can be long - particularly lyrics. Also a flag field indicating the presence of data in either field exists in the Songbook table. GOAL The objective is to print a lyrics book or charts book for a Gig or create a PDF of same (portal to gigs_PERFORMANCES provides the list). SITUATION Everything works fairly well at this point. In my print layout, I have Lyrics formatted as very, very large field (28" height) with shrinking set. The layout is sized to the same length so that part I went through several iterations to get the printout to paginate correctly. I now have one very strange issue and a pie-in-the-sky question. VERY STRANGE ISSUE There's a very weird issue which I've tested in several different Gigs records. On ONE particular Gig, the last two record's lyrics are combined. I don't know how to show this except to share this PDF screen capture of the last two lines of the song "Home" which is followed by the entire set of lyrics for the song "At Last." "At Last" should start a new page with a new updated header and page number. All previous pages are perfect. I have absolutely no idea where to start to troubleshoot this issue. PIE-IN-THE-SKY In the case of these fields, charts in particular, you can see that chords are displayed on the line above the lyric the go with. Thus, if possible, I'd like to always keep the lines together (i.e., no page break). This is also the case with lyrics where one might want a particular verse or phrase to always remain together to avoid breaks in illogical places in the lyric. Does anyone know of a way to "keep" text within a field together? I think it doesn't exist, but thought I would ask.
  7. I have a portal which display fields songs titles from related tables. One such field indicate the Genre of the song. I'd like the portal row to change color based on the Genre field. My current implementation has a text field containing a space and sized the same as the portal row with conditional formatting. While this basically works, I find it inelegant, plus, when editing the layout, it's another object to deal with. Suggestions?
  8. First, I appreciate any help I can get as this project has been evolving over two years and, as these kinds of projects to, has become more involved and complicated over that time. I've posted related questions, but exploring other parts of my project. As I'm not a programmer, but a sort of user nerd, my inquisitive mind wants to learn, but sometimes simple concepts elude me. Feedback, both on the specific goal at hand as well as the project overall is always appreciated. Performers is one piece of a much larger project, but I'm trying to enhance the project and working on a piece at a time. BACKGROUND I'm sharing the entire project layout to provide some insight into how the parts fit together. The application is a booking management tool for performers, consisting is several tables as shown: Again my focus right now is the Performers table and how to use it in relation to the Gigs (and Gigs~Songs_Join) tables. There is a Gigs layout which is the hub for performances by one or more Performers. On that layout is summary information about a gig and a portal which shows which songs were performed and in what order (Set & Slot fields). The portal also includes a Performer Name. The assumption at this point is that up to 4 performers will do a given gig. This might change in the future, and could impact the below goals. Gigs~Songs_JOIN is a connecting table for Gigs, Performers, Songbook, Venues, Musicians, etc. Performers is a table of singers and includes fields for a serialized SingerID, name, area of speciality (Tenor, Baritone, etc.), etc., and additional fields for combinations of the same performers including: Multi: checkbox-indicates this record is more than one performer PerformerName: calculated based on Multi: if NOT Multi, show performers Name, if Multi, show MultiName (below) Type: value list-is this a duet, trio, quarter, all, etc. MultiName: the description of this record (i.e., Duet-Clayton/Vicky) Other summary fields include: Total Gigs: count of gigs in which this person has performed Total Songs: count of songs this person has performed GigID: match field to Gigs~Songs_Join GOAL I have two goals, one related to the other. First, if the Performer record is checked Multi, I want to "attach" or "associate" individual singer(s) to the record (i.e., show what people are "included" in the MultiName). For example, MultiName=Duet-Clayton/Vicky, I want to show that Clayton and Vicky (each in separate records) are part of Duet-Clayton/Vicky. Second, ultimately on the Gigs layout, I want to show which Performer sang which song (currently works in the portal), but more importantly, show variable summary information (goal layout below) which changes for each Gig as to each Performer, how many songs they sang and the total amount of time they sang. The catch is, in the summary I don't want to show the Multi records, but instead increment individual singers. So, in the summary info with related portal records in the example below, rather than showing Clayton sang one song, Vicky sang one song and Duet:Clayton/Vicky sang one song, I want to show Clayton sang 2 songs and Vicky sang 2 songs. In summary info, Duet:Clayton/Vicky wouldn't appear. In other words, the summary would show how much time each person was singing. In the summary block of the Gig's layout, each of the above sets is a one-row portal filtered by set. I want to have the SINGER1,2,3,4 replaced with the actual Performer's name, and each band/portal show summary info for the appropriate singer. Here is my relationship graph:
  9. Comment, thanks for your help - it worked perfectly. Now I have a next level objective... Here is my current relationship graph and my previous Gig layout. When this was originally created, there were just two of us performing, so I had a Singer value list created which included Clayton, Vicky and duet (both of us). The "Set List Summary & Counts" section of the layout (circled) was done with summary counts and the headings (Set, Songs, Duration, Clayton, Vicky, Duet) are just text on the layout. Each row in the Set List Summary & Counts section is a one-row portal to the same layout (Gigs~Songs_Join) filtered for the Set number. The assumption is that a max of 4 sets would be performed, thus four rows. The bottom row in the section shows how many sets, songs, duration, and counts of songs by singer. Essentially I have several related tables that grab info into a join (Gigs~Songs_Join) table. Tables include: Gigs: Date/time, venue, producer, etc. I Songbook: song title, duration, keys, genre, lyrics, etc. Musicians: used in Songbook to include original artist, lyricist, composer, etc. Venues: address, contact for venue, etc., used in Gigs above WhoSang: List of singers The attached snapshot is of the existing layout. We now have additional singers, so I'd like the Set List Summary & Counts section to be more dynamic to account for multiple people. Recognizing a practical limit of how big this section can be, and assuming there never to be more than four singers, I'd like to heading in the section to be dynamically created and provide the same info as currently displayed. Rather than use a Singer value list as before, the WhoSang table includes the various combinations of people. Before, the Gigs~Songs_JOIN table had summary count fields for each of the three singers. Those are now gone since the singer is not actually a field in the JOIN table, but rather a field that looks up the SingerID in the WhoSang table. Ideally, I want is some kind of dynamic field(s) to populate the header row. In the case of duets (i.e., Clayton & Vicky), rather than show that as a duet for the purpose of the summary section, I'd like to increment Clayton and Vicky's counts. So if Clayton sings 3 songs, Vicky sings 4 songs, and they sing 3 duets together, Clayton's count would be 6 and Vicky's count would be 7. Also, if Lanny and Ella perform in a gig, they would (dynamically) appear in the section, with solo and duet counts handled the same way. I hope this is clear enough to provide some background, and appreciate any help given! I'm stuck at how to approach it.
  10. Now I'm feeling dense... I had the original count field in a one-row portal from the Roles table. You've just proved that sometimes things are much easier than we want to make them. Thanks so very much for your patience - Some difficult concepts I grasp quite easily, and some simple concepts elude me!
  11. Thanks for replying, Comment. SongID doesn't exist in the Musicians table - only in the Roles table (and obviously Songbook table). So I can't count SongID in the Musicians table - only in the Roles table where the MusicianID appears one or more times. I'm not sure I'm articulating the challenge properly, but happy to keep trying. I appreciate any help I can get.
  12. Similar to a previous post but different. My portal contains records where a musician (MusicianID) may have multiple entries based on participation on a song (SongID). My goal is for the song count (circled) to show how many songs this musician has 'touched' regardless of the role or involvement. In order words, in this example, the song "For Good" appears twice because the musician has two records for this song in the portal - one for Cover Artist and one for Comp/Lyricist. However, the song "For Good" should only get counted once in the summary field. The song count field is a summary field =Count of SongID in the related table. I'm sure this is a fairly simple exercise, but I'm going in circles.
  13. It's been a while since I developed a performance/singer set list application in FM18 and am revisiting it. I don't work in FM enough make my desired changes on my own, so asking for some help or directions. Essentially I have several related tables that grab info into a join (Gigs~Songs_Join) table. Tables include: Gigs: Date/time, venue, producer, etc. I Songbook: song title, duration, keys, genre, lyrics, etc. Musicians: used in Songbook to include original artist, lyricist, composer, etc. Venues: address, contact for venue, etc., used in Gigs above The attached snapshot is of the existing layout. When this was originally created, there were just two of us performing, so I had a Singer value list created which included Clayton, Vicky and duet (both of us). The "Set List Summary & Counts" section of the layout (circled) is done with summary counts and the headings (Set, Songs, Duration, Clayton, Vicky, Duet) are just text on the layout. Each row in the section is a portal to the same layout (Gigs~Songs_Join) filtered for the Set number at the bottom. The assumption is that a max of 4 sets would be performed, thus four rows. The bottom row in the section shows how many sets, songs, duration, and counts of songs by singer. We now have additional singers, so I'd like the section to be more dynamic to account for multiple people. Recognizing a practical limit of how big this section can be, and assuming there never to be more than four singers, I'd like to heading in the section to be dynamically created and provide the same info as currently displayed. I edited the Singer value list to include various combinations of people and realized that's not going to work for my goal. I think what I want is some kind of dynamic field(s) to populate the header row. In the case of duets (i.e., Clayton & Vicky), rather than show that as a duet for the purpose of the summary section, I'd like to increment Clayton and Vicky's counts. So if Clayton sings 3 songs, Vicky sings 4 songs, and they sing 3 duets together, Clayton's count would be 6 and Vicky's count would be 7. The Duet column would go away. Also, if Lanny and Ella perform in a gig, they would (dynamically) appear in the section, with solo and duet counts handled the same way. I hope this is clear enough to provide some background, and appreciate any help given!
×
×
  • Create New...

Important Information

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