x_actly

Thanx S

Programming shouldn't included the clipboard?? The WHOLE POINT in this case IS to copy the field contents to the clipboard so that the user can then paste the specific info into other apps/docs. Since the fields are not enterable in browse mode, there is no way to copy their contents if the user needs to...which kinda sux. And hardcoding a script or parameter for each field seems a bit...silly.

Errrr...not sure how I would use a calculated field. Since "Allow user to Enter Field" is OFF in browse (protecting the data), the field is not active, even if clicked on...which is why I want the field to be a button which then triggers the COPY script. Even if I can identify the field, the Go To Field... script step does not seem to allow calculated field names - only hardcoded names, which means a seperate script or script parameter for every field. There must be a more efficient way!

Goal: click on a field (a field designated as a button) and copy its contents to the clipboard. Technique: for efficiency and simplicity, use a single script that is called by any designated field. Problem: How to pass the name of the "target" field that is clicked without hardcoding a script parameter for each and every field? The field is not actually entered so you cannot use get(ActiveFieldName), and neither the Copy nor Go To Field... scriptsteps allow you to calculate a target field anyway - the field must be hardcoded. Am I missing something obvious? Is there no way in Filemaker to just pass the name of the clicked object, such as HyperCard's "get the name of the target and put it into fieldName" followed by "go to field fieldName"?

SCENARIO: a calculation field with 20 repeats, all repetitions showing horizontally in a portal row, and the field designated as a button. QUESTION: is it possible to click on a specific repetition of the field and have the repetitiion # identified and passed on? (i.e. click on rep #5 of 20 and pass the rep# to a specific field for use in other calculations.) Because the field is designated as a button, it cannot be entered - hence the 'Get ( ActiveRepetitionNumber )' function cannot be used. Anyone have any ideas, or is this impossible?

Ack - I may have spoken too soon. Will let u know after more testing. :-(

SCENARIO: I have 8 related tables in a single FM7 file, primarily using a star join. The GUI layer used for printing is a separate table which contains the many required layouts, most of which use PDFs with related fields overlaid where required, or text with merged fields. This is done to seperate data from the presentation layer, so that a change in one or more of the PDFs can easily be updated without disrupting the data. INTENDED BEHAVIOUR: The "template" table contains many layouts but only a single record - the record to be printed. The relationship with the "template" table is via a global field; it contains the primary key of the record to be printed from the main data table. Clicking on the record to be printed takes the user to the appropriate "templates" layout and displays the directly related record, along with any other relevant but more distant related fields. OBSERVED BEHAVIOUR: a script sets the global field in the "templates" table to the correct ID and switches to the intended "template" layout. Related fields located in the same table as the primary key update properly. Related fields from one or more table "hops" away do not update. Closing the file and re-opening it causes the more distant related fields to be properly updated and displayed. QUESTION: Why are more distant related fields not updating immediately, but only after the file is closed and reopened?

Thx Ugo for your proposed solution for rolling up primaryTask/subTasks into primary Task groups. I'll try implementing it this afternoon and let u know how it goes. For the 'master summary view', the problem with a columnar layout is that it is meant for a printed report and requires Preview mode. I require this information to be displayed while in Browse mode, with: x ( columns) = task group, 1 to 15 y (rows) = date, unlimited If your primaryTask grouping solution works, I can probably extend it to create the 'master summary view'...I hope. -) doug

Can anyone tell me if this is even possible, before I keep banging my head against the wall? I have 4 related files with a LOT going on, but a very simplified description follows... BACKGROUND: Master file with records that use Date as a primary key. Related file (Line Items) contains records (key is primaryTask + subTask) which include financial data. A portal in the master file lists all Line Items (i.e. tasks) for a given day, and gives a single summary of financial data for that day. (No problems here.) PROBLEM: Is it possible to create a view - not a report - that shows summaries by primaryTask on a given date (i.e. primaryTask1:summary, primaryTask2:summary, primaryTask3:summary...etc.)? In other words, I want to roll up the (primaryTask + subTask)s into primaryTask groups, and show the summary for each group for that day. If this is possible, I also need to create a 'master summary view', that shows date in rows, primaryTask groups in columns, and gives a grand summary at the bottom of each primaryTask column. I've been trying to do this with scripts, loops and find commands but it is getting unwieldy. I am fairly new to portals but it seems that they would be the right way to go, no? Any suggestions or examples that I can refer to?