I created a dashboard with a bunch of buttons, attached script to every button, which allows me navigating to specific record of the Products table. Basically, every script is the same, with minor changes (only record ID field changes).
The process of creating a script to every button is a very time consuming as I need to write a script that a) goes to layout b)finds the certain record
1 "Step: Go to Layout
2 Step: Perform Find"
Is there a way to simplify the task?
By Jonathan Ackerman
is it possible to append text or images to the end of a loaded doc. (not just another document)-
i.e. something like--
$result=ScribeDocAppend ("new stuff")
it seems the function only looks to append other files, not text
what i need is to be able to add custom text to the end of some documents-
not sure how to do this.
I am working on a script that will build a document based on a value from a drop down list.
I have a layout that contains a Document Subtype. If a certain subtype is selected from the drop down list for this record, then I want my script to be able to pull from a specific container holding the appropriate document for that type. Then I can use Doc Append to combine the two documents. Each document would be custom then to the subtype.
I'm pretty new at FileMaker so I'm still trying to figure a lot of things out and still trying to understand how to put things together and why it will/will not work.
I was originally using Case but then I realized that was probably not the correct thing to do. It would either append both types of documents or one, but it wasn't always the correct one.
Any guidance would be greatly appreciated.
If this helps, I want something that will do this:
If Subtype = a, b, or c, then append Doc 1
If subtype = d, e, or f, then append Doc 2
and so on...
Hello FM experts,
this is a concept step for a more complex script but I need a script that has 2 independent features:
1: it selects the field it is attached to as a button
2: it can be attached to any arbitrary field and it does the same on that field.
The imaginary script step would be this:
Select field [the one I am attached to] The problem I am running into is that "go to field" can not be defined by calculation, while "go to object" gets confusing between the script and the field being grouped, as the problem detailed here [https://www.soliantconsulting.com/blog/story-about-go-to-object] seems to be a complicating factor.
Hi FM Mavens, this will be long, I am sorry. The following is the setup:
Small medical office database I am writing for myself. 4 tables: "Pts", "Encs", "Rxs/RxDup" (patients, encounters, prescriptions - patients have several encounters, encounters have several prescriptions.) RxDup is a duplicate of Rxs but that is not why it is called RxDup, it is called that because it is used to duplicate individual medication orders.
Mac OS 10.13.2, FMPro Advanced 220.127.116.110
Task: (a) selecting an arbitrary number of records in a portal within Pts that looks at Rxs by setting the match field to a certain value (b) going to the records that become related via this act and (c) doing something with those records (duplicate them). (c) is not problematic. (a) and (b) are.
Relationships: Pts - Encs via _PtID, Pts - Rxs also via _PtID, Encs - Rxs via _RxID and Pts - RxDup via _RxDupID.
_PtID is a serial number of patients. It is added to every new encounter record for any patient in table "Encs". This is clear and it works as it should.
_RxID is a combination decimal number obtained as _PtID + encounter serial for that patient * 0.001. So for patient #25, prescriptions written on visit 1 will be matched between "Encs" and "Rxs" via 25.001, etc. This also works as it should.
As table "Rxs" also has _PtID, all prescriptions are visible from table "Pts". This also works as it should.
All these are static values. I mention these only for the sake of completeness, there are no problems here.
_RxDupID is the value of _PtID combined with the term "dup" (a text field) e.g. "25dup". It is the match field between tables "Pts" and "RxDup".
In table "Pts" _RxDupID is a static calculation text field. In tables "Rxs/RxDup" it is a text field that can be set to the match value or to "". The setting occurs via clicking a checkbox on or off in the portal looking at "Rxs" from "Pts" via the _PtID relationship. The value list attached to the checkbox is the value of _RxDupID in the active "Pts" record, obtained via a Pts-to-Pts self-relationship using PtID. This also works, i.e. the value of the match field in the Rxs records seen in the portal is correctly set to the single value that shows up in the value list. I assume that this occurs in RxDup as well necessarily and simultaneously. (Am I correct?)
The following happens:
I open the database, go to today's set of patients. I go to one of the 5 patients whose records are in today's found set. Let's say it is Pt #25. I tab to the portal showing Rxs, let's say there are 30 previous rx orders showing. I click the checkbox in 3 records. I see it confirmed that the match fields are set to what they should be (PtID & "dup"). I run the script
Go to Related Record [ From table: “RxDup”; Using layout: “Rxs DUPLICATOR” (RxDup) ]
[ Show only related records ]
It does what it is supposed to do. It goes to the 3 related records in the correct layout and does (c) on them.
Then I go to another one of the 5 patients in the found set. Let's say it is Pt #56. I tab to the portal showing Rxs, let's say there are 50 previous rx orders showing. I click the checkbox in 6 records. I see it confirmed that the match fields are set to what they should be (PtID & "dup"). I run the script again.
Here it becomes dicey. There are a few ways things can go wrong here:
- The script takes me to the 3 related records of Pt #25 and does (c) on them.
- The script takes me to the related records of Pt #56 but not all 6 show. If I go back to the portal in Pts and run the script again, this time it may show all 6 records.
- The script takes me to some or all of the related records of Pt #56 but in some records the match field is blank. (This really baffles me)
Then it becomes really interesting.
I go to a third patient in today's found set, lets say it is Pt #77. I run the script again.
I get a 101 Error. The script does not go to the related records in table "RxDup", it stays in table "Pts" and runs (c) on the 5 records there.
This repeats reliably. On first run, and sometimes on second, the script works well. On runs 2 - 4 it makes an error in going to the correct (or correct number) of related records. Eventually it does not go to the related records at all.
The indexing of both match fields are set to "All". I tried "None" with "automatically create indexes" but the result is the same.
My guess is that something goes wrong with the indexing but I could be wrong of course. Any help would be much appreciated.