Club/Team Data Entry Form

The second entity data entry form is a club/team record.

Having previously created custom variables and a data source request to display a lookup form showing, filtering and sorting clubs, we are now moving on to creating a data entry form where a club can be created, read, updated and deleted (CRUD).

In our ReST API sample data set, the underlying restdb.io club is the Teams 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 club/team record

  • Link the key club/team 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 clubs/teams and drill down into a data entry form showing the club master record

  • Set the History Menu record summary

  • Test that we can lookup clubs and drill down into the club/team form, and that the history menu shows the club name

  • Add a master/detail grid to show all footballers who play for this club/team

  • Test that we can view all footballers who belong to this club/team

  • Create custom variables for each field

  • Add an 'update' data source for updating a single club/team record

  • Link the key club 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 club/team using the Update button

  • Add a 'create' data source for creating a single club record

  • Link the key club 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 club/team using the Add menu and Update button

  • Add a 'delete' data source for deleting a single club record

  • Link the key club 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 club/team using the Delete button

Last updated