Hi Team,
I have a form control with 41 cards/columns. I have created an additional column named FormStatus which is a drop-down showing "Done" and "Not Done".
I need to check the status of all 41 cards/columns in the form named "InventoryForm_1" and dynamically change the status of the FormStatus from NotDone to Done when none of the cards are left blank/empty/having no values.
I have tried the below codes but it is giving me an error and I am unable to figure out the issue. Hoping someone can help me with this code:
Set(
FormComplete,
If(
And(
!IsBlank(DataCardValue94.Selected),
!IsBlank(DataCardValue1.Text),
!IsBlank(DataCardValue78.Selected),
!IsBlank(DataCardValue72.Selected),
!IsBlank(DataCardValue2.Selected),
!IsBlank(DataCardValue79.Selected),
!IsBlank(DataCardValue74.Selected),
!IsBlank(DataCardValue77.Selected),
!IsBlank(DataCardValue80.Selected),
!IsBlank(DataCardValue37.Selected),
!IsBlank(DataCardValue81.Selected),
!IsBlank(DataCardValue73.SelectedDate),
!IsBlank(DataCardValue82.Selected),
!IsBlank(DataCardValue97.Selected),
!IsBlank(DataCardValue98.Text),
!IsBlank(DataCardValue84.Selected),
!IsBlank(DataCardValue99.Text),
!IsBlank(DataCardValue83.Selected),
!IsBlank(DataCardValue100.Text),
!IsBlank(DataCardValue101.Selected),
!IsBlank(DataCardValue102.Selected),
!IsBlank(DataCardValue85.Selected),
!IsBlank(DataCardValue111.Selected),
!IsBlank(DataCardValue89.Selected),
!IsBlank(DataCardValue104.Selected),
!IsBlank(DataCardValue110.Selected),
!IsBlank(DataCardValue90.Text),
!IsBlank(DataCardValue86.Selected),
!IsBlank(DataCardValue105.Selected),
!IsBlank(DataCardValue109.Selected),
!IsBlank(DataCardValue107.Text),
!IsBlank(DataCardValue106.Text),
!IsBlank(DataCardValue87.Selected),
!IsBlank(DataCardValue113.Selected),
!IsBlank(DataCardValue108.Selected),
!IsBlank(DataCardValue112.Selected),
!IsBlank(DataCardValue92.Selected),
!IsBlank(DataCardValue88.Selected),
!IsBlank(DataCardValue91.Selected),
!IsBlank(DataCardValue76.Selected)
),
true,
false
)
)
Regards,
Aminah
