Bulk updates on MY SQL tables is pretty simple when the data is presented "as is". but the column names are not often pretty...
I have set the column titles using Alias's and I have formatted some of the data. Now my Bulk update does not work as it tries to update based on the Alias rather than the column title. I can get around this by removing the Alias and using Retool to rename the columns
BUT I have formatted a column to present data to the user in a specific way...
This column would not be editable, but the bulk update still includes it so of course it errors as it doesn't actually exist in the DB.
Is there a way around this? is there a way to get the bulk update to ignor specific columns?
I have looked in the documentation and google for hours and I can not see a clear way.
Thanks in Advance