Footballer Data Entry Form
The third entity data entry form is a footballer record.
Having previously created custom variables and a data source request to display a lookup form showing, filtering and sorting footballers, we are now moving on to creating a data entry form where a footballer can be created, read, updated and deleted (CRUD).
In our ReST API sample data set, the underlying restdb.io footballer is the Players
table.
The process for all CRUD operations typically starts with READ, as this involves designing the data entry form, and drilling down into it. Here are the four CRUD phases in the order we will configure them:
Add a 'read' data source for reading a single footballer record
Link the key footballer record identifier to this ReST API end-point if necessary
Create a data entry form
Assign this 'read' data source to the data entry form
Design this form and drag fields from this data source
Add this form to the navigation bar
Configure drill down to the lookup form grid component
Test that we can lookup footballers and drill down into a data entry form showing the footballer master record
Set the History Menu record summary
Test that we can lookup footballers and drill down into the footballer form, and that the history menu shows the footballer name
Add a master/detail grid to show all previous clubs/teams
Test that we can view all previous clubs/teams whom this player represented
Create custom variables for each field
Add an 'update' data source for updating a single footballer record
Link the key footballer record identifier to this ReST API end-point if necessary
Map the custom variables mapped to the form fields to the data source body fields
Assign this 'update' data source to the data entry form
Configure the update button
Test that we can update a footballer using the Update button
Add a 'create' data source for creating a single footballer record
Link the key footballer record identifier to this ReST API end-point if necessary
Map the custom variables mapped to the form fields to the data source body fields
Assign this 'create' data source to the data entry form
Configure the app toolbar Add menu to add this data entry form
Test that we can create a footballer using the Add menu and Update button
Add a 'delete' data source for deleting a single footballer record
Link the key footballer record identifier to this ReST API end-point if necessary
Map the custom variables mapped to the form fields to the data source body fields
Assign this 'delete' data source to the data entry form
Configure the delete button
Test that we can delete a footballer using the Delete button
Last updated