Leaderboard

Hey John! If you mean the old Music Library, I happen to have it (attached). Music Library.fmp12

Your synopsis layout is based on Cabinet Library. Shouldn't you be using the 'Total Minutes for Door' field from Cabinet Library?

Just from what I have seen from support, a lot of users just use the CloudMail.fmp12 file or they copy/paste the scripts into their own solution and then modify the field references. With that being said, we do have an EmailClient.fmp12 as an example file for the Email plugin that may be close to what you are looking for. You can probably modify that to work for CloudMail but at that point it might be easier to just start from scratch.

Well, then it is a rather simple matter of nesting (not concatenating) the operations. The Let() function is a convenient tool to do this while retaining readability. Consider something like: Let ( [ // REMOVE FORMATS text = TextFormatRemove ( Self ) ; // REMOVE LEADING & TRAILING PUNCTUATION text = LeftWords ( text ; WordCount ( text ) ) ; // EXPAND ABBREVIATIONS text = Substitute ( text ; [ "av " ; "avenue " ] ; [ "av. " ; "avenue " ] ; [ "ave. " ; "avenue " ] ; ... [ "str. " ; "strasse " ] ) ; // CORRECT CAPITALIZATIONS text = Substitute ( text ; [ " d'a" ; " d’A" ] ; [ " d'e" ; " d’E" ] ; [ " d'h" ; " d’H" ] ; ... [ "st-" ; "St-" ] ) ; // HANDLE WHITE SPACES text = Substitute ( text ; [ ¶ ; " " ] ; [ Char (9) ; " " ] ) ; text = TrimAll ( text ; 0 ; 0 ) ; lastSpace = Position ( text ; " " ; Length ( text ) ; - 1 ) ; text = If ( lastSpace ; Replace ( text ; lastSpace ; 1 ; Char (160) ) ; text ) ] ; text ) You can do any calculation inside a script; however, I can see no advantage to scripting this.

I'm not sure I'm following you. Are you saying you can't see the little blue button on top of your button in layout mode?

It's also being used in the GetValue expression to pull the proper value in each loop iteration.

Roughly: Set Variable [ $eventID; Events::EventID ] Set Variable [ $personIDs; List ( Personnel::PersonID ) ] Freeze Window Go to Layout [ Attendance ] Loop Set Variable [ $i; $i + 1 ] Exit Loop If [ $i > ValueCount ( $personIDs ) ] New Record Set Field [ Attendance::EventID; $eventID ] Set Field [ Attendance::PersonID; GetValue ( $personIDs ; $i ) ] End Loop Go to Layout [ original layout ]

A self-join of your table would be convenient, say: Reservations::Date = Reservations 2::Date AND Reservations::TimeIn ≤ Reservations 2::TimeOut AND Reservations::TimeOut ≥ Reservations 2::TimeIn AND Reservations::ReservationID ≠ Reservations 2::ReservationID If there are any related records from Reservations 2, then there's a conflict.

It depends whether you're talking about making a living freelancing or working within organization. I've worked in three organizations (a school district, a private high school, and a state college) where I was either the (or one of) the Database Administrators where we used FileMaker Pro (FMP). In all three, I created/managed an SIS (Student Information System) and many other ancillary FMP databases to support the organizations' needs. The pay's awful (because you're working civil service) but then again, you get to play with FMP all day. In a shining example, the school district I worked for purchased PowerSchool, a $30K SIS that couldn't do the job since it's primarily built for public schools, not special-education schools where practically everything is an exception to the rule. We ended up using PowerSchool to warehouse the data then used FMP (including using ODBC) exclusively to do everything we wanted (PowerSchool) to do.

No to what? I know some of the folks that responded here personally and we all make a full-time living of working with the FM platform. At the company I work for I lead a 25+ team of full-time FM developers. So the question of "Is anyone making a living off FM?", the answer is a resounding: "yes!" So I'm guessing you're answer is more in the realm that you don't believe in FM's future? Care to elaborate?