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).
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.
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?
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.
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
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. Are Clients and Fans in the same table? My feeling is no, but I could be wrong 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.