The types of information and code that can be found on this page is as follows
- Data Entry Form URL link that Sharperlight auto generates based on the Metadata
- Data Entry Grid URL link that Sharperlight auto generates based on the Metadata
- Restful Service Help link on Writeback POSTs
- Writeback Table JSON Metadata URL Link (This contains all the fields and their attributes)
- Restful Service POST URL link for the selected table – Updating and Inserting data
- Restful Service POST URL link for the selected table – Deleting
Sharperlight Index Page showing the Developers menu
The developer menu contains links to the various metadata exploring reports, RESTful service help and online resources. In this article we will be focusing on the Writeback – Metadata link that allows one to list all the tables by Product. If the Product has a concept of a Super Field / Company then the tables will be appear under each company. This is because a Super Field value can affect what Tables appear and their attributes.
Use Foundry to create a Application with Writeback Tables
Foundry can quickly create a Application Project with a Datamodel and writeback logic on the Tables. In this example the Inventory Foundry Template was used. If you already have a Datamodel, Custom Table or Materialised Query Table the same principles apply.
Inventory example showing the Brand Data Entry Form
As you can see the Foundry generates a basic menu and report for each Table including links to Data Entry Form and Data Entry Grid. In the case of the Data Entry Form it passes the identity or primary key to the Data Entry Form so you can edit the records one and a time. It is possible to style the Data Entry Form with URL parameters or even CSS. The URL parameter will also allow one to hide or lock fields. (See the Restful Service Help for details)
Inventory example showing the Brand Data Entry Grid
Sharperlight auto generates the Data Entry Grid which can be passed filter parameters like any other report. There are URL parameter that will one to hide or lock fields. (See the Restful Service Help for details)
Data Entry Writeback Metadata
RESTful Service Help
You can navigate through the RESTful Service help using the tree on the left. The link can be found under the Developer menu on the Index page.