DocType Naming and Linking
Then let us create the other DocType and save it too:
- Library Member (First Name, Last Name, Email Address, Phone, Address)
Naming of DocTypes
DocTypes can be named in different ways:
- Based on a field
- Based on a series
- By controller (code)
This can be set by entering the Autoname field. For controller, leave blank.
Search Fields: A DocType may be named on a series but it still needs to be searched by name. In our case, the Article will be searched by the title or the author name. So this can be entered in search field.
Title Field: You may need to specify a
Title Fieldfor any custom DocType. Failing to do so may raise this issue. It can be found under DocType > [DoctType Name] > View Settings
Link and Select Fields
Foreign keys are specified in Frappe as Link type fields. The target DocType must be mentioned in the Options text area.
In our example, in the Library Transaction DocType (shown in the Complete the Models section) below, we have to link both the Library Member and the Article.
Note: Remember that Link fields are not automatically set as Foreign Keys in the MariaDB database, because that will implicitly index the column. This may not be optimum hence the Foreign Key validation is done by the Framework.
For select fields, as we did when creating the Article DocType, add the various options in the Options input box, each option on a new row. This time we use the DocType as the option.
Similary complete making the other models.
A standard pattern is when you select an ID, say Library Member in Library Membership, then the Member's first and last names should be copied into relevant fields in the Library Membership Transaction.
To do this, we can use Read Only fields and in Options (or Fetch From in new revision), we can set the name of the link and the fieldname of the property we want to fetch. For this example in Member First Name we can set
Complete the Models
In the same way, you can complete all the models so that the final fields look like this:
Set Fetch From field for Member First Name as
library_member.first_name as it is a Read Only field as shown above in Linked Values. Similarly, do it for Member Last Name.
Make sure to give permissions to Librarian on each DocType