Add Columns

[dyee]

I'm a bit confused.  In my main table, I did an add column to bring in a data source into my table (vendor name) so I could filter the data by vendor name.  On a different table, I gave users the ability to modify a few fields and patch it into the data source.  When I try to write my patch statement it says it can't find the column I used in the add columns table. Why would a column I created as a lookup impact my patch?  How can I get around this?

[WarrenBelz]

@dyee ,

I assume you have used AddColumns to produce a data set? You are patching to a table and the field is not in that table - it only exits within the app for the filtering. You need to Patch the value to the table it belongs to.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[dyee]

@WarrenBelz 

I don't think so.  I used the addcolumns in a gallery to lookup the actual name of something to filter the table.  To my knowledge, the addcolumns should only apply to that gallery.  My patch function is in a separate gallery that is using the the same source table but there is no add column in the code. 

[WarrenBelz]

@dyee ,

Can you please share some code here (in text) including where and when you are running it.

[WarrenBelz · Accepted solution]

Hi @dyee ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[dyee]

I tried to create an app to show the error (I took the code off of my app).  I wasn't able to recreate it.  I guess I'll mark it as good.  Thank you!