It is possible to build this workflow by using one of these options:
Form
The form has an option that allows you to add a login page to your form. When enabled, it'd allow users to create new profiles to sign up if they don't exist already.
Portal
The portal also allows users to see their existing records and add new ones.
Related