O
Orchid Corpin
Guest
Hi Wilco, I just confirmed that the functionality " Treat empty spreadsheet cells as NULL values for updated records " isn't available when you create data map from object definition, this is only available when doing import from UI. I find this as a good enhancement to Rollbase so that when we use the data MAP with REST or SOAP we can utilize this functionality. You can file it in our ideas page Ideas Page . I am thinking if you can create an Update Field trigger to clear the date field, something like the code below: var dateBefore = "{!Date_Issued#before}"; var dateNew = "{!Date_Issued}"; if( rbv_api.isImport() && (dateBefore == dateNew) ) { return ""; //clear date field } Hope this may help. Regards, Orchid
Continue reading...
Continue reading...