Printing time and date of chatbot input on Sheets
# š¤helpp
prehistoric-sunset-38002
07/30/2023, 5:42 AMHey guys, Iām currently building a chatbot that captures customer info (email, phone number etc) onto Google Sheets via Zapier.
Iāve successfully done it but I canāt get the date and time of the customerās input onto the Google Sheets. Would appreciate some help and advice.
r
red-photographer-71993
07/30/2023, 11:00 AMcreate a field in your sheet for the date and then you can put: =TEXT(NOW(),"dd/mm/yyyy hh:mm") in your field value in zapier for the field you just created. This should pass the date as a static value.
f
few-shoe-27407
07/30/2023, 5:52 PMThis is what I use in my bot :
const A = Date.now();
const date = new Date(A);
ChatStartTime = `${date.getFullYear()}${date.getMonth() + 1}${date.getDate()}${date.getHours()}${date.getMinutes()}${date.getSeconds()}`;
few-shoe-27407
07/30/2023, 5:52 PMwill output : 202373017164
few-shoe-27407
07/30/2023, 5:52 PMYYYYMMDDHHMMSS
b
brave-continent-4436
07/30/2023, 11:51 PMgreat!!, but, the output only shows 12 digits is that correct?
p
prehistoric-sunset-38002
07/31/2023, 8:26 AMDo you add these as "Execute code"? And also, with this do I need to use Zapier to capture the output of these as well?
prehistoric-sunset-38002
07/31/2023, 8:28 AMThanks for the reply, but that's not what I'm looking for, because the time will reset to CURRENT time, which is not what I'm looking for.
I'm looking to capture the exact time of the input that was typed into the chatbot, so the appointment setter knows exactly when did the customer "spoke" to the chatbot.
prehistoric-sunset-38002
08/01/2023, 4:14 AMhttps://www.youtube.com/shorts/G8pZyPuGlOY
Found out the solution here if anyone wants to refer
f
few-shoe-27407
08/02/2023, 10:35 PMYes, run the code in an Execute code thing. So your timestamp will be in var date. You can then use it in your flow(s) or send it to Google sheets etc... you just have to write the var containing your timestamp somewhere . Hope this helps.