Populate a value based on a number value in a text field

Copper Contributor

I had this working in an older version of this app but can't be bothered to reset all my progress to rollback. Even looking at the github commits (added git control), all the code looks the same.


I have a text value that counts how many rows were checked, and that works. However, this if statement is not updating the value in my choice field. In fact, my choice field (on view only) just displays a blank white box. But on edit mode, it shows the choice options. I know this is all possible beings I have done it before but I must be missing something. 


The picture below shows the choice field in edit mode



as view mode




my items for my choice field show as:




default formula for the field:




Let me know if you need anything else from me, thank you!


2 Replies
best response confirmed by tschm1880 (Copper Contributor)

Hi @tschm1880 


which property do you declare using the formula

{Value:"Not Completed"}

It does not seem to be the "Default" property of your "Status_Datacard1", as this is set to ThisItem.Status.

I used that formula on "Default" of "Status_Datacard1", and it works fine.

Best Regards,


@SvenSieverding awesome, that was my issue. I applied this formula as the default on the text box within my status_datacard1. Thank you!