
Phillip Prahl
Members-
Content Count
10 -
Joined
-
Last visited
Community Reputation
1 NeutralAbout Phillip Prahl
-
Rank
member
-
Value lists in calculation fields
Phillip Prahl replied to Phillip Prahl's topic in Calculation Engine (Define Fields)
Thank you - that makes sense. However, I was trying to avoid adding another TO. Perhaps my question is better phrased as: Is it possible to access a value list in a calculation field? (Similar to accessing a dictionary in python?) -
Value lists in calculation fields
Phillip Prahl posted a topic in Calculation Engine (Define Fields)
Hi, I have a calculation that starts by getting an "id_user" value from the table "checkins". Instead of returning this id number, I would like to use it ("id_user") to look up a matching "user_name" in table "users". Is this possible? Right now I solve it by the common practice of creating a popup menu where the first value is the id and the second the name. I then only show the second field. However, I was curious if I could somehow do all of it in the calculation field so I could insert the name via a merge field and not having to use a popup menu. Thanks, Phillip -
Convert Date from SQL to FM Syntax
Phillip Prahl replied to Phillip Prahl's topic in FileMaker Query Language or FQL
Your suggested solution works great! Thanks for "let"ting me know -
Convert Date from SQL to FM Syntax
Phillip Prahl replied to Phillip Prahl's topic in FileMaker Query Language or FQL
Thank you so much! I was also in the process of trying a workaround where I simply have another field that stores the date as an integer and then do my sql query with this field... Will try both solutions and see what happens Thanks again! -
Hi, I have the a calculation field running the following: ExecuteSQL ("SELECT MIN(checkins.date_due) FROM checkins WHERE checkins.id_contact=? AND checkins.isComplete=0"; ""; ""; id) If I tell the field that the calculation result is a number, then I appear to get the correct date back in the following format: YYYYMMDD, otherwise I get nothing or a ?. However using this result in a comparison with say get(CurrentDate) does not work. The strange thing is, that if I set the data formatting in the inspector to be 'general' i get YYYY-MM-DD, so it must know its a date somehow? Any help abou
-
Makes sense -Thanks again!
-
I got a bit smarter after I ran into the anchor buoy concept
-
Thank you for the quick respone. The reason for the id_user is precisely so that I can make a relationship at a later point. My hesitation to use it was that I end up with a rather large relationship graph (well large for a newbie). Basically I feel that I end up with a new relationship graph per layout. Its not quite that 'bad' but let me explain. (This topic may need to be moved to relationships now...) So, say I have a layout that shows records from the table "companies". This layout has a portal that shows both "employments" and "checkins" in separate portals and these show information
-
Newbie question here - so please be kind In a record belonging to the table "company"I have a portal that shows related records from the table "tasks". The table "tasks" has a field called "subject" and this is being shown in the portal correctly. The table "tasks" also has a field called "id_user", but rather that just showing this (which is an integer), I would like to show the first name of the user. This information however is not stored in tasks, but in a table called "users". I have found two solutions (I like the latter better), but was curious to what is the common approach. Sol
-
Hi, A very basic question and hopefully a very easy one to solve (first time user here). I've graphed some numbers across a year (nevermind the wrong sort order). I can't seem to be able to reduce the space being used up in the following marked areas (see attachment). Arrow #1. Outsides area in the charting area surrounding the graph. Arrow #2. Y-Axis title area Arrow #3. Repeated Y-Axis value. I would like to minimize or completely get rid of these areas so that the graph can take up all the space or most of it. Right now about 40% of the width of the area is used for unnecessary blan