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 22.214.171.1240
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.
I'm sure there is a simple solution to this problem, but I can't seem to figure it out!
I have a custom app that allows the user to write letters amongst other things.
Each patient is linked to a GP and a Consultant, when writing a letter to a patient there is the option to CC both the linked GP and Consultant. However, occasionally another GP or Consultant might need to be CC'd in the letter (in addition to the ones already linked to the patient). So I would need the address of this additional consultant/GP to also be CC'd in the letter. For the life of me I can't work out a simple way to do this.
Does anyone have any suggestions?
Thanks in advance.
I've been using CloudMail for a couple of years now to send marketing campaigns for my company. Just recently I have moved to remote hosting with AWS and now my server is offsite I have noticed some performance issues with cloudmail and a few other areas of my solution.
To address these issues I have started using server-side scripts to perform labour intensive tasks such as creating bulk records (20,000) at one time. This has resulted in excellent performance once again.
The problem I can't seem to fix is sending my email campaigns using server-side scripts. I have confirmed the plugin is installed etc on the server and with quite a bit of trial and error, I am still unable to send the campaigns.
Does anyone have a sample script they use, or any advise how I can get this working?
I appreciate any help and thanks in advance