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])
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]))
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |