Email Error

mimi_McCPetco8

I have an automation set up so when a certain column is checked it will generate a document via DocuSign. It worked perfectly and now suddenly I keep getting the same error. I have scrapped the automation and started over making sure everything is set up correctly but still get the same error:

• The email for "Doctor Email" is invalid in row 4112981658832772.

I CANNOT figure out how to fix this so my automation works. HELP!!

Hudson_Miller

@mimi_McCPetco8

Greetings -

This is likely due to an entry error for a particular "Doctor Email" on a specific row. Oftentimes there can sneak in a hidden character or misplaced period at the end of the address that makes the email address invalid.

The row number is the row's API Row ID (found by right clicking the row and going to properties) and unfortunately there is no easy way to find/obtain this data.

Just take a slow scroll through the email column and see if anything pop's out. Otherwise you will need to probably need to set up either a filter or a helper column and run some checks to look for spaces, carriage returns, or rows that end with periods.

Hudson

mimi_McCPetco8

Thanks @Hudson_Miller

I have checked the emails, and they are correct. I manually went into DocuSign and they sent off just fine. The automation worked until yesterday and I get the same error, even on ones that worked previously.

SSFeatures

Hi @mimi_McCPetco8, does it always complain about the same row ID, or does the number change? I'm wondering if it's only one email that's causing the problem, or if there are multiple emails that Smartsheet doesn't like.

If you have a lot of rows, it can be difficult to manually go through each one to check the row ID.

If you're comfortable running code in your browser's Developer Tools console, you can paste in this code and it will tell you which row corresponds to '4112981658832772', so that you don't have to manually go through each one by hand.

rowId = 4112981658832772


grid = formObjectHandler.getFormObjectByConstructor(JscMegaGrid)

rowNumber = grid.gridRowSet.findIndex((row) => row.pvt_gridRowMaskedID === rowId)


console.log(`The rowNumber is ${rowNumber}`)

Hope this helps!