Jump to content
faaslave

fmp17 FM solution design questions

Recommended Posts

Band Solution Design

 

I am trying to create a filemaker solution for my band. I have been unable to find a pre-made solution that does everything I want, so I am going to try and create my own using filemaker. I am looking for advice on what tables and structure I should use, before I start.

 

Entities

 

  • Band Members - I need contact info and a history of money I have paid them from any gigs

 

  • Clients - People that hire us for gigs. I need to send them a press kit in hopes of getting hired. Invoice them, and send a receipt.

 

  • Fans - Marketing to these people , email, text, social media, etc. Can a fan also be a client? Yes, but it is pretty rare. I am thinking if a fan happens to be a client as well, they should probably be in both tables. I am not 100% on whether or not Fans and clients can be in the same table

 

  • Assets - An inventory of our equipment owned for tracking and insurance purposes

 

  • Merchandise - We sell shirts, hoodies, hats, etc, at our gigs.

 

  • Invoice - We need to be able to invoice our merchandise and invoice our clients for our services (Performing gigs) Our merchandise is sold by us and has nothing to do with the clients.

 

  • Songs - A table to keep info on all songs we play. Containers with pdf’s, mp3’s, song information, etc. This info will be shared with band members through email. Build reports to show clients what songs we play.

 

  • Calendar - Track gigs and practices and band member availability. Hopefully I can have the calendar sync the gigs to an external calendar on our websites. Any other information, would be for band members only. Practices and availability should not be seen on any external calendars. Band members should be able to log in and block dates they are not available so I know when I can’t schedule a gig.

 

Main questions from this are

 

  1. Should our services and merchandise we sell be in the same table? On a side not, the price of our services is not a set price but negotiated for every gig. There are too many variables to be able to have a set price advertised. In other words, I can’t have, “2 hours of music for $500”. One gig might be 10 minutes away, require none of our sound equipment, while another is an hour away, requires us to bring everything, and members need a hotel for night. So every gig fee is negotiated.
  2. Are Clients and Fans in the same table? My feeling is no, but I could be wrong
  3. The Calendar table. Band members need to see everything on this, and be able to block dates. The gigs listed on this table should sync with external calendars on our website, etc. I am not even sure Filemaker can handle this kind of calendar application, but if so, why not try?

 

Any advice is greatly appreciated.

Thanks,

 

Dave

Share this post


Link to post
Share on other sites
1 hour ago, faaslave said:

 

  1. Should our services and merchandise we sell be in the same table? On a side not, the price of our services is not a set price but negotiated for every gig. There are too many variables to be able to have a set price advertised. In other words, I can’t have, “2 hours of music for $500”. One gig might be 10 minutes away, require none of our sound equipment, while another is an hour away, requires us to bring everything, and members need a hotel for night. So every gig fee is negotiated.
  2. Are Clients and Fans in the same table? My feeling is no, but I could be wrong
  3. The Calendar table. Band members need to see everything on this, and be able to block dates. The gigs listed on this table should sync with external calendars on our website, etc. I am not even sure Filemaker can handle this kind of calendar application, but if so, why not try?

 

1. You could have one table for products and services it will contain the unique id for that item and it's default rates. On the line items you can summarize the products from services. Based on carefully construction of logic you could possibly create known packages that would include products and services so that you wouldn't have to add individual items, but a group of known items that might be required to be purchased together. (ie: Wedding Gigs, vs Prom Gigs )

2. This is a bigger discussion but you could implement a Party/Role model relationship where all the "People" are in the party table and that would include, Clients, Fans, Band Members, Roadies, Groupies, Venue Contacts, etc. They would have a join table that would define that persons role, and a subtype table for a given entity's attributes. Data Modeling

3. Perhaps try not to reinvent the wheel trying to display calendar data in FMP is not trivial, the data can reside there but you may consider publishing it by using one of the many third party tools ( DayBack, or SoSimpleCalendar

 

Share this post


Link to post
Share on other sites

Thanks Stephen. I just watched the video. I haven't touched Filemaker since my last project using 11. I bought 17, and low and behold, you can finally have multiple attachments to an email. Now it's time to start getting familiar again. At least it is for my own project this time. I want this solution to have a mobile platform for the band members. Oh boy, here we go again.

Share this post


Link to post
Share on other sites

Maybe from a financial/labor standpoint, it might be better to use something that already exist. I just "Googled" searched, found this product, did a rough browse of site. Looks feature packed and web-based.

http://www.bandhelper.com

Good luck!

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Similar Content

    • By john9210
      I can't get find a range of dates with a script. The following script is supposed to find the last 12 records on the layout. The Perform Find results in the error that the provided find criteria is not correct. Even if I use Enter Find Mode and insert the variables, I get the same error. What gives?
       
      Layout [ “Log” ]

      Show All Records

      Sort Records [ Keep records in sorted order; Specified Sort Order: Log::Date; ascending ] [ Restore; No dialog ]

      Go to Record/Request/Page [ Last ]

      Set Variable [ $End; Value:Log::Date ]

      Set Variable [ $start; Value:$end-12 ]

      Perform Find [ Specified Find Requests: Find Records; Criteria: Log::Date: “$start...$end” ] [ Restore ]



      //Enter Find Mode [ ]

      //Set Field [ Log::Date; $start...$end ]

      //Perform Find
    • By DreadDamsel
      Hi.
      I have a database that lists grant applications.
      I need for my user to be able to view the records in a number of ways according to certain criteria for analysis purposes. These records are displayed in a List layout.
      I need to be able to:
      1) see only records where the submission dates are between x and y
      then
      2)  filter these records according to what is selected in  2 dropdowns - Outcome and Status. The Outcome field dropdown value list is : <blank>, granted, unsuccessful, unknown. The Status field is  dropdown value list is: <blank>,submitted, in progress, finalised. The <blank> is where that dropdown criteria are not required.
      Ideally, I'd like to be able to set the dates, select from the dropdowns and perform the find, but happy to do it in 2 steps if necessary.
      I've tried several things from solutions found searching the internet, but nothing seems to work and I'm getting increasingly frustrated with it. I'm not a coder and anyone good enough to help me out here needs to be aware of this. While I've been using FM on and off for a number of years, I'm by no means an expert or even near it.
      Thank  you in advance for any guidance with this. You guys have helped me out in the past.
    • By Bikeman17
      Does anyone know about a plug-in for Sales Force?
    • By Pedro8000
      Hi there - I need to create a simple crosstab report and wondered if filemaker 17 has this functionality built in ? If not can somebody point me in the right direction on this please. It would be very much appreciated. 
      Also once ive created a series of reports how can i combine them so they appear at the press of a button in a single document ?
      Any help would be much appreciated.
       
      Peter
       
       
    • By Blaze
      I have a runtime solution that was created in FMP 12. This no longer works on High Sierra or Mojave. 
      My iMac just gave up the ghost , but Mojave would not have run on that machine anyway.
      So Instead of sinking money into a new Mac, I am looking to see if there is anyone here on the forum that I could hire to render the runtime for Mojave (from the previous fmp12 file), do a simple runthrough to verify that everything works well and then create an installer package/DMG to get me (and my customers) back up and running. Thanks for your time and consideration!on in this matter
       
×
×
  • Create New...

Important Information

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