|
Title: Stakes/tokens autotracking Post by: Zashibu on March 25, 2018, 12:35:41 AM If bountyhunter tracks many bointies, it's real pain to track stakes/tokens in spreadsheets.
How to track all your stacks in every bounty automatically? 1. Create new google spreadsheet, or use new tab in regular bounty spreadsheet. For example created free google spreadsheet(link in the end of this post). I'm choosed one of my first bounties https://imgur.com/9yGDCS5 (https://imgur.com/9yGDCS5) 2. Choose your bounty for tracking. In example its XYO bounty. Find own row in XYO spreadsheet. https://imgur.com/aM1qhBi (https://imgur.com/aM1qhBi) Tab Facebook, my number 67. Need to copy spreadsheet address (selected with red border on the screenshot) 15jG0vRch4BUm0rGIDeAqHZjaPrYgXqtv3LU6t-oVy0A. And we prepared 2 code strokes for export. 3. First for the export in your table: IMPORTRANGE("15jG0vRch4BUm0rGIDeAqHZjaPrYgXqtv3LU6t-oVy0A", "Facebook!A1:P1") https://imgur.com/T4sSU2D (https://imgur.com/T4sSU2D) This code export in your table first row from XYO/Facebook spreadsheet 4. Next code stroke with your XYO table number(67): second row: =IMPORTRANGE("15jG0vRch4BUm0rGIDeAqHZjaPrYgXqtv3LU6t-oVy0A", "Facebook!A67:P67") This code export in your table your row from XYO/Facebook spreadsheet https://imgur.com/2wZaqCP (https://imgur.com/2wZaqCP) 5. If you joined in other campaignes (twitter, newsletter, youtube etc) just add rows, change tab names and your number in this tabs. Now all changes with stakes/tokens you see right in your own table. Here's a final screen: https://imgur.com/9yGDCS5 (https://imgur.com/9yGDCS5) Check table here: https://docs.google.com/spreadsheets/d/1DjlrBqKZPtGIh_pWZA4w_yKMLgRkdd67OVZJpPhm_sQ/edit#gid=0 Title: Re: Stakes/tokens autotracking Post by: Wallflower28 on March 25, 2018, 12:47:53 AM Thanks for information, it really helps a lot to us specially if we joined a lot of social media campaigns. But I guess it does not applied to the user who used in android phone only like me. Well, I will mark this thread in order for me to track my activities soon if I have computer.
Title: Re: Stakes/tokens autotracking Post by: vjmarcus on May 07, 2018, 12:10:16 PM Thank you, useful information! It is a pity that it is impossible to automate...
Title: Re: Stakes/tokens autotracking Post by: Zashibu on May 07, 2018, 12:11:25 PM Thank you, useful information! It is a pity that it is impossible to automate... thanks man) Title: Re: Stakes/tokens autotracking Post by: alimarh on May 07, 2018, 12:55:13 PM Thanks for the share man, I have tired and tired to implement it as you said but keep getting error message, I guess I will need to spend more time to understand it or do a bit Google research to know how to implement it. this will really save me a whole of stress and data. thanks again
Title: Re: Stakes/tokens autotracking Post by: Zashibu on May 07, 2018, 01:14:24 PM Thanks for the share man, I have tired and tired to implement it as you said but keep getting error message, I guess I will need to spend more time to understand it or do a bit Google research to know how to implement it. this will really save me a whole of stress and data. thanks again check if you have any spaces - it's a main reason for error message, try to copy my code and just replace table part and numbers |