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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • By Dellana
      I am using Filemaker Pro 17.  I have created a container field with 'interactive content (PDF, MP3, etc.)' checked in the Data tab in the Inspector. PDF's won't upload.    I've uninstalled and reinstalled Adobe Reader DC.  I've tried other PDF files and they just won't load.  What am I doing wrong?  (I've done is successfully in the past with Filemaker 15 with the exact same PDF files).  I'm using a MacBook Pro with MacOS Mojave Version 10.14.2 (18C54).
    • By Lola
      Hello All,
       
      The attached file is the simulation of my excel worksheets. I have three (3) accounts Admin, John & Lola all the three (3) accounts has no password.
       
      In my layout "ReportsEquipmentTime",  I want that If I click the "project x equipment" button I will see only the record of the current account that is login.
       
      The script that Im using is
      Set Error Capture [on]
      Allow User abort [off]
      Set variable[$_columns; Value: ValueListItems ( Get(FileName) ; "Equipment" )]
      Set variable[$_rows; Value: ValueListItems ( Get(FileName) ; "ProjectCode" )]
       
      Set Field[Users::RELOGIN; Get(AccountName)
      Enter Find Mode [Pause: off]
      Set Field [DailyReports::CreatedBy;
      Set Error Capture [on]
      Perform Find []
      Go to layout ["ReportsEqipmentTime" (ReportsEquipmentTime; Animation: None]
       
      Set Field [ReportsEquipmentTime::_Column Headers; $_columns]
      Set Field [ReportsEquipmentTime::_Column Source; "EquipmentUsed"]
      Set Field [ReportsEquipmentTime::_Row Headers; $_rows]
      Set Field [ReportsEquipmentTime::_Row Source; "ProjectCode"]
      Commit Records / Request [With dialog: off]
      Please see attached File.
       
      Thank you
      Lola
       
      Hours.fmp12
    • By Asu
      A google search reveals that FMP not recognizing modifier keys is at least a decade old problem. It's hard to resist making some kind of a comment but I will resist. At any rate, it seems that restarting the computer, at least on a Mac, resolves the problem, (until it pops up again). 
      My question is this: Is it understood what is it in the restarting process that corrects the problem, and if it is, is it something that can be imitated with some kind of script, command, etc?
      Thanks
    • By andrewf
      I used to be able to host a limited number of clients with FMP. With FM17 it now says "The host's capacity was exceeded, try again later." and the file shows 0 clients connected.
      Is the only way around this to get FMP server?
    • By Asu
      Hello -- I would like to open pdf files that are stored in a secure external manner. 
      Only the first page of multipage files show in a FM container window (if I';m not mistaken) so I am wondering about using Preview (Mac, of course). I can retrieve the file path to the secure file by processing the text output of the container file, and then use it as a variable filename in a Send Event script step,  but Preview cannot open it.
      Any suggestions?
×

Important Information

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