SEO Book Pro - General Customizer Overviewv

SEO Book Pro

General Customizer Overview

Theme Architecture Beta v1.0.97 Database 87


SEO Book Pro - General Customizer Overviewv

Get started with SEO Book Pro

SEO Book Pro Theme Structure

Theme Architecture Beta v1.0.97

Files and Directory Structure




Your SEO Book WordPress Custom Theme. Welcome to the documentation for Your SEO Book, a custom WordPress theme designed specifically for businesses and business services. This theme offers a range of features and functionalities to help you showcase your business services online effectively. Whether you are a small startup or a well-established company, Your SEO Book provides easy management and a straightforward setup process, even for users without coding skills.

Your SEO Book - Early Bird Access program - Version: Beta 1.0.98

Are you ready to take your website`s SEO and SERP rankings to new heights? We are thrilled to announce the upcoming release of Your SEO Book, the ultimate WordPress theme designed to boost your website`s visibility and drive organic traffic. As we work diligently to finalize the theme, we are excited to offer you an exclusive opportunity to join our Pre Sale and Early Bird Access program.

Welcome to the documentation for Your SEO Book, a custom WordPress theme designed specifically for businesses and business services. This theme offers a range of features and functionalities to help you showcase your business services online effectively. Whether you are a small startup or a well-established company, Your SEO Book provides easy management and a straightforward setup process, even for users without coding skills.

Note: This is a beta version, and not all features may work perfectly. If you encounter any bugs or issues, please report them to support@seobookpro.com.


Google App Script add a timestamp in speccific cell whenever a cell in column X of the “SheetName” is edited


2 min read
62 Views

Google App Script add a timestamp in speccific cell whenever a cell in column X of the “SheetName” is edited

How to add a timestamp in specific cell whenever a cell in column “Column A” of the “Sheet Name” is edited

The onEdit function you provided is designed to add a timestamp in the adjacent cell whenever a cell in column A or E of the “SheetName” sheet is edited.

To add a record to the same cell every time the sheet is edited, you could modify the function like this:


function onEdit() {
var sheet = SpreadsheetApp.getActiveSheet();
var cell = sheet.getRange("A1"); // change this to the cell where you want to add the record
if (sheet.getName() == "SheetName" && sheet.getActiveCell().getColumn() == 0) {
// if we're on the right sheet and editing column A
cell.setValue(cell.getValue() + "New Record Added on " + new Date());
}
}

In this version of the function, we’re setting the cell variable to the range of the cell where you want to add the record (currently set to cell A1, but you can change this to any other cell). Then, we’re checking if we’re on the “RESTAPI” sheet and editing column A. If those conditions are met, we’re appending a new record to the cell’s existing value, along with the current date and time.

Note that this will overwrite the existing value in the cell every time the sheet is edited. If you want to add a new record to the cell without overwriting the existing value, you’ll need to modify the code to retrieve the current value of the cell and concatenate the new record to it.


How to add record on same cells for every row in the table

If you want to add a record to the same cell for every row in the table, you can modify the onEdit function like this:


function onEdit() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var startRow = 2; // adjust this to the first row of the table
  var endRow = sheet.getLastRow(); // gets the last row of the sheet
  var cell = sheet.getRange("A2"); // change this to the cell where you want to add the record
if (sheet.getName() == "SheetName" && sheet.getActiveCell().getColumn() == 0) {
    // if we're on the right sheet and editing column A
    for (var i = startRow; i <= endRow; i++) {
      var rowRange = sheet.getRange(i, 1, 1, 5); // adjust the range to cover all columns in the table
      var rowValues = rowRange.getValues()[0];
      cell.offset(i - startRow, 0).setValue(rowValues.join(", ") + "New Record Added on " + new Date());
    }
  }
}

In this version of the function, we’re first setting the startRow variable to the first row of the table (assuming the table starts on row 2), and the endRow variable to the last row of the sheet. Then, we’re setting the cell variable to the range of the cell where you want to add the record (currently set to cell A2, but you can change this to any other cell).

Next, we’re checking if we’re on the “SheetName” sheet and editing column A. If those conditions are met, we’re looping through all the rows in the table using a for loop, and for each row, we’re getting the values of all the columns using getValues, joining them together into a string using join, and then appending a new record to that string along with the current date and time.

Finally, we’re using offset to set the value of the appropriate cell in the same row as the current row in the loop. Note that we’re subtracting startRow from i to get the correct offset, since offset uses a zero-based index.


Date Originally Published by | Last Modified on | 2 min read
63 Views

Article by: SEO Book Pro

Member  SEO Book Pro | SEO Book Pro has Published 77 Articles

Technical SEO refers to the practices and processes aimed at optimizing a website’s technical infrastructure to improve its visibility and ranking in search engine results pages (SERPs). This includes optimization of the website’s code, structure, content, and user experience.

SEO Book Pro Beta v 0.2.4 is a website audit dashboard designed to help with the technical SEO process. It provides an overview of a website’s strengths and weaknesses, highlighting areas for improvement and offering recommendations for optimization. The dashboard can be used to track and monitor a website’s performance over time, ensuring that it remains optimized and in compliance with search engine guidelines. Overall, the SEO Book Pro Beta v 0.2.4 website audit dashboard is a valuable webmaster tool for any website owner or digital marketer looking to improve their site’s technical SEO and search engine visibility.

Member Profile More Published Articles by SEO Book Pro

Popular Articles