Tau Txais Ntawv Ceeb Toom Email Thaum Ib Qho Chaw ntawm ThingSpeak Tsis Tau Hloov Kho Ib Ntus: 16 Kauj Ruam

2024 Tus sau: John Day | [email protected]. Kawg hloov kho: 2024-01-30 09:24

Zaj dab neeg keeb kwm

Kuv muaj rau lub tsev cog qoob loo tsis siv neeg uas tau kis thoob Dublin, Ireland. Los ntawm kev siv cov kev cai tsim lub xov tooj ntawm tes app, Kuv tuaj yeem saib xyuas thiab cuam tshuam nrog cov cuab yeej siv tau yooj yim hauv txhua lub tsev cog khoom. Kuv tuaj yeem qhib / kaw lub qhov rais thaum qhov kub siab dhau / qis dhau; Kuv tuaj yeem pib / nres qhov dej thaum cov av noo qis / siab dhau; thiab kuv tuaj yeem pib / nres lub kiv cua qhov cua thaum huab cua noo siab dhau / qis. Lossis kuv tuaj yeem hloov pauv qhov system mus rau Hom pib, thiab zaub yuav saib xyuas tom qab los ntawm Arduino lub hlwb. Xav paub ntau ntxiv txog txoj haujlwm no tuaj yeem pom ntawm no -

