Automate

Hi there,

I'm working on a script that involves creating notifications in IW21 and then uploading long-text to those notifications in IW22.

Here are the steps I followed:

1. Recorded the IW22 script and mapped it to a data sheet.
2. Recorded the IW21 script, uploaded the same data sheet (IW22), and completed mapping so everything is on a single sheet.
3. Chained the scripts together and published them.

The entire script runs completely fine on my end. However, when other users attempt to run it, they encounter the following error:

Could anyone help me identify what might be causing this issue for other users?

Snip of the data sheet:

Hi Ava,

Did you publish the script or just send them the script through email?  I ask because I've seen this error when a script isn't published.

Hi there,

I'm working on a script that involves creating notifications in IW21 and then uploading long-text to those notifications in IW22.

Here are the steps I followed:

1. Recorded the IW22 script and mapped it to a data sheet.
2. Recorded the IW21 script, uploaded the same data sheet (IW22), and completed mapping so everything is on a single sheet.
3. Chained the scripts together and published them.

The entire script runs completely fine on my end. However, when other users attempt to run it, they encounter the following error:

Could anyone help me identify what might be causing this issue for other users?

Snip of the data sheet:

I published the scripts before sending the data sheet through email.

Hi Ava,

Did you publish the script or just send them the script through email?  I ask because I've seen this error when a script isn't published.

Hi there,

I'm working on a script that involves creating notifications in IW21 and then uploading long-text to those notifications in IW22.

Here are the steps I followed:

1. Recorded the IW22 script and mapped it to a data sheet.
2. Recorded the IW21 script, uploaded the same data sheet (IW22), and completed mapping so everything is on a single sheet.
3. Chained the scripts together and published them.

The entire script runs completely fine on my end. However, when other users attempt to run it, they encounter the following error:

Could anyone help me identify what might be causing this issue for other users?

Snip of the data sheet:

That's the problem, they need to pull the script from the server.

I published the scripts before sending the data sheet through email.

Hi Ava,

Did you publish the script or just send them the script through email?  I ask because I've seen this error when a script isn't published.

Hi there,

I'm working on a script that involves creating notifications in IW21 and then uploading long-text to those notifications in IW22.

Here are the steps I followed:

1. Recorded the IW22 script and mapped it to a data sheet.
2. Recorded the IW21 script, uploaded the same data sheet (IW22), and completed mapping so everything is on a single sheet.
3. Chained the scripts together and published them.

The entire script runs completely fine on my end. However, when other users attempt to run it, they encounter the following error:

Could anyone help me identify what might be causing this issue for other users?

Snip of the data sheet:

Hi there,

I'm working on a script that involves creating notifications in IW21 and then uploading long-text to those notifications in IW22.

Here are the steps I followed:

1. Recorded the IW22 script and mapped it to a data sheet.
2. Recorded the IW21 script, uploaded the same data sheet (IW22), and completed mapping so everything is on a single sheet.
3. Chained the scripts together and published them.

The entire script runs completely fine on my end. However, when other users attempt to run it, they encounter the following error:

Could anyone help me identify what might be causing this issue for other users?

Snip of the data sheet:

Hi Ava

Note that before you chain, you will want both scripts pointing to the correct excel files - often the same file.  Check and save that first.

Also, can you share a screen shot of your chain settings? Typically you want to go with custom and use the same workbook, possibly sheet - but that depends on your data, login credentials, etc.  Use case vary, however.

If you feel comfortable with it, you can share you scripts and excel template. You can scrub the data, as needed.

Please advise,

Sigrid

Hi there,

I'm working on a script that involves creating notifications in IW21 and then uploading long-text to those notifications in IW22.

Here are the steps I followed:

1. Recorded the IW22 script and mapped it to a data sheet.
2. Recorded the IW21 script, uploaded the same data sheet (IW22), and completed mapping so everything is on a single sheet.
3. Chained the scripts together and published them.

