I'm using this calculation--in a parent table in a field temporarily named 'Temp'--to grab course numbers from the course_number field in a related/child table:
UniqueValues ( List ( ASSIGNMENT_COURSE::Course_Number__lxt ) )
(I'm using this calc because the child table contains multiple records with the same course number; it's not a key field.)
My intent is to use six buttons--in the parent table--where each button would grab an assigned row's value using the calculation above. For example, say that the above calc has this result:
I want Button 1 to grab AST-100; Button 2 to grab EDU-100; Button 3 to grab EDU-300, etc.
Mind you, I can't make a value list out of Temp because it can't be indexed.
TIA for your help!
I have always developed with FileMaker for windows. I have bought myself a MacBook Air and love it. So now I am using FileMaker 16 Pro advance for MAC. I know that MAC does not label their directories like windows does. So I am having problems figuring out to get the right coding to access my photos. I have a folder called "Photos" that reside on the C: drive in windows. Then I reference that folder so pictures will populate automatically when I put in a record. Here is what I have on the windows fileMaker:
Let ( [ // Transform the contents of a container field named Images to text ImageRef = GetAsText ( ImagePath); Photos = Position ( ImageRef; "/"; 1; PatternCount ( ImageRef; "/")) ]; Middle ( ImageRef; Photos + 1; Length ( ImageRef ) - Photos ) ) images:
"imagewin:/C:/Photos/" & Film::title & ".jpg" Then I go into Import folder and point to the folder all the photos are in. The problem I have now is how to point to that folder in "imagewin", is their an alternative called imagemac, then I could put in Macintosh HD/Users/patricks/Documents. The folder is in the Document folder, called Photos. Thank you for any help.
Gents, need your help on the following issue:
I need to track my expanses. There are 4 tables: Products, PriceChanges, Transactions.
The problem: I need to make a script which will make calculations in transactions tab, accounting for the latest price change.
01 jan17 I bought one bottle of wine for $1
03 jan 17 I bought the same bottle of wine for $1,5. So the latest price is $1.5
In Products table there is one record which is wine.
In PriceChanges table there are two records: $1 and $1.5
I need that Transactions table automatically take corresponding wine prices while adding new or past records.
Hello FM Mavens,
I am likely missing something.
I have a script step that calculates the dimensions of an image in a container field. There are many such fields so the script should work with any arbitrary one.
I get the name of the field by using script parameter Get(ActiveFieldName).
Let's say I have a container field "cont1". The script is triggered by entering the field.
I am trying to calculate the height of the image by using
GetContainerAttribute (Get ( LayoutTableName ) & "::" & Get ( ScriptParameter ); "height" ) The results are question marks - I am not sure why. If I explicitly identify the fields then the expression works.
Tried the same expression (Get ( LayoutTableName ) & "::" & Get ( ScriptParameter )) in the script step "Set Field by Name" and it worked, which means that the expression correctly identifies the field the script is attached to. Then why is it not getting it the first step? What's wrong with the calculation? (FM17)
(I hope I posted it in the correct section)
Who Viewed the Topic