Editrac

editrac

Introduction: In many collaborative environments, managing access to specific data in Google Sheets is critical for maintaining data accuracy and privacy. This article demonstrates how to create a system where users can edit specific cells only after providing their details. We'll achieve this using Google Apps Script, a powerful automation tool for Google Sheets. Setting Up the Google Sheet: To get started, create a Google Sheet, and structure it to include user details. For this example, we'll use columns for "Name," "Email," and "Details." The "Details" column will be used to indicate whether users have provided their details. The Role of Google Apps Script: Google Apps Script is at the heart of our solution. This scripting tool allows us to automate tasks in Google Sheets. In this case, it will help control cell access and track user edits. We'll begin by creating a script that checks if users have provided their details. This script will grant edit access to specific cells once a user's details are confirmed. Script to Manage Cell Access: function onEdit(e) {
  var sheet = e.source.getSheetByName("YourSheetName");
  var editedRange = e.range;
  var username = Session.getActiveUser().getEmail();
  var timestamp = new Date();

  // Check if user's details are in place.
  var detailsRange = sheet.getRange("B2:B10"); // Adjust to your specific details range.
  var userRowIndex = detailsRange.createTextFinder(username).findNext().getRow();

  if (userRowIndex > 0) {
    // Grant edit access to specific cells (e.g., columns C and D).
    var editRange = sheet.getRange(userRowIndex, 3, 1, 2);
    var protection = editRange.protect();
    protection.removeEditors(protection.getEditors());
    protection.addEditor(username);
  }
} This script, when triggered by an edit event, checks if a user's details are in the "Details" column. If found, it grants edit access to specific cells (e.g., columns C and D). Users can edit only after their details are confirmed. Making a Special Google Sheet With a "Lock Cells" Button Imagine you have a special Google Sheet where you want to let people fill in some information, but only after they tell us who they are. This article will show you how to do it, and we'll even add a "Lock Cells" button to make it easier! Step 1: Create Your Google Sheet First, open Google Sheets. Click on extensions Make a new sheet, and add some columns for names, emails, and other stuff. Step 2: Use a Magic Script (Google Apps Script) Google Apps Script is like magic for your Google Sheet. It can do things for you automatically. Here's a special script we'll use. It checks if someone has shared their name and email. THE NAME OF THE SHEET MUST MATCH WITH THE “YourSheetName“ IN THE CODE function onEdit(e) {
  var sheet = e.source.getSheetByName("YourSheetName");
  var editedRange = e.range;
  var username = Session.getActiveUser().getEmail();
  var timestamp = new Date();

  // Check if someone shared their details.
  var detailsRange = sheet.getRange("B2:B10");
  var userRowIndex = detailsRange.createTextFinder(username).findNext().getRow();

  if (userRowIndex > 0) {
    // Let them edit special cells (e.g., columns C and D).
    var editRange = sheet.getRange(userRowIndex, 3, 1, 2);
    var protection = editRange.protect();
    protection.removeEditors(protection.getEditors());
    protection.addEditor(username);
  }
} Step 3: Add a "Lock Cells" Button We'll make it even easier. Let's add a "Lock Cells" button to your Google Sheet. So, when someone wants to lock their cells, they just need to click the button. function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('Lock Cells Menu')
    .addItem('Lock Your Cells', 'lockYourCells')
    .addToUi();
}

function lockYourCells() {
  // This is where we lock the cells when someone clicks the button.
  // They can only click it after sharing their details.
} Here is the complete code if you do not want to create two separate codes. Save the script, and click on “Run.“ The system will give you the prompt below. The complete code: function onOpen() {
  var ui = SpreadsheetApp.getUi();
  var currentUserEmail = Session.getActiveUser().getEmail();
  
  if (currentUserEmail === "admin@example.com") {
    ui.createMenu('Lock Menu')
      .addItem('Lock Cells', 'showDialog')
      .addToUi();
  }
}

function showDialog() {
  var ui = SpreadsheetApp.getUi();
  var result = ui.prompt(
    'Lock Cells',
    'Enter the cell range to lock (e.g., A1:A10):',
    ui.ButtonSet.OK_CANCEL
  );

  if (result.getSelectedButton() == ui.Button.OK) {
    var rangeToLock = result.getResponseText();
    lockCells(rangeToLock);
  }
}

function lockCells(rangeToLock) {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var activeSheet = spreadsheet.getActiveSheet();

  // Lock the specified cell range.
  var protection = activeSheet.getRange(rangeToLock).protect();
  protection.removeEditors(protection.getEditors());
  protection.addEditor(Session.getActiveUser());

  // Apply a background color to indicate locked cells.
  var lockedColor = '#e6e6e6'; // Light gray color.
  var range = activeSheet.getRange(rangeToLock);
  range.setBackground(lockedColor);
  
  // Create a time-based trigger to unlock the cells after 3 minutes.
  ScriptApp.newTrigger("unlockCells")
    .timeBased()
    .after(3 * 60 * 1000)  // 3 minutes in milliseconds
    .create();
}

function unlockCells() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var activeSheet = spreadsheet.getActiveSheet();
  
  // Define the range of cells to unlock, matching the locked range.
  var rangeToUnlock = "A1:A10";  // Adjust this to your specific range.

  // Remove the protection and clear the background color.
  var protection = activeSheet.getRange(rangeToUnlock).protect();
  protection.remove();
  activeSheet.getRange(rangeToUnlock).setBackground('');
} In this script: The admin can click "Lock Cells" to lock the specified cells and apply the background color. After locking, a time-based trigger is created to run the function after 3 minutes. unlockCells Set the background color after effectively unlocking the cells. Only the admin/you will see the LOCK MENU Replace "admin@example.com" With the Actual Admin's Email Address in the Code. Step 4: Make a Schedule You want the cells to lock themselves at a certain time, like bedtime. We'll use a special clock (time-driven trigger) to do that. Leave it as “Head.“ Step 5: Share the Sheet Now, you can share your Google Sheet with your friends or team members. They can use the "Lock Cells" button to lock their cells. Conclusion: With this magic system and the "Lock Cells" button, you can control who gets to edit your Google Sheet. It's like inviting friends to your party, but they need to tell you their names before they can play with your toys. I would be glad to help if you need any assistance.

