After chugging through my app to finally get it working, I’ve managed to integrate it with my Google sheets without any trouble. However, the times that I’m recording on my app and then transferring into my sheet is coming back as an entire data and time with seconds. I just want it in the format h:mm AM/PM.
I’ve tried formatting the sheet, but it overwrites it. I’ve tried using the zapier formatting app to try and process the dates before going to the sheet and can’t seem to get that to work either.
Here’s a trick. Instead of just sending the output of the zap to Google Sheet, send this equation instead:
=query(split(“[date]”," "),“select Col1”)
where [date] is date sent by Bubble.
Basically, that tells the Google sheet “Take this string, find the space, then only keep everything before the space”. You’ll then up with just the date on your Google Sheet.
Your fix works perfectly for the date however, I am trying to just be left with the time. I changed the query to search for column2 instead of 1, but that just gives me 12:00 no matter what time it may actually be. Any other tricks you may know of?
I had to mess around with the column number a little more to understand. But I did manage to get it working. One last thing is there any way I can remove the seconds from the time stamp?
Currently, the time appears (with your split function) as hh:mm:ss AM/PM. Any way I can remove the seconds?