I would like to include for access in multiple solutions a fairly exhaustive properties of the Periodic Table.
And if there doesn't seem to be on how can I create one?
Perhaps single row portals (each one filtered to a single element)? You can place them on a layout in the "periodic table" style. You could have a pop-over with other details that would pass the element to a script to set the "filter". Thus one pop-over triggered by all the elements.
Or I found these:
(And more! When I Googled 'FileMaker periodic table')
Sent from miPhone
These seem to be the “Flat File” versions without access to the individual properties of each element that one would want in a database.
I did not look at any of these. But you can research more, if you care too.
It would seem to me that the requirement here is, essentially, a flat file. To put it another way, the periodic table would be a single FM table with fields for each of the properties/characteristics you want to list. That data contained can be inserted once and then remains static—more or less. You would then be able to reference this data by creating relationships as needed. The table could be a separate file, making it more easily referenced from a variety of other files, or it could be included as one table within a multi table database, the more conventional way.
Flat file or other setup the question is:
Where to get all the data to put into the file, however organized?
Seems to me there are a lot of options on the links Beverly provided. Start there. You may even find something that's just what you need and save yourself the design task. Some at least are FM files, it appears.
in case you are still looking for a way to build a FM solution, my thought is that you would have a table of elements (and the element-specific data) that you would access via a relationship from your "main" table. The main table would contain the "flat" aspect - but the flatness is only be for display purposes. This display would be a series of repeating fields with global storage. You would populate these repetitions via a long, complicated script (the form of the periodic table is very complicated). Your display would be made up of either: Repeating fields oriented horizontally with one record per row in the periodic table; or repeating fields oriented vertically with one row of data per column in the periodic table. Here's project I built that uses rows of repeating global containers populated by a script ...
Surrender to Fun, with FileMaker
an important more: I was thinking about what a bear it would be to build the layout; but then I realized that you could use a single repeating field and one record. Make your repeating field use global storage with 112 118 repetitions. That would make it much, much, much easier to build your layout and associate buttons with the elements ...
If you look at my Fun with FileMaker, you'll see that there is a second repeating field called "Overlay". It is a transparent set of buttons that fit exactly over the repeating field with the data.
I would NOT use repeating fields for this. Single row filtered portals would allow precise placement (as would repeating fields), but you need a relationship for linking to details for each element. It just screams related table and portals.
I've been playing with it and I'm afraid that I have to agree with you.
For the OP, the challenges appear to be the constraint of vertical portals. I'm still honing in on it.
no need for vertical (or horizontal) if each element is a single portal filtered to the element. arrangement can be as desired on the layout.
You don't even need a portal filter for this. If the relationship is sorted by atomic number, you can simply set the one row portal for Hydrogen to be row 1 of 1. The portal for Helium would be row 2 of 1 and so forth...
That is correct!
If you're building this, then you should add a related table for sub-categories, (e.g. Alkili Metal, Nobel Gas). This table can have a container field to store the desired background color for each element via a sub-category relationship.
You'll probably end up building a single-row portal (suggested above) with three layers: a background color; the element data (from one or more related fields); and you'll probably want a transparent button on top. You can use Get(ActivePortalRowNumber) in the button script.
... always more ... your button script can also use Go to related records. And, advice, test before you duplicate your layout objects.
Hydrogen to be row 1 of 1. The portal for Helium would be row 2 of...
It did strike me that this is probably the only time a developer can reliably use "line item" data (atomic number) as the primary key. No duplicates. (Unless something changes - scary thought.)
I had the same thought, but what you are quoting from my previous post works in many situations and does not rely on primary key values at all--it just the standard way to set up one row portals as a kind of "horizontal portal". What we all have been collaborating on here is basically a horizontal portal, but on "steroids" as we aren't simply arranging the related records into a single horizontal row.
Just in case you dont have a source...
Periodic Table Data
... and the beauty of the Periodic Table Data link provided by coherentkris above has the data in csv format. Then download csv files, and then drag and drop the csv file unto the Filemaker icon on the desktop, voila the data is imported. Add field names and you are about 90% into a finished database. You can then play with GUI in layouts for displaying data anyway you want.
Hey Kris - not to poo-poo your help ... but I copied this earlier today and made it into a text file. It needs to be parsed - one element per line/record. (source List of chemical elements - Wikipedia )
another happy collision.
Thanks for all the insights! Let’s keep going!
I took a look at some of the sites suggested early on and as a Mac user - although with Windows 10 in VMware I can deal with .exe files - I’m behaving as if I had a shock collar on when I see one of these files from a “sketchy” site. Not ‘gunna open them. There has been some great information as I was away.
This is my first post after being a “member” for over three years. What a great resource!
Here is a quick Periodic Table, based on the data from the link provided by coherentkris.
Periodic Table Data
When all is said and done, it is very, pretty hard to beat what this website does with the Periodic Table.
Dynamic Periodic Table
That is a fantastic web site!! Had never seen it. In a way I’m looking for the back end of that web presentation and of course the graphical representation.
For my ultimate use I want all the data available inside the solution for use in subsequent ceramic material design use!
Seems some of the csv sites would get the solution started.
davids, it is an awesome website. The fmp12 file I posted from the csv data, can be easily modified so that when you click an element it performs an “Open URL” to a webviewer to the corresponding wikipedia link for that element. The variations are numerous, you could set each element button to open a popover, in the popover there could be a radio button set that would take the user to various Open URL links for that element in a webviewer. Tedious, repetitive, but not to complex.
For me, I just set up one button to “Open URL” to the website: http://www.ptable.com/#Writeup/Wikipedia in a webviewer, or default browser, and let the user go where they will. But it does require an internet link.
Enjoy the project, it is fun.
Retrieving data ...