Question: Using nested resources for the first time Had to adjust all paths in views but now I find I have to adjust objects for form\_for(@object) because the objects imply paths Is this one of the reasons form\_for is being depracated?

Answer: 
Solution:
---------

The solution would be to use [template literals](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Template_literals):

```
function myFunction() {
  var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet15"); 
  ss.getRange("B2").setFormula(`=IFERROR(VLOOKUP(I:I,'get sloc for picklist'!A:B,2,0),"NO STOCKS")`);
}

```

In this way everything that is enclosed by the backticks (``) is considered as a type of `string`.
You cannot use single quotes in your formula definition that is already enclosed in quotes!

```
ss.getRange("B2").setFormula("=IFERROR(VLOOKUP(I:I,'get sloc for picklist'!A:B,2,0),\"NO STOCKS\")");

```