error using return value from "call a script" in next step

[Joachim_Mund]

Hi all,

I have problems using the return value from "call a script" in next step:
Data action 'setze Gdoc ID und Status Action' uses an invalid new column value expression '="https://docs.google.com/document/d/"& [Erzeuge_Gdoc_mit_Fußzeile].[Output]'. Unable to find column 'Erzeuge_Gdoc_mit_Fußzeile'

The bot has a task "Erzeuge_Gdoc_mit_Fußzeile" with a text return value (google docs id):

it says use [Erzeuge_Gdoc_mit_Fußzeile].[Output] in a process expression.

The next data action task sets a column "Schreiben Datei" with "https://docs.google.com/document/d/"&
[Erzeuge_Gdoc_mit_Fußzeile].[Output]

If I save the appsheet version I get the above mentioned error:
Data action 'setze Gdoc ID und Status Action' uses an invalid new column value expression '="https://docs.google.com/document/d/"& [Erzeuge_Gdoc_mit_Fußzeile].[Output]'. Unable to find column 'Erzeuge_Gdoc_mit_Fußzeile'

Could anybody please tell me, what I am doing wrong?

Thank you, Joachim

[Joachim_Mund · Accepted solution]

Hi all, I found the solution for my problem using the return value of a google script in the next data action.

It failed with an error message if the data action has turned on linking to use this component in other bots/processes.

If I use a data action with no reusable component it worked.

Don't know why.

Have fun!