We're using a record type, but one of the record field types needs to be changed from integer to text. I can update it in the database, but when I try to run a sync in hopes of being able to change it in the record type as well, the sync fails. How can I achieve this? I do not want to delete the field and create it again since it's referenced in a lot of objects that we use.
Discussion posts and replies are publicly visible
Did you try changing the data source table ir order to check if the field is refreshed?
I tried updating the database while the record type was open. Now I tried it again and when I opened the object, Appian suggested mapping of said field type into another. However, that did not happen while the record type was opened and constantly refreshed. Thank you for your response though.
Did you try changing the record field type on the record itself before syncing?
Just to confirm, did this work then? Generally designers like the record type designer don't automatically refresh after changes in an external system, so you usually need to refresh the page to see the changes.
Updating the database and then opening the record type worked. I did refresh it multiple times beforehand (when I made the change in the database while having the record type opened), however nothing happened.
The only changes you can make from integer type is group type. So no, that wouldn't work.