I have just downloaded the 360works Email plugin Sample and I am doing some tests to check whether this would solve my problem. I would like to be able to download all emails from my email account into "messages" table and then on each customer record show those emails which are related to that customer via a portal based on a relationship between, but what I can not figure out how to do it is that the portal would show but types of emails those marked as "from" emails and those marketd as "to" emails. So far I have created a relationship between Customers::email ------- Messages::From and the portal would show all "from" messages. If I would set the relationship as Customers:email ------ Messages:To, the portal shows all "to" messages, but what I am trying to make is a join portal that would show by date both "from" and "to" messages, then I plan to make a Conditional Formating saying that if Customers:email = Messages::From then all text in blue, and all text in green when it is TO.
Is this something that can be achieved?
Thanks a lot for any tip,
I guess people are using a similar technique for creating and editing portal records after the new FM16 card window feature, any posts or links about this?
In any case, this is how I'm doing it (sample attached) ... any feedback appreciated!
Create or edit portal records.fmp12
So i'm dealing with two tables.
in a VisitTable layout, i have one or two portals related to the GraphicsTable, each related by a different factor. One portal would be related by a Date field, the other would be a ClientName field..
My desire is to click on a thumbnail in either one of these portals, and have that selected image be displayed in a separate/larger image window (which could be a container field in the current table, Or another portal? I don't care how - i just need to have it show up)
I don't know the best method for doing this (ie., click thumbnail to have image fillin a separate location). In this particular instance, I don't want this to be a separate window, but to display in a container field view on the current window/layout.
how do I accomplish this?
Table 1 (Visits) is a clinic visit table, with numerous fields of data.
Table 2 (Prescriptions) is a related table for prescriptions given on a particular visit. Table2 is related to Table1 by fkey - - - T1ID.
Table 3 (Patient) is a patient table (contacts). PatientID is the identifier for Patient and is related in Visits,Prescriptions, and Patient
I need to have (in a Visits layout) a portal (self-related by PatientID), which shows a list of previous visits to the clinic by this patient.
On this portal I need to show any (1 or many) Prescriptions (from Prescriptions table) which would've been given during that particular Visit
So it's in essence a need to show 2 foreign tables (1 being a self-view by PatientID and the other being the Prescriptions but filtered by PatientID
I have been unable to figure out a good method for this.
My only thought has been to give up on working *IN* Visits, but creating a separate table ("Combiner"), and in Combiner, hold all Visits and Prescription data.
Could I also have a Combiner table that's simply an active "calculation" table, where these two tables are 'looked up' on an as-needed basis, combined, and fed into Visits via a portal? (so it's not actually held data, but is looked up as needed)
what's the preferred method?
macOS Sierra Version 10.12.5
trying to install FileMaker Server 14 with Web Server & PHP. I need web publishing enabled. I checked PHP and Yes, install the FileMaker server version of PHP.
I get this error. Test web server (http://127.0.0.1:80/fmi-test/test.xml): Connection refused
I have no idea where to start troubleshooting. I read through https://fmhelp.filemaker.com/docs/14/en/fms14_getting_started.pdf and nothing helped.
Please help. Its appreciated.