It would be wonderful if we could see a preview of a message in outlook that has been attached to a table. I found this repo on github that does exactly that:
github.com
ykarpovich/msg.reader
Outlook Item File (.msg) r...
You could run a scriptconst now = new Date();
let inputConfig=input.config();
let CellId=inputConfig.StatusChanged;
let table = base.getTable("All Projects");
await table.updateRecordAsync(CellId, {
"Completion Date": now
})
This will require an additional Function field with a switch statement: SWITCH({Answer field},"Answer one",1,"Answer two",2,0) The last 0 being the default value if nothing is selected