How to Create a Custom Lock Menu in Google Sheets - The Magic of Automation

Keyboard Shortcuts On Linux, go to: File -> Preferences -> KeyboardShortcuts -> Open Keyboard Shortcuts JSON (top-right icon) On Mac: Code -> Preferences -> KeyboardShortcuts -> Open Keyboard Shortcuts JSON (top-right icon) Then add custom key bindings like this: to duplicate line / selection: Ctrl+D {
  "key": "ctrl+d",
  "command": "editor.action.duplicateSelection"
} to insert a with the selected text: Ctrl+Shift+L console.log {
  "key": "ctrl+shift+l",
  "command": "editor.action.insertSnippet",
  "when": "editorTextFocus",
  "args": {
    "snippet": "console.log('${TM_SELECTED_TEXT}$1')$2;"
  }
} Or to insert a with the clipboard's content: Ctrl+Shift+L console.log {
  "key": "ctrl+shift+l",
  "command": "editor.action.insertSnippet",
  "when": "editorTextFocus",
  "args": {
    "snippet": "console.log('${CLIPBOARD}', ${CLIPBOARD})"
  }
} More useful variables: https://code.visualstudio.com/docs/editor/userdefinedsnippets#_variables Code Snippets To add some React Component code snippets, on Linux, go to: File -> Preferences -> Configure User Snippets -> search for TypescriptReact On Mac: Code -> Preferences -> Configure User Snippets -> search for TypescriptReact Then paste this in the json file: "New React Component": {
  "prefix": ["react-component", "rc"],
  "body": ["const ${1} = () => {\n\treturn (\n\t\t<div>\n\n\t\t\n\t)\n}\n\nexport default ${1}"],
  "description": "New React Component"
 },
 "New React Component With Props": {
  "prefix": ["react-component-props", "rcp"],
  "body": ["interface I${1}Props {\n\t\n}\n\nconst ${1} = (props: I${1/(.*)/${1:/capitalize}/}Props) => {\n\treturn (\n\t\t<div>\n\n\t\t\n\t)\n}\n\nexport default ${1}"],
  "description": "New React Component With Props"
 } To use the snippets, open a file and type or -> you'll see the snippets' names in the auto-complete pop-up. tsx react rcp Code output example (you can edit the component's name): const Comp1 = () => {
  return (
    <div>

    </div>
  )
}

export default Comp1

// and

interface IComp2Props {
  
}

const Comp2 = (props: IComp2Props) => {
  return (
    <div>

    </div>
  )
}

export default Comp2 More: https://code.visualstudio.com/docs/editor/userdefinedsnippets Also published . here

How to Add Custom Shortcuts and Code Snippets to VS Code

Webix Datatable. From a simple table to a complex solution

Everyone needs a good editor..!!!✂️ Since , has provided us with the provision to add our own customized actions to a U_ITableView’s_ rows using the U_ITableViewDelegate_ method — t_ableView(_:editActionsForRowAt:)._ iOS 8 Apple tableView(_:editActionsForRowAt:) Asks the delegate for the actions to display in response to a swipe in the specified row. Use this method when you want to provide custom actions for one of your table rows. When the user swipes horizontally in a row, the table view moves the row content aside to reveal your actions. Tapping one of the action buttons executes the handler block stored with the action object. Now that is here, we have some new additions 🤓 to the table view’s editing API. Let’s see what’s in it for us.👀 iOS 11 What’s new in iOS 11? With the release of , introduced two new methods 😮 for handling in to support swipe actions on both leading as well as trailing edge of the row, i.e. iOS 11 Apple Swipe Actions UITableView swipe actions to display on the leading edge of the row tableView(_:leadingSwipeActionsConfigurationForRowAt:) — swipe actions to display on the trailing edge of the row tableView(_:trailingSwipeActionsConfigurationForRowAt:) — These methods were introduced as a part of UITableViewDelegate. Swipe Actions — Optional The methods to handle swipe actions in are , i.e. iOS 11 optional 😅 if implemented, supersede the delegate method. tableView(_:editActionsForRowAt:) if not implemented, will be called as the default behaviour. tableView(_:editActionsForRowAt:) Swipe Actions — Full Swipe In , swipe actions appear as by default 🤔, i.e the swipe spans the complete width of the iOS 11 Full Swipe UITableView. The behaviour can be configured using property 👏, introduced as a part of The set of actions to perform when swiping on rows of a table. Full Swipe performsFirstActionWithFullSwipe UISwipeActionsConfiguration — When this property is set to true, a full swipe in the row performs the first action listed in the actions property. The default value of this property is true. Promotions Don’t forget to read my other articles: Everything you’ve always wanted to know about notifications in iOS Drag It & Drop It in Collection & Table — iOS 11 Everything about Codable in Swift 4 Color it with GRADIENTS — iOS All you need to know about Today Extensions (Widget) in iOS 10 UICollectionViewCell selection made easy..!! Feel free to leave comments if you have any doubts. 🙂🙃

Stories, News & Mentions about EDITRAC

Editrac’s Stories on HackerNoon