Jump to content
Sign in to follow this  
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.

Sign in to follow this  

  • Similar Content

    • By Jhon Doe
      Hi, I hope you having a wonderful day,
      Currently I'm traying to create a dashboard with Filemaker, the idea is show several portals and grafics of differnets databases but with specific criterias. The case that i'm trying to resolve is the next one:
      There are three database related, one is for clients, another is the contract of this clients (services) and the last one is client's tickets, so we have the next relationships:
      tickets DB ------ Clients ------ Services  
      (I didn't create that DB distribution). The idea is show in the dashboard which tickets were created for clients who have certain services. The first thing i did was create a self join relationship of  Services to filter those clients who have the services i want to filter, next, i put this relationship into a portal in a layout based on the Services database and it works, but if i put into the portal a field related with the client's name, the portal doesn't match the results of the self join relationship whit the correct client, neither with the tickets that it supposed are related with the results of the self join relationships, how can I created a query in Filemaker taking into account more that one database? I made the  self-join in the manage/database/relationships menu.
    • By samarthmkt
      Hello Friends,
      As such any script which can close the popover portal when a certain field have value ''No'' and if ''Yes'' it remains open. 
       Popover portal is also open by script. Applying the following script steps but not succed
      Thanks

    • By john9210
      Can anyone describe how to set up a layout for center fed #10 envelopes?😠 FM help says that after creating the layout you must verify margins and other settings before printing. How do you do that? I've tried everything I can think of, but the script  print step prints 2 or 3 envelopes when the print dialog is set to 1 copy. I've tried adjusting the header and body dimensions (by guessing),  I've tried deleting the header and keeping the body, I've even tried just keeping the header. Everything looks normal in Preview.
    • By john9210
      This is a problem I frequently have. I can't custom format a date in the Inspector. I can't make a selection because the drop down menu becomes a long vertical blue stripe and selections are not available. I wonder if this is a FMP problem or a Windows 10 problem. Does any one else have the same problem?
    • By john9210
      I have a flat file database with only one table. However, I cannot not delete records. I get the error "This operation cannot be performed because one or more required related tables are missing".

      However, I can create records, just can't delete them. Obviously, I don't have a related table.
  • Who Viewed the Topic

    1 member has viewed this topic:
    JerrySalem 
×
×
  • Create New...

Important Information

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