Peruttu

Zapier: Read and get value from excel file.

- I need a freelancer who have knowledge about zapier. The trigger of the zap is when the new file is upload to a specific folder in google drive => Filter: Continue if name of the file contain _Cv.xlsm. => Code: Read the file and get these value (Full name, birthdate, district, phonenumber, email, education type, certificate, facebook, desired salary, desired company). => Airtable: Update these value on airtable.

* Airtable setting:

- “CV” table: update above value to this table

- “Language skill” table: English speaking (A), English speaking (B), …., English writing (A), English speaking (B),… Just like that.

- Foreign language profiency field is link to language skill table.

* Other field like birthday, name,district, etc is simple. Just update the value in airtable. But watch out fot these field.

- 1. Foreign language profiency field: link to “language skill” table

In excel file If English speaking level is A => In proportion to “English speaking (A)”, English writing level is B- => In proportion to “English writing (B-)”.

- 2. Certificate:

This field contain both the certificate value in Foreign language and Certificate and Achievement in excel file (only count if the type is certificate). The column format is multiple select with each certificate is one option.

- [url removed, login to view]

The format is Long text with text format is for example. In excel file, java skill is level S and 6 years experience => Display as java (S/6). The format is like below.

- Java (A/6)

- php(B,5)

- [url removed, login to view]

Column is longtext with text format is

- From – to (value in excel file) : <company name>

- From – to (value in excel file) : <company name>

Because 3 app zap required at least starter plan. So if freelancer need I’ll lend my zapier account.

Taidot: Javascript, Python

Näytä lisää: php excel file load database update insert data, read selected excel file vb6, read existing excel file cnet, read write excel file, read form excel file visual basic, read data excel file using winapi, read data excel file insert mysql using aspnet, read modify excel file using php script, read write excel file visual basic, vbscript search value excel file, upload read save excel file database, asp vbscript read update excel file, perl script read data excel file, read local excel file using html vbscript, system read data excel file, read data excel file

Tietoa työnantajasta:
( 0 arvostelua ) Ho Chi Minh, Vietnam

Projektin tunnus: #15802861

5 freelanceria on tarjonnut keskimäärin 540000 ₫ tähän työhön

MyAwesomeTeam

How are you, hoatt?. Do you need a freelancer who have knowledge about zapier ?.I sure i can help you We have experience in thoses skills: Javascript, Python. **Why you should choose me to d Lisää

1000000 ₫ VND 4 päivässä
(3 arvostelua)
2.8
kkc1985612

Hello. I’ve carefully gone through your job post. I have more 8+ years experience in Web development .I am very much interested in your project with all of your requirements. I feel very confident on your project Lisää

550000 ₫ VND 1 päivässä
(2 arvostelua)
0.8
200000 ₫ VND 4 päivässä
(0 arvostelua)
0.0
nareshbabral

A proposal has not yet been provided

400000 ₫ VND 5 päivässä
(0 arvostelua)
0.0
lolamaret

Dear sir. As i am a Senior Software Developer, I am going to make your project by using python I have a lot of rich experience include C++, C# , java , Python, Android, Web , Database. Stay tuned, I'm still working o Lisää

550000 ₫ VND 1 päivässä
(0 arvostelua)
0.0