Skip to main content
Participating Frequently
Mar 22, 2024 1:41 PM UTC
Question

How to change Record Field Type from integer to text?

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
    Brainy
    Mar 22, 2024 1:52 PM UTC

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

    Participating Frequently
    Mar 22, 2024 2:08 PM UTC

    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
    Employee
    Mar 22, 2024 8:48 PM UTC

    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
    New Participant
    Mar 22, 2024 8:10 PM UTC

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

    Participating Frequently
    Mar 22, 2024 10:24 PM UTC

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