.png){kind=logo}
How to Return Values Between Spreadsheets Easily
Really need a way to "Return" a value from 1 spreadsheet to another -- only way to manage the complexity
Really need a way to "Return" a value from 1 spreadsheet to another -- only way to manage the complexity
Hey there, thanks for reaching out! ☺️ Could you share a bit more context or details so I can share more with the team? A short screenshare video always helps! If there's anything else I can assist you with, please let me know! 😊 Have a great Thursday, Daniel
Hey Mathew, thanks for getting in touch, and for sharing this thoughtful feedback. 100% agree and see the value in these ideas. Drawing on more of those programming concepts – tables-as-functions, for-loops, try-catch, global config values, etc. – would unlock a ton. In the meantime, your approach to split up the workflow and separate concerns into multiple tables is the best way to approach it. I know this is timely feedback, since I've seen recent conversations around revamping the workbook/table flow. We might edge closer into a more "component"-like approach. It may not solve the table-as-function concept, but may unlock easier visibility into the "lifespan of a record through many operations", so to speak. Thanks again!
Thanks Mark, this makes sense. There would be a lot of benefit separating "orchestration" from "transformation". For example, if I start with a raw record and I need to --> validate --> enrich --> screen --> upload It's much easier to have a sheet that coordinates those "functions" where you can track the lifecycle (as you mentioned) Where as today, you have to send the record into another sheet, with no way of knowing what happened to it. This fact makes debugging & analysis very difficult (i.e. you have to check 4 sheets to see where a company was rejected) vs. having to check one Again the ability to treat tables as "functions" and interacting with them as if they were API endpoints would be a huge unlock
Amen! I'm going to copy/blockquote this, and update the note I shared internally. :)
