I have a button script that changes the size of a selection in a text field.
This is it:
Insert Calculated Result [ TextSize ( Middle ( Get ( ActiveFieldContents ) ; Get ( ActiveSelectionStart ) ; Get ( ActiveSelectionSize ) ) ; $size ) ] A problem with this is that if the selection begins with styled characters (bold, underlined, etc) then the entire resized area becomes styled. If there is at least 1 unstyled character before the first styled one, then all styled and unstyled characters remain as they were. What is missing from the calculation?
Our database has properties and for each property there are multiple inspections per appliance, sometimes year to year sometimes quarterly. Anyway, we want the technicians in the field who are using iPads to view the history per property by swiping just to make it simple. Every swipe would be a different inspection for that property viewed in chronological order. Property part is "static" while they "page" or swipe through the inspections.
I was thinking a slide control would work nicely, and each slide would be a different record for that property. I'm looking for ideas to jumpstart my thought processes, apparently my brain is having a hard time functioning today (and it's only Tuesday!). Any ideas would be greatly appreciated!
By Prasad Khandagale
FileMaker 17 is launched with the purpose of letting the users do more without spending much time. The new version also works towards its goal of letting the users do more with the FileMaker platform while they are on the go. To know some of it's most popular features read this article.
I'm working on a database right now that handles general accounting information for a department of a university. My current layout looks like this:
Where the left section has buttons to take you to the different layouts and look at various different tables, and the middle column is a scrollable portal to look at all of the jobs. On the right hand side for the "employees" section, I was able to fit all of an employee's data in that space, so it worked, but each job has significantly more data associated with it and doesn't fit in that space, so I was wondering if there is a way to make that section scrollable, but looking at the same record (i.e. The job description would be at the top, and then some info on what materials and labor have been billed to that job, and then be able to scroll down and have another section with contact info for employees assigned to that job, etc.). From what I've been looking around at for solutions it looks like this is impossible, but I'm hoping that maybe there's someone out there that's more creative than me! I thought about making the whole layout taller and then somehow locking the left columns into position while scrolling so that they would be fixed in the viewport, but I couldn't find a way to do that. Thanks guys!
Am a bit lost on what (I think) should be a quite simple script:
Field 1 has a value list on layout.
Field 2 is a general text field for typed data entry..
My goal is to use Field 1 to trigger/manage a script which does severla things, but then leaves the mouse/selector inserted into Field 2, for ease of use...
When I select an item in that value list, an OnObjectExit triggered script:
sets a variable from that, then clears that field inserts a calculated value (based on the variable created) in another field. Then it SHOULD "go to Field 2"... as in, after the script is done, the cursor should be inserted into Field 2 with a blinking cursor... My problem is, this isn't working.
the first two parts are working flawlessly - it creates and acts on variables, as it should..
But it refuses to 'go to field' (or "go to object", if i try it that way)..
What's happening instead is this: the script runs, but the selector/mouse jumps on forward to the next object (if that object is in a tab order), or (if NOT in a tab order), it goes nowhere (it operates the script, but dies before setting mouse to the field or object).....
I also tried OnObjectModify and OnObjectSave.... No dice on either.....The mouse simply refuses to "go to field"....
additionally, i tried triggering ANOTHER script (which works on its own) - - simply "go to field 2".. but even that doesn't work..
My guess is that the script (as an OnObjectExit trigger) runs, then FMP assumes that after the script ends, the next object should be selected (rather than ending wherever I told it to end)...