SOLVED

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

tschm1880_0-1675774748728.png

 

as view mode

 

tschm1880_1-1675775072018.png

 

my items for my choice field show as:

tschm1880_2-1675775136644.png

 

 

default formula for the field:

tschm1880_3-1675775162624.png

 

 

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

 

2 Replies
best response confirmed by tschm1880 (Copper Contributor)
Solution

Hi @tschm1880 

 

which property do you declare using the formula

If(
Value(Label4_3.Text)>3,
{Value:"Completed"},
{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,
Sven

 

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

1 best response

Accepted Solutions
best response confirmed by tschm1880 (Copper Contributor)
Solution

Hi @tschm1880 

 

which property do you declare using the formula

If(
Value(Label4_3.Text)>3,
{Value:"Completed"},
{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,
Sven

 

View solution in original post