Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Column Properties

Lawrence Liu
Lawrence Liu ✭
edited 12/09/19 in Archived 2017 Posts

How can I set up a column to capture data such as a phone number with xxx (xxx) xxxx xxxx format for Country Code, Area Code and phone number.  With dafualt County Code of where there data is coming from or with a default value that can be over-wrtitten by submitter

Tags:
· Share on FacebookShare on Twitter

Comments

  • L_123
    L_123 ✭✭✭✭✭✭

    If you are talking about using web forms you could use a concatenation to create a final column, and just use a default value in the web form. the concatenation would look something like this: 

    ="("+[Primary Column]1 + ") " + [Column2]1 + " " + [Column3]1 + " " + [Column4]1

    that way each column would be updated independently and put together in the 5th column

    · Share on FacebookShare on Twitter
  • Shaine Greenwood
    Shaine Greenwood Employee

    Hi Lawrence, if you don't want to have the submitter parse a phone number out into separate fields, you might consider using the LEFT and MID functions in your formula:

    ="(" + LEFT([Phone Number]1, 3) + ") " + MID([Phone Number]1, 4, 3) + "-" + MID([Phone Number]1, 7, 4)

     

    · Share on FacebookShare on Twitter
  • Lawrence Liu
    Lawrence Liu ✭

    Thank you Luke & Shanie

     

    But what I wanted in the web form layouts is to show up as 

    e.g.  Phone - xxx (xxx) xxxx xxxx

    As a guided field to those entering the form.  I do not like to have the form verticular format I prefer it as a line as the above

    e.g.

    Country Code    xxx

    City code           xxx

    Phone number  xxxxxxxx

    That is not appealing.

     

    · Share on FacebookShare on Twitter
  • L_123
    L_123 ✭✭✭✭✭✭

    In that case you could use a query string for the web form. I'm not to familiar with the topic as I haven't used it myself, but I plan to soon.  Here is a help document on the topic.

     

    https://www.smartsheet.com/blog/query-string-quick-guide

     

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories