This topic is 2093 days old. Please don't post here. Open a new topic instead.
A friend asked if I could help with a Reservations App for her new Camp/Caravan site, it only has 5 van pitches and 10 tent pitches. I couldn't find a free one and as this is her first steps did not want to recommend a big spend solution for something that would only be used as a standalone on a MacBook.
So I struggled for a week or two with FileMaker, and the great help from the Forum questions and solutions.
So thanks everyone, you have helped a newbie make something that seems to work.
I guess that I have done everything wrong/badly but I eventually enjoyed the experience.
This is where I step away, if you find it in anyway useful as a learning experience or whatever then that's enough.
(Oh you may want to change the archive/backup folders referenced as I pointed those at a Box Sync folder.)
I'm just incredibly impressed with this program. I have no formal programming experience, although I dabbled a long long while ago. After hiring a paralegal earlier this year, it became clear that managing our legal docket in a spreadsheet was no longer viable.
The sum total of FM training I did was watch the 8 minute tutorial on the video. Then I got to work. There's a lot of DB relationships going on (each of my corporate clients organizes things a bit differently), and I wanted functionality like sending emails from FM, and opening third party programs (PathFinder, TotalFinder) using the solution (with an assist via AppleScript).
Today it's basically done. I want to go through the layouts again and make sure some validation rules are set up, but everything works perfectly. I'm happy; my paralegal is perhaps happier.
I even had enough time to add a "show a minion" button (click on it, and it shows a minion from Despicable Me), because every legal docketing solution needs such a button.
im a new user and have been pulling my hair out for a week trying to accomplish what i feel should be a simple task. i am hoping someone can point me in the right direction before i go bald…well, balder.
i co-teach several different classes at several different schools with several different teachers. i have set-up two tables, a “schedule” which will tell me my daily classes and lesson plans, and a “schools” table that contains the names of the schools, the classes i teach at each, and their respective teachers. they are related by the school.
in the “schedule” table, when i select the class for each period (which is a generated value list based off the school I've previously selected) i would like the associated teacher for the class i select to be auto-entered in another field. This would be the same value that would display if, under value list options, i were to choose “also display value from second field” and select the “teacher” field i have set up in the related “schools.” for formatting reasons i would like this data in a separate field.
a lookup by “schools::teacher” simply produces the first teacher listed for each school. i am guessing i need to do a calculation, but i can’t seem to find a function that would let me get the teachers field value based off the class field value. is this more than not knowing the correct function to call? do i have my relationships set up wrong? do i need another table? a 'join' table? any advice would be greatly appreciated.
I've been lurking around the forums for a while now looking at various topics regarding database schema for Survey applications.
However, despite the insight and templates posted on this forum I still cannot get my head round how to create a relational database for my application.
Here's the scenario: I need to create a health and safety inspection application which will enable the user to carry out a survey of how well a specific location fares against a bunch of pre-set questions/criteria. So pretty much a checklist where each question is either a pass or fail response. Currently the survey is paper based (I have attached an example to this post)
As I understand it from other forum posts, the basic schema of a survey should be Subjects (in my case Locations) --> Responses <-- Questions <--Surveys
But I need to have different Sections for Questions as well and i'm having trouble incorporating another table into my schema.
Please find the attached zip file with the schema I have so far and PDF of the current paper version of what I am trying to accomplish. Could anyone tell me if i'm going in the right direction with this? (is the schema okay?) I have hit a brick wall and been stuck at this point for a while now!
H&S report Paper.pdf
As you can see, my first post here. I'd very much appreciate a bit of input to a couple of questions I have regading FM Pro platform as I take the plunge to purchase FM13 Pro Advanced. I'm not a total newbie to Filemaker having used it some years ago, but I've a lot of catching up to do.
1) In developing a runtime solution can I serve that solution from FM Pro server? Having read docs I'm still not clear in my mind if the database files that are packaged in a runtime can only be local to the solution. What I'd like to do is effectivly create a shell solution which can open the database from a remote server. Then any changes I make to the database will propogate to all users.
2) I'm looking at a couple of hosting providers - quite drawn to http://www.filemakerhostingpros.com as they have a UK based server. Anyone have postivie/negative experience with this company. Noticed they advertise unlimited connections and webdirect which will be critical to some of the solutions I have planned.
Thank you in advance for your time. I'm looking forward to getting back in to Filemaker development, I did download the trail but then had heavy work commitments so only managed to get a few days hands on - doh! Also can't wait for the day we can make runtime solutions for iOS with Filemaker Go Advanced
Who Viewed the Topic