My spreadsheet for bounty campaign if a help you.
In the spreadsheet there is a script
script code
function CopyTwitter ()
{
var sourceSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Bounty");
var destSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Report");
var rangesToClear = ['A19:J22'];
for (var i=0; i<rangesToClear.length; i++)
{
destSheet.getRange(rangesToClear[i]).clearContent();
}
sourceSheet.getActiveRange().copyTo(destSheet.getRange("A20"), {contentsOnly:true});
var range = sourceSheet.getActiveRange();
range.clear({ contentsOnly: true });
}
function CopyTwitterDate ()
{
var sourceSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Bounty");
var destSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Report");
var rangesToClear = ['A19:J22'];
for (var i=0; i<rangesToClear.length; i++)
{
destSheet.getRange(rangesToClear[i]).clearContent();
}
sourceSheet.getActiveRange().copyTo(destSheet.getRange("A19"), {contentsOnly:true});
var range = sourceSheet.getActiveRange();
range.clear({ contentsOnly: true });
}
(
https://docs.google.com/spreadsheets/d/1HL_5cj2suUxfgHSQbgBR8uxIiunem6e526d55Dw8WV4/edit?usp=sharing)
General view of spreadsheet
1. Today's date (automatically changed). time zone GMT + 00:00
2. Day of the week (automatically changed).
3. The name of the bounty campaign (link to bitcointalk description about bounty)
4. Where to submit a report (on bitcointalk, in the form of google, a report in one message on bitcointalk, on a third-party site (URL link)).
5. Shows information about today's work (Work changes automatically).
6. Information about the number of the week in bounty campaign.
7. When the date of the report appears, the Report information means you need to submit the report today (Report changes automatically).
8. Comments about bounty campaign, a summary of how many retweets or tweets you need, whether hashtag, etc.
9. In these cells, we specify the date when the first week ends, the second, the third, depending on how much the bounty campaign is and on what week we entered (
Fill required!!!!! when adding a new campaign bounty, if no information is added, the report reminder will not work) (filled in manually).
10. Creates a report of the tweets and retweets
11. Creates a report with Date, tweets and retweets (Date if need Is filled manually, depends on the form of the campaign bounty report)
12. In this line reTwitter, we specify how much and when we need to make retweets. String Twitter by analogy with reTwitter.
13. Twitter URL, reTwit URL to save links for report generation. Link to or retweet a tweet you want to insert in your cell when you made a retweet or a tweet.
More information on video, as working my spreadsheet
https://youtu.be/HY4B4Spg3_Ilink on spreadsheet (
https://docs.google.com/spreadsheets/d/1HL_5cj2suUxfgHSQbgBR8uxIiunem6e526d55Dw8WV4/edit?usp=sharing)
Avatar
