App: google drive, airtable, hubspot, gmail, cloudconvert
Linking app: Zapier or any other apps
Requirement:
For candidates
• When the system receive candidates’ email
- IF { mail include attachment && attachment name contain “[login to view URL]” }
1. Automatically add to hubspot
2. Save file attachment to folder (Human Resource\#Draft Convert )
3. Reading file và get value
4. Change the file's name by getting value name file with format [login to view URL]
5. Update value to airtable
6. Create a new folder with the name as same as column ID on Airtable (Field ID formula: “CV”&”auto”&”_”&name), parent folder is Human Resource\Candidate
7. Update file to Cloud Convert for converting into file pdf, keeping original name
8. Move file to recent folder that created at step 6.
9. Update to airtable column CV with format is : [login to view URL] ”ID (file ID after upload to google drive)”.
- IF { mail có attachment && attachment name contain “_CV. non-xlsm”}
Airtable setting (update, format values). The format of columns already set.
• Name:
• CV: [login to view URL] ”ID of file after uploading into drive”.
• Gmail: [login to view URL] “email”
• Mail:
• Phonenumber
• Birthday
• Social network: format là -Facebook: value
• Address: district value
• Foreign language profiency: In file excel, If A is speaking English, it will be display as : English speaking (A), etc
• Certificate: format is multiple select. Including certificate at foreign language và Certificate and Achievement. Each value is one option
• Education: equal to type in excel file
• Major
• Skill: In the excel file, if the skill is Java with S level and 2 years experience. It'll be display as Java (S/2). The format will be.
- Skill (level/year)
- Skill (level/year)
- Skill (level/year)
- Skill (level/year)
…..
• Experience: Display as below
-From~to: company name
-From~to: company name
-From~to: company name
………
For company/ employer
1. Fill in job description file.
2. Save to the Human Resource\#Draft Convert.
3. The system will read the file and get data
4. Update the values on the airtable
5. Create a new folder named field ID in the airtable (Field ID formula: "JD" & "auto" & "_" & company name & position), the parent folder is Human Resource\Job Description.
6. Upload file to cloud convert to convert to pdf file, keep the name
8. Put the file in the new folder created in step 5.
9. Update to airtable column file with format: [login to view URL] "File ID after uploading to drive".
Read the file, get value and update the airtable.
Airtable setting (values need to update and format). Column format is already set.
The value getting from company just update directly into the equivalent column on airtable.
- Job description: Update value directly in airtable
• Type: type in excel
• Position: job title
• Salary range: salary
• Traning: tick if the value display in excel file “ yes” and vice versa
• Probation: tick if the value display in excel file “ yes” and vice versa
• Company: company name
• Business trip: tick if the value display in excel file “ yes” and vice versa
• Certificate: Format is multiple selection. Values in file excel will be separated by “ ,”. Each value will be a option.
• Status: available
• Result: Finding candidate
• The other column just update data.
chúng tôi đã thảo luận rồi............................
chúng tôi đã thảo luận rồi............................
chúng tôi đã thảo luận rồi............................
Relevant Skills and Experience
javascript,
Proposed Milestones
₫5000000 VND - for all
₫5,000,000 VND in 6 days
5.0 (8 reviews)
3.8
3.8
6 freelancers are bidding on average ₫8,085,185 VND for this job
Worked in similar jobs. expert in Python, Automation, Linux, expert dev.
Relevant Skills and Experience
7 years of experience, in Python, Linux, etc
Proposed Milestones
₫3444444 VND - lets chat
We already had done something like this before
As i saw your project description i can assure you that your project will be completed on time.
Relevant Skills and Experience
Dedicated developers will be provided with daily reports.
Proposed Milestones
₫3444444 VND - This is not fixed so we can discuss about the milestone :)
Hello
we have extensive knowledge and 5+ years of experience in Website Design and development, Mobile app development, SEO,PHP Bootstrap Material Css Mysql Oracle Mongo DB Manymore
Relevant Skills and Experience
Javascript, CSS, PHP,HTML
Proposed Milestones
₫3444444 VND - First milestone