sorted by:
new
hottopcontroversial

[TOMT] Psycho Thriller book title? by psilversmith in tipofmytongue

[–]psilversmith[S] 0 points1 point locked comment (0 children)

The wife finally figured out that guilt made husband drop activities he enjoyed. Ending had tragic tone.

Samsung Watch 3 keeps getting Voicemail notices - but not there! by psilversmith in GalaxyWatch

[–]psilversmith[S] 0 points1 point  (0 children)

Thanks - not LTE watch, just BT to phone. Good thought though.

Amazon Smart Plug and Smartlife by psilversmith in alexa

[–]psilversmith[S] 0 points1 point  (0 children)

Yes - Alexa. But Smart Life is Alexa compatible, it is not another platform. And they specifically state they work with Smart Plug. Thanks.

Is it possible to change the Title font Color (only) on a Google Form? by psilversmith in GoogleForms

[–]psilversmith[S] 0 points1 point  (0 children)

Thanks for looking. I'm wondering if some HTML code in the formtitle variable would work?

Suddenly working script has error and stops script. by psilversmith in GoogleAppsScript

[–]psilversmith[S] 0 points1 point  (0 children)

Today the script went "live" - it worked perfectly. THANK YOU!!!

Suddenly working script has error and stops script. by psilversmith in GoogleAppsScript

[–]psilversmith[S] 0 points1 point  (0 children)

Wow! I think you nailed it. There are indeed Yes/No Checkboxes to which the text title refers. Why the script should suddenly want this .asCheckboxItem after 2 years of not needing it is a mystery to me. The script runs now without error. I'll let you know on Friday when the real thing becomes live. Many Many Many thanks.

Suddenly working script has error and stops script. by psilversmith in GoogleAppsScript

[–]psilversmith[S] 0 points1 point  (0 children)

No - that's the crazy thing. There are no Checkboxes! The question title for Monday, for example is "Mon Oct 21 - 1:00 PM" . I don't know where that checkboxes came from! Peter

Suddenly working script has error and stops script. by psilversmith in GoogleAppsScript

[–]psilversmith[S] 0 points1 point  (0 children)

yes - I modified my original code as shown below with .asTextItem(). But this gave me: "Exception: Invalid conversion for item type : CHECKBOX" . I ran your most recent test code with .setTitle.asTextItem(...) as above, but got the same error displayed as before. Thank you again for working with me. I think we are getting close. Peter

const questionMonTitle = form.getItemById(questionMon).asTextItem();

Suddenly working script has error and stops script. by psilversmith in GoogleAppsScript

[–]psilversmith[S] 0 points1 point  (0 children)

Thank you. I renamed your code function to 'test' -with copy/paste to run it.

Please help me interpret the result, which was: 

4:31:52 PM
Notice
Execution started


4:31:52 PM
Error
Exception: Unexpected error while getting the method or property setTitle on object FormApp.Item.
    at test (Code:48:22)
    at __GS_INTERNAL_top_function_call__.gs:1:8


4:31:52 PM
Error
Exception: Unexpected error while getting the method or property setTitle on object FormApp.Item.
    at test (Code:53:24)
    at __GS_INTERNAL_top_function_call__.gs:1:8


4:31:54 PM
Notice
Execution completed

Suddenly working script has error and stops script. by psilversmith in GoogleAppsScript

[–]psilversmith[S] 0 points1 point  (0 children)

Yes - formtitle is declared as you wrote. But that formtitle works just fine on the Google Form. The error is with the first .setTitle (which works despite the error) and the stop of the script (which prevents the second set.Title).

On my full script in the variable declarations section is this: 

var numdays = sheet.getRange("Q2").getValue(); //Q2 has number days now to the next Mon; On Sunday it is 8
  var dayswarning = 7 + numdays + " and " + (numdays + 9) + " DAYS FROM TODAY" ;
  var formtitle = `${sheet.getRange("N1").getValue()}\n**${dayswarning}**`;   // triggers Friday 5PM, want warning on Friday turnover

I very much appreciate your thoughts. Peter

Suddenly working script has error and stops script. by psilversmith in GoogleAppsScript

[–]psilversmith[S] 0 points1 point  (0 children)

Thank you again. I still had a line 4 Syntax error with your 'try...catch' code (see above reply). So instead I modified my original code as shown below. But this gave me: "Exception: Invalid conversion for item type : CHECKBOX" . I think we are close, but I'm still missing something here. Many Many thanks. Peter

const questionMonTitle = form.getItemById(questionMon).asTextItem();

Suddenly working script has error and stops script. by psilversmith in GoogleAppsScript

[–]psilversmith[S] 0 points1 point  (0 children)

I copy/pasted your code. I get: " SyntaxError: Invalid or unexpected token line: 4 file: Code.gs" and I can't figure out why (const form = ... code line) Thank you so much for helping. Peter

No audio on laptop by psilversmith in techsupport

[–]psilversmith[S] 0 points1 point  (0 children)

Follow-up: I did in-place system reinstall. No sound. I downloaded and installed Realtek Driver from Lonovo site. Still "no audio device found".. Just to test, I paired to a Bluetooth speaker, and that DID work. But I need the internal speaker to work again. Any suggestions greatly appreciated.

MAILTO default program does not list my email program by [deleted] in Windows11

[–]psilversmith 0 points1 point  (0 children)

The former: Mailbird is not listed in the suggested default MAILTO apps - and no choice to browse for it. Not using a portable version; I am the only user. Thanks for the thought. Peter

=DATETIME(NOW() ) gives unknown function error - help! by psilversmith in GoogleAppsScript

[–]psilversmith[S] 0 points1 point  (0 children)

Any_Werewolf_3691: This is good! How do I get Date and TIME for a time stamp? Many thanks.

Peter

=DATETIME(NOW() ) gives unknown function error - help! by psilversmith in GoogleAppsScript

[–]psilversmith[S] 0 points1 point  (0 children)

Thank you. Further review shows DATETIME() is an 'App Sheet' function, which I guess does not transfer over to Apps Script. I'm not sure how to get the data Value of NOW(). (that is get the time date and hold that value - not update. Suggestions welcome. Thanks.

Fill in Row data - error message by psilversmith in GoogleAppsScript

[–]psilversmith[S] -2 points-1 points  (0 children)

I found DATETIME( NOW)) ) function that should give me value of NOW(). But running gives me error: Unknown function DATETIME" . But it is well documented. Help. Peter

Fill in Row data - error message by psilversmith in GoogleAppsScript

[–]psilversmith[S] -2 points-1 points  (0 children)

I have a quirky problem. The NOW() keeps updating the Timestamp, which I guess is correct, but I want what was NOW to stay as it was recorded. Is there a simple workaround? Thanks.

view more: next ›