Suggestion: Google Sheet linking programmatic change

[Luuta]

I link a table or database to Google, which includes a multi-select list. The spreadsheet correctly lists all the items selected in the multi select field and in some cases, I've imported the entries from another spreadsheet, so I don't have to select them individually in that memento multi select field. 

However, when I update the memento database with the spreadsheet, it erroneously adds all the multi select records as new entries in the multi select field. 

If i manually just add the multi select entries from the field, the field entries are left as they are, as they should be. 

The only way i can get Memento to behave and leave the field inviolate, is to port the field list to another table and link that to the main table, removing the now redundant field. 

So, far example, my list (for arguments and) contains the entries apples, pears, plums and cherries. I might select a different combination of these to create my records. Obviously, i want the list to remain one of single entries. But if I copy and paste items in Google Sheets, even though the records look the same, when the database link to the spreadsheet is refreshed, the drop down field will now list - apples.& cherries, apples and pears and plums, pears and plums, pears and plums and cherries etc. 

Only the records should show the multi selection. The field list should not have been changed. 

I'm assuming this is a programming fault or limitation, but maybe it's because I haven't set the field properties correctly? I don't know. 

If anyone has any suggestions, or the developers can confirm it's a LinkedIn or they can improve the linking, I'd appreciate it. 

Many thanks

Luuta

[David Gilmore]

What I think you are asking for is similar to a Windows "Combo" box. I simulate that by having two fields, one a simple text field, and the second a "single chocie List" field (I do not want new entries to update that single choice list). Then in my save triggers, if a selection is made in that single choice list, I have it overwrite the text field, and reset the single choice list. So the user can either type something in that text field, or select an entry in the single choice list. I also have the single choice list only visible while the entry is in Edit mode, so it is not visible when just viewing the entry.

That Single Choice List field is changed to a external library link field if I want that selection list to be contained in another library. I do the same as above, and just clear the link to reset (that way I do not have extra library links hanging around).

By using that link field for the selection (and clearing it), that field would not carry over into your spreadsheet.