Update one column in a table that has required columns

[philkky12]

I have a table that has multiple required columns (they are already populated). I want to patch an additional optional record but it is asking me for all of the other required columns, how do I get around this?

[Drrickryp]

@philkky12 

If you are patching a single record that already exists, then you can use Patch(ds, ThisItem, {columnvalue:...}).
If you have a one to many relationship between the existing record and additional optional values for that column, perhaps you should consider a child table for those values.  If you are adding a completely new record, you will have to provide values for the required columns.