![Ms to do](https://cdn2.cdnme.se/5447227/9-3/screenshot_4_64e629479606ee5be4b9a969.jpg)
![filemaker website filemaker website](https://powercrack.com/wp-content/uploads/2020/10/f1aed731ba2c5c73df70ddb48c6bd1ec-768x561.png)
You can read the documentation from DataTable here. Export your data as CSV using the native script steps in FileMaker, then upload the CSV file (instead of JSON) to your web server.From now on you can just run the “Export to JSON and Upload” script, and your data will be uploaded within a few seconds. You can now see the data that you put in that JSON file in your table. Open the URL leading to where you saved datatable.html in step 1. We’re using FTP in this example to upload data. Here‘s an example of how to convert your records into JSON (using the demo file). This file will be created and uploaded by FileMaker in steps 2 and 3 below. This table is set to pull JSON data from a file called data.json. Make sure you customize the column names between the CUSTOMIZE comments, according to your data. Throughout this guide, I’ll be using data with 4 fields/columns: Name, StockCode, Quantity and UnitPrice.Ĭopy the code below and save it as datatable.html (you can embed the code below into your existing page, just be sure that you load the same JS and CSS files from the code below). Setup your data table (we used one from ).The options are more limited when you’re using FileMaker client only. There are multiple ways to display data on the web from FileMaker Server (WebDirect, Data API, CWP…). The example below is using DataTables ( ). This method is especially useful if you don’t have a FileMaker Server. Here’s a quick way to display data from your FileMaker app on the web.
![Ms to do](https://cdn2.cdnme.se/5447227/9-3/screenshot_4_64e629479606ee5be4b9a969.jpg)