Forum Discussion

JohnGainer's avatar
JohnGainer
Qrew Trainee
6 years ago

Using QB as a recruiting tool without adding a paid user.

I am exploring the utilization of QB as an initial repository of interested candidates for our company recruiting effort. I've created a separate table for candidates to upload their information and attachments using "everyone on the internet", but it appears that I have no way to actually allow them to add additional information or attachments if requested without creating a new record. Any suggestions?
roles and permissions
  • KingslySamuel's avatar
    KingslySamuel
    Qrew Cadet
    6 years ago
    Create a separate table for "documents" and link it to the table 'candidates' (one to many relationship). So, one candidate can upload many documents. And, you can pull an embedded report from table 'documents' into your 'candidate' table to show all documents uploaded by a candidate within their record.
  • KingslySamuel's avatar
    KingslySamuel
    Qrew Cadet
    6 years ago
    I am trying to attach a jpeg file to show you an example and it is not coming through properly
  • JohnGainer's avatar
    JohnGainer
    Qrew Trainee
    6 years ago
    How does that work though if days later HR requests additional documents to be uploaded? My current link only takes them to "+New Applicant". How do now direct them to upload linked to their file? Sorry, but I am a bit new to all of this.
  • LauraThacker's avatar
    LauraThacker
    Qrew Captain
    6 years ago
    Kingsly - as an "anonymous" user; the general public will not be able to edit their original entries or attach their documents to existing records without the permissions to see everyone else's records.  John - you will need to either have them submit their documents; entering key information about themselves (such as an email address) on each record so that you can "connect" the documents to their original resume entry more easily.  

    There are some solutions you could opt to build into your candidates table which might be able to offer you a solution; but they would be better discussed 1-on-1.
    • KingslySamuel's avatar
      KingslySamuel
      Qrew Cadet
      6 years ago
      Just wondering: Will it work if we define a user role with edit access just to only add additional documents into an existing profile and assign that role to "everyone on the internet,"  can they do it? 
    • LauraThacker's avatar
      LauraThacker
      Qrew Captain
      6 years ago
      A user even if they cannot see the "table" will still be able to see all the record-picker selections in a child-table record even if they have the ability to add a record.  This would not work for any HR department or business.  The candidate would need to upload their documents and enter in their contact information repeatedly on each record so that internally those records can be connected to the Candidates' original entry/resume.

      To make this work, an anonymous user would need to be provided with a code/key of some kind (generated by Quick Base) that would be unique (not simply an email address) that would enable them to access an existing record.  It could get quite complicated to allow them to access the data this way.  It would be simpler to have anonymous users enter their information in repeatedly and put the onus on the business to connect the records. 

      There are also more professional solutions to set this up; but they are non-native.