Select formula failing

Greetings Appsheet community, I have the following problem,

I was using this formula to send a WhatsApp notice for around 3 months without any problem, but yesterday it didn't work anymore, the SELECT function no longer throws me the phone number in my database

"https://api.whatsapp.com/send?phone=52"
& TEXT(SELECT(STUDENTS[PHONE], [ID] = [_THISROW].[ID]))
& "&text="&ENCODEURL("School: J. de N. 14DJN0269N informs you:"
& ANY(SELECT(STUDENTS[NAME], [ID] = [_THISROW].[NAME]))
& " " & [ENTER] & " at: " & "" & [_THISROW].[TIME] & " hrs." & [ENTRY])

0 1 66
1 REPLY 1

This maybe or may not be the cause of issue. However, there seems to be slight variation in the expressions for retrieving [Phone] and [NAME] , even though you are retrieving them from the same table. You may want to check any specific reason for this? Differences highlighted in bold

TEXT(SELECT(STUDENTS[PHONE], [ID] = [_THISROW].[ID]))

ANY(SELECT(STUDENTS[NAME], [ID] = [_THISROW].[NAME]))

 

 

 

 

Top Labels in this Space