Does anyone know if it is possible for me to export records into excel sheet then update few records inside excel then upload the same file back into tb through front end upload?
csv export the file and use an import template with record matching on. You can‘t import connectionfields tho
Id also look at excel power query https://www.youtube.com/watch?v=0aeZX1l4JT4
You can develop the transformations once to the cvs download and “record” them.
Then next you download a CSV apply the same transformations
@andreas is right.
Export to CSV (which can also be a template)
Then import using an import template
@andreas - this should work with connection fields too.
well I had trouble with it.