This topic is 2507 days old. Please don't post here. Open a new topic instead.
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)...
I have the following problem. I'm working on a solution for the owner of several restaurants. Each restaurant has meetings once or twice a month. How would I structure the tables so that I could have a layout on which I select a restaurant and then inside a portal I get a list of all employees. On the portal for each row I want to have a button or checkbox to mark if an employee is present or not.
I already have the following tables:
Restaurants, Employees and Meetings
So far I have a relationship between the Restaurants and Employees table which I use to assign employees to a restaurant, and a relationship between the Meeting and Restaurant table, which allows me to show all employees that work at a selected restaurant using a portal on the meetings layout. How do I proceed to solve my problem? Do I create another table MeetingAttendees or something similar that I use to keep track of people attending a meeting? How would I create a relationship then to allow me to mark certain employees as present and absent?
Thanks in advance,