carla_sloan's articles:

Items(37) /4 Next >> Last >|

Duplicate object - bug? 3 38 (3/18/2009 12:19:04 PM) comp.databases.filemaker One annoyance when working on layouts is that I can't consistently duplicate objects using keyboard shortcuts. Help tells me to "press Ctrl (Windows) or Option (Mac OS) as you drag.", but I find that sometimes... Carla

Find based on unstored calc giving unexpected results 2 40 (3/5/2009 1:25:55 PM) comp.databases.filemaker Using FMPA 10, PC, I'm doing what should be a straightforward Find, but I'm having trouble with it. I have an unstored calc field (it's an indicator, numeric, using a Case statement to return 1 or 0 according ... Carla

Portal contents to be shown in a report 5 47 (2/12/2009 5:13:43 PM) comp.databases.filemaker Hi. I have an Interface table (INT), a People table (PPL), a Roles table (ROL), and a People/Roles join table (PRJ), with a record for each role that each person has. In my Interface file, I have a field call... Carla

Comparing lists to find a match 4 47 (2/3/2009 3:20:46 PM) comp.databases.filemaker I have 2 lists, the first is a list of ValueListItems, and the second is a list of values from a related file. I need to check whether any of the items in List 1 are also in List 2. So, if List 1 contains "ROL... Carla

Sub-summary report - problem working out which summary field to use 0 41 (1/26/2009 12:38:40 PM) comp.databases.filemaker Using FM9, PC, my problem is this: With the data structure Organisations --> Programmes --> Sessions, I need a sub-summary report to show, for each Organisation, the number of Sessions and the number of Prog... Carla

Security - record-level security for Full Access account? 2 48 (10/14/2008 10:59:32 AM) comp.databases.filemaker As the developer of a system, I need access to debug, data viewer, define database etc. But I also feel the need to limit my ability to delete certain records in certain circumstances. So what I would really ... Carla

Join table problem 4 38 (6/3/2008 9:07:16 AM) comp.databases.filemaker This should be straightforward, but I've been working on it for ages and seem to have a mental block. In my solution, a Programme consists of many Sessions. People enrol to the Programme, so a Programme also ... Carla

Sorting for sub-summary report 6 39 (1/31/2008 12:13:28 PM) comp.databases.filemaker I have a report with 3 sub-summaries, with "Yes/No" fields set by the user to determine whether the sub-summaries are required or not. The user can select any combination of the 3. I'm now trying to write the... Carla

Field validation and value lists 3 44 (1/15/2008 11:31:37 AM) comp.databases.filemaker I have a field, which can be based on different value lists, depending on the context (on one layout it uses value list A, on another it uses value list B, etc.). My problem is how to validate it. The value i... Carla

Field validation when window closes 6 51 (12/20/2007 2:39:43 PM) comp.databases.filemaker (FM9, PC) Is there a way of forcing FM to validate the contents of a field when the current window closes? The validation (by calculation, using the Scriptfire plugin) works fine when the user tries to enter ... Carla

carla_sloan's replies:

Items(20) /2 Next >> Last >|

Specifying "target field" by calculation (in "Set Field") 2 53 (11/16/2007 9:47:36 AM) comp.databases.filemaker In order to make a Find script as generic as possible, I want to be able to pass it (as parameters) a layout name, a field name, and a field value. So the script will go to the layout (using P1), set the field... carla_sloan (66)

Refreshing calc (sum) fields 10 39 (12/5/2007 6:05:51 PM) comp.databases.filemaker In a "Bookings" table, I have a calc field, "TotalBookingCost", which is defined as "sum ( BookingLines::BookingLineCost)", i.e. it's the total of the costs of the individual lines that make up the booking. Boo... carla_sloan (66)

Field validation when window closes 6 51 (12/20/2007 2:39:43 PM) comp.databases.filemaker (FM9, PC) Is there a way of forcing FM to validate the contents of a field when the current window closes? The validation (by calculation, using the Scriptfire plugin) works fine when the user tries to enter ... carla_sloan (66)

Field validation and value lists 3 44 (1/15/2008 11:31:37 AM) comp.databases.filemaker I have a field, which can be based on different value lists, depending on the context (on one layout it uses value list A, on another it uses value list B, etc.). My problem is how to validate it. The value i... carla_sloan (66)

Sorting for sub-summary report 6 39 (1/31/2008 12:13:28 PM) comp.databases.filemaker I have a report with 3 sub-summaries, with "Yes/No" fields set by the user to determine whether the sub-summaries are required or not. The user can select any combination of the 3. I'm now trying to write the... carla_sloan (66)

Join table problem 4 38 (6/3/2008 9:07:16 AM) comp.databases.filemaker This should be straightforward, but I've been working on it for ages and seem to have a mental block. In my solution, a Programme consists of many Sessions. People enrol to the Programme, so a Programme also ... carla_sloan (66)

Comparing lists to find a match 4 47 (2/3/2009 3:20:46 PM) comp.databases.filemaker I have 2 lists, the first is a list of ValueListItems, and the second is a list of values from a related file. I need to check whether any of the items in List 1 are also in List 2. So, if List 1 contains "ROL... carla_sloan (66)

Portal contents to be shown in a report 5 47 (2/12/2009 5:13:43 PM) comp.databases.filemaker Hi. I have an Interface table (INT), a People table (PPL), a Roles table (ROL), and a People/Roles join table (PRJ), with a record for each role that each person has. In my Interface file, I have a field call... carla_sloan (66)

Find based on unstored calc giving unexpected results 2 40 (3/5/2009 1:25:55 PM) comp.databases.filemaker Using FMPA 10, PC, I'm doing what should be a straightforward Find, but I'm having trouble with it. I have an unstored calc field (it's an indicator, numeric, using a Case statement to return 1 or 0 according ... carla_sloan (66)

Duplicate object - bug? 3 38 (3/18/2009 12:19:04 PM) comp.databases.filemaker One annoyance when working on layouts is that I can't consistently duplicate objects using keyboard shortcuts. Help tells me to "press Ctrl (Windows) or Option (Mac OS) as you drag.", but I find that sometimes... carla_sloan (66)