+1
Petit improvement to Google Sheets Add-on & learning from it
Dear XTRF team and community,
I love the Google Sheets XTRF Add-on, and it would be great if:
1. You add to the "Autorefresh" option the possibility of defining the frequency of autorefresh. Currently is every hour, and would be awsome if that value could be entered by the user, or at least having some options, like: every 1, 6, 12, 24, 72 hours.
2. Also, if possible, would like to learn what would be the ideal combination of API requests for recreating the behavior that the Add-on performs? I am needing to do this to customise a bit my use of it and would really appreciate your guidance in this.
Thanks!
Customer support service by UserEcho
Hi Jose.
Before XTRF created the Google Sheets Add On, I connected XTRF via API to Google BigQuery and once a day do a data dump from XTRF to BQ. Then I connect BQ to google sheets. That works well for me. I've tried the Google Sheets Add On too, but the BQ integration is more robust and can handle bigger data sets much quicker.
Not sure if that was input you were looking for.
M
Hey Mark! Much appreciated, never tried BigQuery and now it seems I'll give it a try!
I'm trying to replicate the behavior of the XTRF Add-on using the GET request "/browser/csv". I'm getting an issue with eternal "loading". It seems to work fine with some smart views related to client views, but not with others, like projects or jobs. Any clues?
Cheers!
I'll start by saying that I'm not the programmer, I have a developer that has set this up for me. So, I'm not the person to answer your question. But just so you know, what we set up is we have smart views that we set up the data to transfer from XTRF to Big Query every day. We have a smart view for Projects, Quotes, Jobs, Invoices, Vendors, and Clients. But the connection to Sheets is a native connection between Sheets and BQ. So there is no programming there. Only to get the data from XTRF to BQ.
Perfect, thanks a lot, Mark. I will try Big Query for sure :)
let me know how it goes. And if you're looking for a developer, I'm happy to introduce you to mine.
Hey Mark!! excuse my delay in replying, was off for some days.
Of course! I would love if you introduce me to your developer! Really appreciated :) Feel free to message me to jose(at)all-in.global
Thanks!!