Qhov kev sib txuas nyob deb rau Arduino cov laug cam ntawm rau lub tsev cog khoom tau ua tau los ntawm kev pab ntawm USB GPRS dongles, ib qho ntawm txhua qhov chaw (Kuv yuav kuv li ntawm no https://www.aliexpress.com/item/Unlocked-New-Huawei-E353 -E353s-2-Nrog-Antenna-3G-USB-Modem-21-6-Mbps-HSPA-Mobile/32979630201.html? Spm = a2g0s.9042311.0.0.44cb4c4dzVUThU). Raws li nws yog rooj plaub nrog cov ntaub ntawv xov tooj sib txuas (tsawg kawg hauv Dublin), nws poob qis, qee zaum rau ob peb feeb, qee zaum yuav yog ob peb teev. Yuav tsum muaj kev sib txuas poob qis, Arduino tau teeb tsa kom rov pib dua USB dongle txhua 10 feeb, rau nws kom sim pib qhov kev sib txuas tshiab. Qee zaum txawm li cas los xij, vim (tseem tsis tau paub) vim li cas, txawm tias GPRS cov ntaub ntawv sib txuas rov qab los, Arduino (thiab txuas Ethernet daim ntaub thaiv) tsis ua raws li qhov tshwm sim. Nov yog lub sijhawm kuv xav tau mus rau qhov chaw tshwj xeeb ntawd thiab rov pib dua txhua lub system.

Thaum cov ntaub ntawv sib txuas poob ntawm qee qhov chaw, Kuv xav kom ceeb toom los ntawm email sai li sai tau, yog li kuv yuav khaws qhov muag ntawm qhov chaw tshwj xeeb ntawd. Raws li kev sib txuas lus ntawm xov tooj app thiab Arduino tshwm sim los ntawm kev pabcuam online muab los ntawm https://thingspeak.com, txog thaum nyuam qhuav (thiab txog rau 31 Lub Peb Hlis 2019), qhov no ua tau los ntawm kev siv lwm qhov kev pabcuam los ntawm https:// ifttt.com/discover, thiab teeb tsa ThingHTTP thiab React ntawm txhua lub channel, saib xyuas qhov tseeb ntawm seb cov channel tshwj xeeb no tsis tau hloov tshiab rau qee lub sijhawm. Txawm li cas los xij, raws li email kuv tau txais los ntawm Google, pib nrog 31 Lub Peb Hlis 2019, vim tsis ua raws li lawv cov ntaub ntawv hloov tshiab tsis pub lwm tus neeg xav tau (https://cloud.google.com/blog/products/g-suite/elevating-user -trust-in-our-api-ecosystems), nkag mus rau qee cov ntaub ntawv hauv kuv tus lej Google yuav tsis muaj ntxiv rau IFTTT, thiab zoo li hauv kuv qhov xwm txheej email tsuas yog siv IFTTT nkaus xwb, kuv nkag siab yog qhov kev ceeb toom cov kev pabcuam piav qhia saum toj no yuav tsum tsis ua haujlwm.

Yog li ntawd, ntawm no peb yog, siv lwm txoj hauv kev los daws qhov email ceeb toom kom tuaj txog thaum cov ntaub ntawv txuas ntawm kuv qhov chaw poob. Qhov no tseem siv ThingHTTP thiab React nta ntawm kuv cov channel, tsuas yog txuas rau IFTTT tau rov taw qhia rau Google Drive. Yog li sib nrug los ntawm kho vajtse (Arduino hauv kuv qhov xwm txheej) koj yuav muaj kev sib txuas lus nrog koj tus account ThingSpeak, koj yuav tsum tsim tus lej Google, uas yog koj tsis muaj ib qho … thiab pib!

Kauj ruam 1:

Hauv Google Drive

Ua ntej, hauv Google Drive (https://drive.google.com) peb yuav tsum tsim daim ntawv nthuav tawm thiab daim ntawv yooj yim. Qhib koj lub Google Drive, thiab nyem rau ntawm Tshiab - Google Ntawv - Cov ntawv nthuav dav dawb paug.

Kauj ruam 2:

Kuv tau hloov kuv lub npe "Qhov chaw nyob hauv daim ntawv teev npe". Tom qab ntawd mus rau Cov Cuab Yeej - Tsim daim ntawv.

Kauj ruam 3:

Kuv hloov npe daim ntawv ua "Chaw nyob hauv daim ntawv", thiab hloov "Cov lus nug tsis muaj npe" mus rau "xwm txheej", thiab hom los ntawm "Kev xaiv ntau yam" mus rau "Cov lus teb luv".

Kauj ruam 4:

Tom qab ntawd kuv tau tshem qhov kev xaiv rau sau email chaw nyob - nyem rau "Hloov chaw", thiab tsis txheeb xyuas txhua qhov kev xaiv hauv lub qhov rai uas pom. Nyem rau "Txuag".

Kauj ruam 5:

Kaw qhov browser tam sim no tab uas tuav koj daim ntawv, thiab koj yuav tsum rov qab mus rau koj lub ntsiab Google Drive tab, qhov uas koj yuav tsum muaj ob daim ntawv thiab daim ntawv uas koj nyuam qhuav tsim. Qhib daim ntawv nthuav qhia, thiab mus rau "Cov Ntaub Ntawv - Qhia …". Hauv lub qhov rai tshiab nyem rau ntawm "Advanced"

Kauj Ruam 6:

Tom qab ntawv nyem rau "Hloov …" ib sab ntawm "Ntiag Tug - Tsuas yog koj tuaj yeem nkag tau" daim ntawv lo

Kauj ruam 7:

thiab hloov mus rau "On - Txhua tus neeg uas muaj qhov txuas", thiab tseem rau "Can edit"

Kauj ruam 8:

Nyem rau "Txuag" thiab "Ua tiav" kom rov qab mus rau koj daim ntawv teev npe. Thaum nyob ntawd, nyem rau "Cov Ntaub Ntawv - Tshaj tawm rau lub vev xaib …", thiab tom qab ntawd nyem rau "Tshaj Tawm", thiab "OK" rau lub qhov rai sib tham. Kaw qhov "Publish to the web" window.

Thaum tseem nyob hauv daim ntawv nthuav qhia, nyem rau ntawm "Form - Go to live form". Txoj cai-nyem nrog koj tus nas (Kuv tab tom siv Google Chrome browser) thiab xaiv "Saib nplooj ntawv qhov chaw".

Kauj ruam 9:

Hauv nplooj ntawv tshiab uas qhib tshawb rau "daim ntawv ua" thiab tom qab ntawd nrhiav qhov txuas uas zoo ib yam li https://docs.google.com/forms/d/e/XXXXXXXXXXXXXXXXXXXXXXX/formResponse. Xaiv qhov txuas ntawd, thiab theej thiab muab nws tso rau qee cov ntawv sau. Koj yuav siv nws los tsim qhov txuas kawg uas xav tau nkag mus rau hauv ThingHTTP rau ThingSpeak.

Kauj ruam 10:

Rov qab mus rau qhov chaw pom ntawm koj daim ntawv, thiab tam sim no tshawb rau "nkag." Nrhiav thiab xaiv tag nrho cov ntawv, qee yam xws li "entry. XXXXX". Luam thiab muab nws tso rau hauv tib daim ntawv ntawv raws li saud. Tam sim no koj tuaj yeem kaw qhov pom ntawm koj daim ntawv Google.

Kauj ruam 11:

Hauv kab ntawv tshiab (qhov chaw koj tam sim no muaj qhov txuas thiab nkag uas peb tau sau ua ntej), tsim qhov kawg txuas, uas yuav tsum zoo li

docs.google.com/forms/d/e/XXXXXXXXXXXXXXXXXXXXXXX/formResponse?entry. XXXXX = LOCATION+NAME & xa = Xa

Hauv kuv qhov xwm txheej, "LOCATION+NAME" yuav raug hloov los ntawm lub npe tiag tiag ntawm txhua qhov chaw tshwj xeeb uas kuv xav tau los saib xyuas. Cov ntawv ceeb toom email uas kuv yuav tau txais thaum kev txuas txuas poob yuav muaj cov ntawv no, yog li kuv paub tseeb tias qhov chaw muaj teeb meem li cas. Qhov ntawv no yuav raug xa tawm raws li cov ntawv luv-ntsiab lus rau qhov "xwm txheej" teb hauv Google daim ntawv. Qhov "& xa = Xa" yuav ntsiag to xa daim ntawv, tsis tas yuav xav tau kev nqis tes ua ntxiv, thaum thov los ntawm ThingHTTP thiab React.

Thaum kawg, peb yuav tsum ntxiv ib tsab ntawv uas yuav xa email ceeb toom txhua lub sijhawm nkag nkag tshiab tau ntxiv rau hauv daim ntawv nthuav tawm. Qhib daim ntawv nthuav qhia, thiab tom qab ntawd nyem rau "Cov cuab yeej - Tus kws sau ntawv". Hauv lub qhov rai tshiab uas qhib ntxiv cov cai hauv qab no (nrog rau qhov hloov pauv xav tau los xav txog koj cov kev xav tau):

muaj nuj nqi tshiabEntryNotification (e)

{

sim

{

var timestamp = e.values [0];

var qhov chaw = e.values [1];

var cov lus = qhov chaw + 'qhov chaw nyob DAWS / n' + lub sijhawm;

MailApp.sendEmail ("Koj li email chaw nyob", "Ua tib zoo xav, qhov chaw DOWN!", Xov)

}

ntes (e)

{

MailApp.sendEmail ("Koj li email chaw nyob", "Yuam kev - Ua tib zoo saib, qhov chaw DOWN!", E.message);

}

}

Hloov cov ntawv "Koj li EMAIL chaw nyob" nrog email chaw nyob qhov twg yuav tsum xa ntawv ceeb toom mus, thiab cov lus ceeb toom tiag tiag, yog tias koj xav tau.

Kauj ruam 12:

Tsab ntawv no yuav tsum tau tshwm sim thaum nkag tshiab tau ntxiv rau hauv daim ntawv nthuav tawm. Thaum nyob hauv tib lub qhov rai (nrog rau tsab ntawv sau saum toj no), nyem rau ntawm lub cim "stopwatch" nyob rau hauv lub cuab yeej bar - "Tam sim no txoj haujlwm tau ua". Koj yuav raug nug kom sau koj lub phiaj xwm (Kuv lub npe hu ua kuv "qhov chaw nyob"), thiab lwm lub browser tab yuav qhib, tshaj tawm tias tsis muaj txiaj ntsig (tsis muaj qhov ua rau pom). Nyem rau ntawm "tsim tus txhais tshiab".

Kauj ruam 13:

Hauv lub qhov rai tshiab, xaiv "Los ntawm daim ntawv nthuav qhia" rau "Xaiv qhov tshwm sim qhov chaw"; "Ntawm daim ntawv xa" rau "Xaiv hom kev tshwm sim"; "Qhia rau kuv tam sim" rau "Ua tsis tau qhov chaw ceeb toom". Nyem rau "Txuag". Koj yuav raug hais kom nkag mus rau hauv koj tus lej Google, thiab "Tso Cai" rau qhov ua rau nkag mus rau koj tus as khauj thaum xav tau.

Kauj ruam 14:

Tam sim no koj yuav tsum muaj qhov tshwm sim hauv cov npe ua, uas yuav txuas rau tsab ntawv peb tau tsim yav dhau los. Yog li ntawd, thaum ntxig cov ntaub ntawv tshiab rau hauv daim ntawv nthuav qhia (siv daim ntawv txuas tsis siv neeg thiab txoj hauv kev uas tsis tau piav qhia saum toj no), tus txhais lus yuav hu tam sim ntawv, uas yuav xa ntawv ceeb toom rau tus email chaw nyob, uas muaj koj cov lus xaiv.

Peb tau ua tiav hauv Google Drive sab, thiab tam sim no peb tab tom txav mus rau ThingSpeak.

Kauj ruam 15:

Hauv ThingSpeak Nkag mus rau hauv koj tus account (https://thingspeak.com/login), mus rau "Apps - ThingHTTP", thiab tom qab ntawv nyem rau "New ThingHTTP". Muab nws lub npe (Kuv tau xaiv lub npe tiag tiag ntawm txhua qhov chaw; "MyLocationName" rau lub hom phiaj ntawm qhov kev qhia no), thiab hauv "URL" teb, muab qhov txuas los ntawm koj cov ntawv sau, ib qho uas zoo li

docs.google.com/forms/d/e/XXXXXXXXXXXXXXXXXXXXXXX/formResponse?entry. XXXXX = LOCATION+NAME & xa = Xa

Tawm tag nrho lwm qhov chaw raws li lawv muaj, thiab nyem rau ntawm "Txuag ThingHTTP".

Kauj ruam 16:

Tom qab ntawd mus rau "Apps - React", thiab nyem rau "New React". Muab nws lub npe (ntxiv, kuv tau xaiv lub npe chaw nyob tom qab lo lus "hnov mob", tab sis koj tuaj yeem xaiv lub npe koj xav tau); "Tsis Tshawb Xyuas Cov Ntaub Ntawv" rau "Hom Mob"; "Txhua 10 feeb" rau "Xeem Zaus"; lub npe channel uas koj xav saib xyuas rau qhov hloov tshiab, rau "Yog Channel"; lub sijhawm uas cov channel tsis tau hloov tshiab (Kuv tau xaiv 15 feeb), rau "tsis tau hloov tshiab rau"; "ThingHTTP" rau "Ua"; "MyLocationName" rau "tom qab ntawd ua ThingHTTP"; "Ua haujlwm nkaus xwb thawj zaug qhov xwm txheej tau ntsib", raws li kuv tsuas xav tau txais kev ceeb toom ib zaug. Qhov no yuav rov pib dua nws tus kheej thaum cov channel tau hloov kho dua nrog cov ntaub ntawv nkag tshiab. Nyem rau "Save React" thiab koj ua tiav.

Txij tam sim no thaum koj cov channel tsis tau hloov tshiab rau 15 feeb (lossis lwm lub sijhawm, nyob ntawm seb koj tau xaiv dab tsi), React yuav ntes qhov kev zam uas yuav ua rau ThingHTTP, uas nyob rau hauv yuav ntsiag to tsim qhov nkag tshiab hauv koj daim ntawv nthuav tawm. Qhov pib thiab tsab ntawv ntawm Google Spreadsheet yuav coj nws los ntawm qhov ntawd, raws li tau piav qhia saum toj no.