Excel online (Microsoft 365) and Forms issue

Questions and Help
1

Anyone have problems getting forms to execute properly in the online version of Excel?

I have a snippet that works fine in Google Sheets and in Data Blaze, but struggles in Excel online.

In Excel, it will successfully insert info into the first cell in a row, and then advance using the 'tab' through the subsequent cells, but doesn't actually fill in the information. Company policy requires that I use Excel for this project and can't just switch to Google Sheets. I'm using the web selector to capture the information and may not be able to just share the site.

{note}Test ID{endnote}{site: text; page=https://app.vetscanimagyst.com/\; selector=.css-1yb1hhy}{key: tab}{note}Date{endnote}{time: MMM Do YYYY}{key: tab}{note}Name{endnote}{site: text; page=https://app.vetscanimagyst.com/\; selector=h4}{key: tab}{note}Hospital{endnote}{site: text; page=https://app.vetscanimagyst.com/\; selector=[data-testid="company-info"] > .MuiBox-root > .MuiBox-root > .MuiBox-root > .MuiBox-root}{key: tab}{note}Hosp Email{endnote}{site: text; page=https://app.vetscanimagyst.com/\; selector=.MuiCollapse-wrapperInner > :nth-child(1) > .MuiTypography-root}{key: tab}{note}Species{endnote}{site: text; page=https://app.vetscanimagyst.com/\; selector=.MuiBox-root + .MuiBox-root+ .MuiBox-root+ .MuiBox-root+ .MuiBox-root+ .MuiBox-root+ .MuiBox-root> .MuiTypography-root}{key: tab}{note}Age{endnote}{site: text; page=https://app.vetscanimagyst.com/\; selector=.css-nlragi .MuiTypography-root}{key: tab}{note}Sex{endnote}{site: text; page=https://app.vetscanimagyst.com/\; selector=.MuiBox-root + .MuiBox-root + .MuiBox-root .MuiFormLabel-root + .MuiTypography-root}{key: tab}{note}Breed{endnote}{site: text; page=https://app.vetscanimagyst.com/\; selector=.css-13c8h87 .MuiTypography-root}{key: tab}{note}Site{endnote}{site: text; page=https://app.vetscanimagyst.com/\*; selector=.MuiSvgIcon-root + .MuiBox-root> .MuiTypography-root}{key: tab}

Is this just an incompatibility of MS 365? :frowning:

Carol

2

Hi Carol,

I'm sorry to hear about this issue. We are looking into it and we will update this thread once we find a solution.

1 Like
3

Hi @carol.haak

We do not have any updates on the issue yet. In the meanwhile, here is a workaround. After each tab key, you can press the space key to make Excel go into cell-edit mode which inserts the information correctly. Here's an example snippet:

a{key: tab}{key: space}{key:backspace}b{key: tab}{key: space}{key:backspace}c{key: enter}

I added the backspace key as well to clear the extra space character.

Overall, to fix your original snippet, you can copy the following: {key: space}{key:backspace} and insert it after each tab key press in your snippet.

Thanks for your patience while we investigate the original issue.

4

Awesome! Thanks very much.

5

Hi!

Any updates on this? I'm also having this issue and it's been a year. Thanks!

6

Hi @sara.michelle.weinma Welcome to the forum! :slight_smile: We don't have any updates on this. I still request you to use the workaround:

Let me know if it does not work for you.