Hello Bubble Forum,
While I think I am going to find another way to work this, I do see some clever people in this forum and at this point, just curious if what I was attempting was even possible.
First and foremost, to the admins behind this platform, I am enamored with what you have built. Truly amazing platform!
To simplify this scenario, lets say this application is used for kitchen projects. Each Kitchen has various segments. Sink, Faucet and Disposer. I have a data type where Sink, Faucet and Disposer are each separate rows (or things) and each row has a Good, Better and Best price.
I have a requirement to import in files in which the Good, Better and Best prices are on separate rows, not within the same row (CSV). So Sink would be represented as 3 rows. One for Good, one for Better and one for Best in the external file I am uploading. However my local Data Type in which I need to append this data as stated above is one row with 3 attributes (Good, Better and Best).
So my approach to this and first getting into using API Workflows on a List was to:
Use File Uploader to bring CSV into bubble storage (AWS). This works perfectly.
Use Upload data as CSV to read the imported file and place the data in a Data Type that is for temporary data storage. This also works perfectly.
Use an API Workflow on List in which the list to run on is filtered for only Good, so that takes my 3 rows per project segment (Sink, Faucet or Disposer) and reduces them to single rows. This writes the values into my permanent Data Type. This also works perfectly!
My thoughts were to then run an API Workflow on List but instead of Create a Thing, use Make Changes to a Thing, thinking this would be the same iterative run through, except instead of adding new records, it would edit the Better and Best fields. This I cannot get to work. The problem is my List to Run on has an ID that joins the 3 rows of each same project segment (Sink, Faucet or Disposer) but I am not even close to figuring out how I can somehow relate the List to Run On to a specific row in my Data Type I am making changes to??
As you can see, I cant even really articulate my situation well to begin searching the forum for a possible solution. In laymen terms, I want to look at each row in my List to Run On, grab an ID, find that same ID in my other Data Type and edit two of the fields from my List to Run, then continue until end of recordset.
My solution is to have my developer spit the data out of my main production application (nothing to do with Bubble) and add additional columns so each project segment is a single row, which is how the data structure in Bubble is setup. This will absolutely work and simply meant passing my problem to someone else :). I am just curious if this could have been done in Bubble and thought I would ask in event I run into future situations that are similar.