How can I add a timestamp column to a connection to show the time of the import?

You can add a column to your imported sheet that holds the timestamp of the last import time. To do so, please enable a QUERY filter while creating or editing a connection. The QUERY statement is as follows:  

SELECT NOW(), A,B,C,D label NOW() 'Timestamp'

In this example, we only select column A, B, C, and D. Please change these columns to match your selection.

Have more questions? Submit a request


Please sign in to leave a comment.