The entire script runs completely fine on my end. However, when other users attempt to run it, they encounter the following error:

Could anyone help me identify what might be causing this issue for other users?

Snip of the data sheet:

Hi,

Here are a few snaps of several settings:

I've also attached the scripts and data file.

Thank you so much!

Hi Ava

Note that before you chain, you will want both scripts pointing to the correct excel files - often the same file.  Check and save that first.

Also, can you share a screen shot of your chain settings? Typically you want to go with custom and use the same workbook, possibly sheet - but that depends on your data, login credentials, etc.  Use case vary, however.

If you feel comfortable with it, you can share you scripts and excel template. You can scrub the data, as needed.

Please advise,

Sigrid

Hi there,

I'm working on a script that involves creating notifications in IW21 and then uploading long-text to those notifications in IW22.

Here are the steps I followed:

1. Recorded the IW22 script and mapped it to a data sheet.
2. Recorded the IW21 script, uploaded the same data sheet (IW22), and completed mapping so everything is on a single sheet.
3. Chained the scripts together and published them.

The entire script runs completely fine on my end. However, when other users attempt to run it, they encounter the following error:

Could anyone help me identify what might be causing this issue for other users?

Snip of the data sheet:

Thanks for sharing Ava.

I'm unsure why the chain shows the path to your scripts. That is why it didn't work for others.

When I unchained and rechained, I see this - no path - just the script names.

Also in your modify script, I used a formula to extract the notification number from the log column - see line 4.

As a best practice

• please be sure each script is mapped to the right file and is working individually. Save each script. Then chain them. 
• If you want to make any major changes, unchain the scripts, make the updates, test and then rechain.

Hope this helps,

Sigrid

Hi,

Here are a few snaps of several settings:

I've also attached the scripts and data file.

Thank you so much!

Hi Ava

Note that before you chain, you will want both scripts pointing to the correct excel files - often the same file.  Check and save that first.

Also, can you share a screen shot of your chain settings? Typically you want to go with custom and use the same workbook, possibly sheet - but that depends on your data, login credentials, etc.  Use case vary, however.

If you feel comfortable with it, you can share you scripts and excel template. You can scrub the data, as needed.

Please advise,

Sigrid

Hi there,

I'm working on a script that involves creating notifications in IW21 and then uploading long-text to those notifications in IW22.

Here are the steps I followed:

1. Recorded the IW22 script and mapped it to a data sheet.
2. Recorded the IW21 script, uploaded the same data sheet (IW22), and completed mapping so everything is on a single sheet.
3. Chained the scripts together and published them.

The entire script runs completely fine on my end. However, when other users attempt to run it, they encounter the following error:

Could anyone help me identify what might be causing this issue for other users?

Snip of the data sheet:

Hi,

The chain does not show the file path, it's similar to yours:

When I unchain and chain, it looks the same.

Thanks for sharing Ava.

I'm unsure why the chain shows the path to your scripts. That is why it didn't work for others.

When I unchained and rechained, I see this - no path - just the script names.

Also in your modify script, I used a formula to extract the notification number from the log column - see line 4.

As a best practice

• please be sure each script is mapped to the right file and is working individually. Save each script. Then chain them. 
• If you want to make any major changes, unchain the scripts, make the updates, test and then rechain.

Hope this helps,

Sigrid

Hi,

Here are a few snaps of several settings:

I've also attached the scripts and data file.

Thank you so much!

Hi Ava

Note that before you chain, you will want both scripts pointing to the correct excel files - often the same file.  Check and save that first.

Also, can you share a screen shot of your chain settings? Typically you want to go with custom and use the same workbook, possibly sheet - but that depends on your data, login credentials, etc.  Use case vary, however.

If you feel comfortable with it, you can share you scripts and excel template. You can scrub the data, as needed.

Please advise,

Sigrid

Hi there,

I'm working on a script that involves creating notifications in IW21 and then uploading long-text to those notifications in IW22.

