Want to use a google spreadsheet to fill in blogger post info.
$30-250 USD
Lezárt
Kiadva ekkor: több mint 7 évvel ezelőtt
$30-250 USD
Teljesítéskor fizetve
I want to use a Google spreadsheet to populate fields in a Blogger posts. Need someone to write the code and give me step by step instructions to get it up and running. Need to be available to walk me through if needed. This should be easy, most of the work has been done (see below). Uploaded image shows the Blogger post page with the fields I want to use.
This is what I have found online, but I can't seem to get it to work:
The Steps:
create spreadsheet in Google Drive or go to the spreadsheet created by your submission form
grab the docKey from the URL that looks like https://docs.google.com/spreadsheets/d/THE-KEY/edit#gid=0
use Row 1 in the spreadsheet to be the column headers that are used in the variables in the code. 1-word headers preferred for this example
go to File -> Publish to the Web, check "automatically republish when changes are made", and hit "start publishing"
The code example:
<script src='//[login to view URL]' type='text/javascript'/>
<script src='//[login to view URL]' type='text/javascript'/>
<script type='text/javascript'>//<![CDATA[
/**
this script was written by Confluent Forms LLC [login to view URL]
for the BlogXpertise website [login to view URL]
any updates to this script will be posted to BlogXpertise
please leave this message and give credit where credit is due!
**/
var docKey = '1Xg095tdG_9VY0b93FSh0eK52I2g6SjGg-g-pJ3u95YU'; // the docKey of your Google Docs spreadsheet
var insertAfter = '#Blog1'; // reference of object in your DOM to insert the object into
var objectType = '<div>'; // object that we'll be inserting as a container for the feed information
var objectID = 'thefeed'; // id of the object that is being inserted
var url = '[login to view URL]' + docKey +'/od6/public/values?alt=json';
$(document).ready(function(){
[login to view URL]('feeds', '1', { 'callback' : function(){
($.getJSON(url, 'callback=?')).success(function(data){
$(insertAfter).after(
$(objectType).attr('id',objectID)
);
var wrapper = $('#'+objectID);
$([login to view URL]).each(function(i,entry){
var name = [login to view URL]$name.$t;
var url = [login to view URL]$url.$t;
var type = [login to view URL]$type.$t;
var location = [login to view URL]$location.$t;
[login to view URL](
$('<ul>').append(
$('<li>').text(name)
).append(
$('<li>').text(url)
).append(
$('<li>').text(type)
).append(
$('<li>').text(location)
)
)
});
});
}});
});
//]]></script>
</head>
<body>
<div id='Blog1'>this won't be necessary in your actual implementation, placeholder for the Blog1 object</div>
</body>
</html>
Notes:
Please note that the first two lines will likely not be necessary in your template as they are likely already there. Add everything from <script type='text/javascript'>//<![CDATA[ to //]]></script> into your template, before </head>, to get it to work.
Contact me. I can help you.
I also have experience in working on a similar application.
I can get it done before deadline.
Let me know if you need any help?
Hi there! I'm sorry, but I have to ask you what is it exactly that you are trying to do?
I have quite a bit of experience with Google Script, but I can't really fathom, what would your entry data be and what king of result you are expecting.
Let's chat to clear that up, and then we can see about the price and timeline.
Cheers,
Denis
I believe I am the best candidate for this job because I am an experienced programmer and an experienced teacher. Although I mainly use Lua I also know how to use JavaScript and I believe I will be able to get the job done while teaching you how my code works.
I have good amount of experience in working with Javascript and jquery. I have already tried couple of solutions for the task and will be able to provide the solution within a day.