Text field with numbers and or letters
I have a text field called P.O.# The reason it's a text field is that some P.O.'s we receive have a text prefix i.e. PR92828. Some are only numbers i.e. 63636. If I enter 63636 as the P.O. number a...
Forum Discussion
you might be able to set the field properties via the API_SetFieldProperties
https://help.quickbase.com/api-guide/index.html#setfieldproperties.html%3FTocPath%3DQuick%2520Base%2...
number formatting is: "&numberfmt="
for no cammas: "0"
URL:
If the api response says "No error" then you are good to go. I haven't tested it. But I've forced field properties on fields that normally don't give you the option before.
https://help.quickbase.com/api-guide/index.html#setfieldproperties.html%3FTocPath%3DQuick%2520Base%2...
number formatting is: "&numberfmt="
for no cammas: "0"
URL:
https://target_domain/db/target_dbid?a=API_SetFieldProperties&fid=7&numberfmt=0&apptoken=app_token
If the api response says "No error" then you are good to go. I haven't tested it. But I've forced field properties on fields that normally don't give you the option before.