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