Modify display name for "Progress" column type?

AppSheet AppSheet Q&A
1

Hi everyone,

Is there a work around to change the display name for the "Values " in a Progress column type?
I would like this to show other words.

3X_8_f_8f6be87859301cf1860a8162c287f6b851105a36.png
3X_8_f_8f6be87859301cf1860a8162c287f6b851105a36.png633Ă—282 4.38 KB

2

Please explore following workaround.

  • Create a new enum column called say [Progress 2] with values as you want. Say you wish to show values as per the table below against the standard values of Progress column.
  • Retain the original progress column and its original values as well

3X_8_8_88a60c259bc5fb9df17701d26119b741b7873c37.png
3X_8_8_88a60c259bc5fb9df17701d26119b741b7873c37.png227Ă—241 1.29 KB

  • In the App formula of Progress column , please have an expression

IFS([PROGRESS 2]=“Zero”, “Empty”,[PROGRESS 2]=“Little”, “Quarter”, [PROGRESS 2]=“Significant”, “Half”,[PROGRESS 2]=“Very Good”, “Three Quarter”,[PROGRESS 2]=“Excellent”, “Full”)

  • In the Show_if of Progress column, you may have something like
    OR(CONTEXT(“ViewType”)=“Detail”, CONTEXT(“ViewType”)=“Table”)

  • In the Show_if of Progress 2 column, you may have something like
    CONTEXT(“ViewType”)=“Form”

The approach assumes, the user updates progress column through form view. You may needs to change suitably depending on how the progress column is updated in your app.

Edit: Minor changes in description

6 Likes
3

Amazing! you should put this under Tips and Tricks.
I believe it is very useful.

Thanks @Su

1 Like