0

I'm hoping to migrate an application for tracking samples from Microsoft Word/Excel to Google Apps, as we have a number of users and having the Excel sheet be locked all the time is causing problems.

However, the current script is dependent on having an input box pop up asking for input that closes automatically when return/enter is input. This works well because most of the input is supplied by using barcode scanners that automatically send after the input from the scan.

In trying to migrate the script, I've found that the Google version of inputbox won't accept to process input. I can't have the users go to click "OK" with every scan, as they may scan 10-12 barcodes at a time and clicking in between each would significantly slow down the process.

Does anyone have ideas on how I could replicate that functionality? I've tried making a test HTML form and specifying "autofocus" on the button, but that doesn't seem to work either.

Thanks for any suggestions!

Improve this question
2
  • @Hi, Michael! I did not understand fully what you're trying to achieve in apps script. As far as it looks yout don't know much about apps script documentation and its functionalities. So, here's my suggestion. Record a macro of desired functionalities in sheets and them analyse the script generated from it. After recording click in "EDIT Script". Google Apps Scrtipt is based in modern Java Script. Apps Script documentation. Best wishes! Hint: How do I ask a good question? Commented May 26, 2020 at 18:01
  • I'm trying to get input from users with the dialog box dismissed and script execution continued with a <CR> from the user. The relevant Google feature request is here: issuetracker.google.com/u/2/issues/145721806 I'm just wondering if anyone knows a workaround for this until Google implements the request. Commented May 26, 2020 at 18:37

1 Answer 1

Reset to default
1

I know the workaround provided is not useful to you, but I'm leaving an answer just in case someone faces the same issue.

As seen in the comments, there is a bug where Sheets does not autofocus the prompt windows, so pressing Enter doesn't act on any button. The current workaround is to press "Tab" to focus it.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.