How to add output to an Interface?

[tamwendy]

I think I’ve seen from prior tutorial that one can add ‘output’ to the interface. However, I cannot find any ‘Output’ fields in the “Edit Interface” and I cannot also connect output such as ‘combine text’ or ‘output field’ to the “interface” node.

What did I miss? Thanks so much!

Wendy

[Wasay-Gumloop]

Hey @tamwendy - You can use an Output node within the flow and that output will be mapped on the interface. Agreed that this should be more intuitive like a field in the interface editor that can somehow be connected to the flow as well.

You can take a look at any interface template for reference, all of them are using an output node: https://www.gumloop.com/templates

[tamwendy]

Thanks Wasay! I didn’t know the output would automatically be appended - I thought output node was used as an debugging tool primarily!

May I ask you a question of my current flow: It uses AI scrapper to get price from a page, and then write it to a google sheet as a new row. And I’ve created a subflow to pull the last price record (before writing the new one), so that I can do a python code for a simple % change calculation. And as you can see, I’m merging the change result from the calculation to the rest of the scrapped information and have it write to the Google Sheet.

However, I find that even if the calculation subflow can return a result, the result (the change) would not be able to appear on the Google sheet.

Is it a timing problem? For my use case, am I approaching the flow design correctly? Or is there a better way ?

Many thanks!!

[Wasay-Gumloop]

Hey @tamwendy - Could you please share the run link from the https://www.gumloop.com/history page where it does not add the data to the spreadsheet so I can take a closer look?

Also, on the workbook page please set the share access to ‘anyone with the link can view’

[mikban]

following this one. There arent a lot of users using python and I’d love to know the resolution

[Sanjeev]

@Wasay-Gumloop

Gumloop | Templates

I faced similar issue. Thanks for providing the solution. I shall try it out and get back meantime it is important that we make the appropriate changes to the help text bcos it says the following - The interface has been updated. Here’s the correct way to add an output text:

1. Hover over your Interface node and click “Edit Interface”
2. Look for “Add Component” or “Add Field” button (it’s usually in the form builder area)
3. If you don’t see these options, try clicking “Advanced” or “Show Advanced Options” - Thanks

[Wasay-Gumloop]

Hey @Sanjeev - Can you share where this text is taken from within the docs? Or is this from the Gummie chat?

[tamwendy]

Hi Wasay, sorry I missed your message. Here is the link, thanks a lot!

https://www.gumloop.com/pipeline?run_id=FVr5Z5DgPxLQPyidbUPtMP&workbook_id=dxqFAhiKNHnTzsoYo1RGqr

Wendy

[Wasay-Gumloop]

Thank you for sharing @tamwendy - The flow is set up properly, great use of subflow! And I can see that the Change % was posted to the Google Sheet by viewing the inputs/outputs of the node from the run log.

However, I find that even if the calculation subflow can return a result, the result (the change) would not be able to appear on the Google sheet.

Was the Change % column name changed?

Could you also try a few things:

1. Press the refresh icon next to the Sheet Name on the Sheet Writer node and run the flow again
2. Delete the Sheet Writer node and add it back

Let me know if that works and you’re able to see all the data in your spreadsheet. If not, please share the Google Sheet or a copy of your Google Sheet along with the latest run with me wasay@gumloop.com and I’ll take a look.

[tamwendy]

Wasay, you nailed it!! I made a minor change to the column name, from “Change %” to “Change in %”. It didn’t occur to me that this would break the flow.

Thanks for pointing that out. To avoid this kind of accidental breaking of the flow, do you recommend us to add ‘protection’ to Google Sheet range, or is there a better way to handle it inside Gumloop?

[Wasay-Gumloop]

Changing header names would break the Google Sheet nodes so I’d recommend protecting those cells or refreshing the node when you decide to change the name.

[tamwendy]

Got it, thanks Wasay.