Hi there! I am trying to create an action that Generates a CSV. I have successfully selected my data source (let’s say “sheet A”) and I have created a second data table to store the generated URLs (“Sheet B”). However, when I am setting up the action and I got to File Output, I see only the options that are part of Sheet A and no option to output URLs to Sheet B. Would love any guidance or help here as I’m striking out in docs and with the AI agent. Thank you!
Could you provide screenshots of the structure you have please?
Normally, generate CSV output is the file URL of the generated CSV file.
@MaximeBaker File structure attached. I followed the docs and created a separate file to house the generated CSV URLs and I’d like to send data from Sheet 1 to the Generate CSV “data” page.
Can you show me you action please?
Action attached. I included the side bar where I’m trying to find file output options that would be in my “Generate CSV” data source. I only see options for columns that are in Sheet1
I tried creating a user specific column in my Users data source but I would prefer it to go to “Generate CSV”
Do you have any components attached to the action? If not, try changing the context to the sheet B (where you want it to go).
So full disclosure I’ve tried that (where the original app interaction is Sheet B). My problem arises when I want to output a filtered view of Sheet A vs the entire database…(I am essentially trying to build a way to output a favorites list.) When I make the original app interaction Sheet B I don’t have the option of setting a condition to filter.
I implemented a similar approach by creating a custom filter using a helper table. I connected a choice box to a user-specific column in that table, and added a match (true/false) column to the source table. This allows filtering of data where match equals true. Finally, I created a query column in the helper table that filters based on this condition. With this setup, you can set the source to this table and export the matching items in CSV format.
It only shows Sheet A because your screen is built on top of Sheet A.
If you know the exact row you want to write to in Sheet B, create a relation to that row, and write the CSV URL there.
If you want to add a new row in Sheet B, write the URL to a column in your user profiles table, then proceed to add a new row with that URL (you can reference user profiles columns in an add row action).