Anybody have any experience with Notion ?
I’d love to use their API to display database entries on my website … but frustratingly - as simple as they make it appear - it may be beyond my abilities : o
Alternately, could I set up an SQL database that calls fields via an Elements page
Or is this complex ?
I used MySQL about 16 years ago to present data on my website. It is still going strong. It was very easy to do. I’ve had to update PHP over the years, but that wasn’t difficult either.
Thanks Ron … any ideas where to start ?
Perhaps it’s best to start with the problem you want to solve, then we can pick the most suitable technology to solve the problem.
You want to display some data on your website, but is that in a table or more CMS like throughout the page?
Does the data need to be update or edited regularly, perhaps with new records?
Do you have an example of what you need?
Let us know and hopefully we can help get you something set up 
You’re an absolute star Dan.
So - I have a Filemaker Pro database of say 2000 paintings, with records showing Title, year, medium, exhibited at and so on.
I was very happy with FMP for years but every time the OS updated, the damn thing broke and they wanted more money. Now it’s silly money and I’m sure I only use a small part at FMP. The current ask is £500
So - I thought (on a recommendation) … go to Notion - it’s free for a single user and it has a great API for accessing the data via a website. So now I have a Notion database. Up shot - I cant get any data to show yet but have an active ticket with them so hopefully one day I will.
Then, in my frustration I started thinking - maybe I can build my own damn database on my own server and do without the third party tools, which can ultimately let you down.
Anyway - The goal : Is to use a private webpage to pull in the full list of paintings in the database. To then allow the user to click on any particular record (painting) and see all the associated data (title, year, location, owner, media and so on). I thought Elements would allow me to structure the data in a way I felt was
The image is a database entry from Filemaker Pro. You can structure the data visually to make it meke some sense. In Notion, you just get a list - like a spreadsheet. I thought Elements might allow me to structure the page more like I could in FMP.
(… and indeed to search for entries on any given field … eg - painting of Greece or Charcoal Drawings)
It’s connecting with other systems, customers and client input which is really exciting to me in Elements. Just wish I knew more : )
Apps that talk to other apps multiples their usefulness