Modify Rows On a Select List Column

1

Hi,

So the scenario I’m dealing with I have a helper table with a few columns which is using a button to run some actions pushing the info to a few other tables.

The issue I came across is one of the columns i want to update is a select list which can hold multiple entries and I want it to add the extra item to the list not just override it with the new item, I couldn’t see this option within modify rows but not sure if I’m missing something obvious?

What I’ve ended up doing was using modifyrows( row, column, list(original column, helper table info) the problem I had with this was if the original column was blank I am getting “blank” added as the first entry on the column, (I’m assuming because my select list is actually a relation column this is causing some of my list issues here with the blank?)

So I’ve then added an if statement

modifyrows(row, column, if(column.isblank(), helper table info, list(original column, helper table info))

Which feels a little unwieldy so am I missing some native thing within modify rows that helps deal with multiple entries on a select list/relation column or is this just the way to do it?

Thanks

Alan

2

I think you can use list combine and filter if currentvalue is blank as you said. If you provide a sample doc I can show it to you in there.

3

Thanks, for anyone else who ends up on this I did forget to say that both list and listcombine were returning the blank entry, I don’t think there would be any chance of a duplicate but yeah listcombine is probably better, the filter method definitely looks neater than the if setup as well so I’ve gone with that.