Forum Discussion

tschm1880's avatar
tschm1880
Copper Contributor
Feb 07, 2023

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

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!

 

  • 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's avatar
    SvenSieverding
    Bronze Contributor

    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

     

    • tschm1880's avatar
      tschm1880
      Copper Contributor

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

Resources