Skip to main content
T
teodorar3974
March 22, 2024
Question

How to change Record Field Type from integer to text?

  • March 22, 2024
  • 6 replies
  • 0 views

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.

    6 replies

    davidj137213
    davidj137213
    Brainy
    March 22, 2024

    Did you try changing the data source table ir order to check if the field is refreshed?

    T
    teodorar3974Author
    March 22, 2024

    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.

      peter.lewis
      peter.lewis
      Employee
      March 22, 2024

      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.

      dogab0001
      dogab0001
      New Participant
      March 22, 2024

      Did you try changing the record field type on the record itself before syncing?

      T
      teodorar3974Author
      March 22, 2024

      The only changes you can make from integer type is group type. So no, that wouldn't work.

        Terms & ConditionsAccessibility statement