Jump to content

Leaderboard


Popular Content

Showing content with the highest reputation since 03/20/2019 in all areas

  1. 2 points
    Hey John! If you mean the old Music Library, I happen to have it (attached). Music Library.fmp12
  2. 1 point
    Your synopsis layout is based on Cabinet Library. Shouldn't you be using the 'Total Minutes for Door' field from Cabinet Library?
  3. 1 point
    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.
  4. 1 point
    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.
  5. 1 point
    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?
  6. 1 point
    It's also being used in the GetValue expression to pull the proper value in each loop iteration.
  7. 1 point
    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 ]
  8. 1 point
    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.
  9. 1 point
    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.
  10. 1 point
    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?
This leaderboard is set to Los Angeles/GMT-07:00
×
×
  • Create New...

Important Information

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