Okay, I tried this again and got passed the Circular Dependency by
correctly calling the valueandNote function below. Now the error is:
*error:* You do not have permission to call setNote (line 4, file "Code")
So unless someone knows how to grant permission for setting the note value
from within the function, I think the answer is I can't do this. :)
On Sunday, April 6, 2014 6:04:57 PM UTC-5, James Garza wrote:
>
> I'd like to create a custom function called "valueAndNote that takes two
> arguments as such: valueAndNote(cellValue, noteValue). The second
> parameter the noteValue, would be assigned to the active cell's note.
> Here's my code so far:
>
> function valueAndCell(cellValue, noteValue) {
>
> cell = SpreadsheetApp.getActiveRange()
> cell.setNote(noteValue);
>
> return cellValue;
> }
>
> The idea here is to insert a note into a cell who's value is in another
> cell. However, when I use the above custom function in my spreadsheet I
> get the following error:
>
> *"error:* Circular dependency detected".
>
> Any ideas on how to do this or if it's event possible?
>
>
>
>
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