Here are the steps I followed:

1. Recorded the IW22 script and mapped it to a data sheet.
2. Recorded the IW21 script, uploaded the same data sheet (IW22), and completed mapping so everything is on a single sheet.
3. Chained the scripts together and published them.

The entire script runs completely fine on my end. However, when other users attempt to run it, they encounter the following error:

Could anyone help me identify what might be causing this issue for other users?

Snip of the data sheet:

Hi Ava

This is what I see

the first doesn't have the path but the 2nd does.  Are they in different locations?

FYI

Sigrid

Hi,

The chain does not show the file path, it's similar to yours:

When I unchain and chain, it looks the same.

Thanks for sharing Ava.

I'm unsure why the chain shows the path to your scripts. That is why it didn't work for others.

When I unchained and rechained, I see this - no path - just the script names.

Also in your modify script, I used a formula to extract the notification number from the log column - see line 4.

As a best practice

• please be sure each script is mapped to the right file and is working individually. Save each script. Then chain them. 
• If you want to make any major changes, unchain the scripts, make the updates, test and then rechain.

Hope this helps,

Sigrid

Hi,

Here are a few snaps of several settings:

I've also attached the scripts and data file.

Thank you so much!

Hi Ava

Note that before you chain, you will want both scripts pointing to the correct excel files - often the same file.  Check and save that first.

Also, can you share a screen shot of your chain settings? Typically you want to go with custom and use the same workbook, possibly sheet - but that depends on your data, login credentials, etc.  Use case vary, however.

If you feel comfortable with it, you can share you scripts and excel template. You can scrub the data, as needed.

Please advise,

Sigrid

Hi there,

I'm working on a script that involves creating notifications in IW21 and then uploading long-text to those notifications in IW22.

Here are the steps I followed:

1. Recorded the IW22 script and mapped it to a data sheet.
2. Recorded the IW21 script, uploaded the same data sheet (IW22), and completed mapping so everything is on a single sheet.
3. Chained the scripts together and published them.

The entire script runs completely fine on my end. However, when other users attempt to run it, they encounter the following error:

Could anyone help me identify what might be causing this issue for other users?

Snip of the data sheet:

Hi Ava

This is what I see

the first doesn't have the path but the 2nd does.  Are they in different locations?

FYI

Sigrid

Hi,

The chain does not show the file path, it's similar to yours:

When I unchain and chain, it looks the same.

Thanks for sharing Ava.

I'm unsure why the chain shows the path to your scripts. That is why it didn't work for others.

When I unchained and rechained, I see this - no path - just the script names.

Also in your modify script, I used a formula to extract the notification number from the log column - see line 4.

As a best practice

• please be sure each script is mapped to the right file and is working individually. Save each script. Then chain them. 
• If you want to make any major changes, unchain the scripts, make the updates, test and then rechain.

Hope this helps,

Sigrid

Hi,

Here are a few snaps of several settings:

I've also attached the scripts and data file.

Thank you so much!

Hi Ava

Note that before you chain, you will want both scripts pointing to the correct excel files - often the same file.  Check and save that first.

Also, can you share a screen shot of your chain settings? Typically you want to go with custom and use the same workbook, possibly sheet - but that depends on your data, login credentials, etc.  Use case vary, however.

If you feel comfortable with it, you can share you scripts and excel template. You can scrub the data, as needed.

Please advise,

Sigrid

Hi there,

I'm working on a script that involves creating notifications in IW21 and then uploading long-text to those notifications in IW22.

Here are the steps I followed:

1. Recorded the IW22 script and mapped it to a data sheet.
2. Recorded the IW21 script, uploaded the same data sheet (IW22), and completed mapping so everything is on a single sheet.
3. Chained the scripts together and published them.

The entire script runs completely fine on my end. However, when other users attempt to run it, they encounter the following error:

Could anyone help me identify what might be causing this issue for other users?

Snip of the data sheet: