Progress type column

Hi,

My question is that I set a “status” column of progress type. After fill out the form, the details will show the status I selected. Howver, when go back to edit the form, it appears the status is unselected again.

I don’t know why. Even I don’t do anything, and save the form again, it will shows the status I selected initially in details view, but not in form editing view.

When I fill out the form and it shows in details view.

When I go back to form editing view, it shows unselected again.

Hi,

If you are using Desktop mode it may be a bug.

Not a workaround, but you can use a DIM to show the progress icon .

Any chance the option “Reset on Edit” is set as ON? You can find it from the column’s definition.

1 Like

Hi,

Thanks a lot for your help.

I checked it but it’s not set as ON.

Are you sure your selected value for the progress column is correct?

Hi,

Thanks a lot for the info. It looks cool and nice.

But I don’t know how to make it? Currently I set the progress column with value as “empty”, “half”, “full” and it appears the icons as you see. I thought the icons are designed by appsheet. (Is it?)

I am trying to understand how you make it. Need more time. :))

It seems the first letter needs to be written with capital.. like Empty, Half, Full.

2 Likes

Hi,

I tried and it shows me this message below. (I am not sure if I make it in the right way)

You need to have them in your column’s definitions.

1 Like

As @AleksiAlkio said you need to have them in the column definition.

About the images, if you still want to use them :

If you want to have images in the enum, you have to add them in the “suggested values” of your column and set the base type as Image.

Suggested values formula would look like : list(concatenate(dim0%), concatenate(dim50%),concatenate(dim100%) )

I suggested Dynamic but if your bug only happen because of progress type column, it don’t need to be dynamic at all, it can be a normal svg or images from your drive.

Example of what your enum suggested values formula can be :

Show More

list(CONCATENATE("data:image/svg+xml;utf8, "),

CONCATENATE("data:image/svg+xml;utf8, "),

CONCATENATE("data:image/svg+xml;utf8, ")

)

*replace the numbers in bold to edit values

*to make it smaller just make a request with chatgpt :slightly_smiling_face:

It should return like this in your form :

If you want to use your own images, which may be easier, put them in your drive and set them as public, then instead of list(dim1,2,3..) , use list(“driveexportURL1”, “url2”,“url3”). You can convert your files url to export using this tool : https://sites.google.com/site/gdocs2direct/

__

Then you may want to create a new column to capture the current progress where if(progress=url1 (or dim1) value , then 0%, if(progress=url2 (or dim2), then 50% , if (etc) ) )

Hope it helps !

Hi,

You are right. I changed the first letter to be capital…and the problem is solved. :))

Thanks a lot.

1 Like

Hi, thanks for the infomration in details. I will try it later. :blush:

You’re welcome!