Hellow every on i am new to https://build.getodk.org/ building the form i want to check the users id with my external excel file if the user exsist in the file allow else show error.
I am not sure how to do this in Build, or if it is even possible in Build.
Here is an example using XLSForm and the pulldata()
function.
pulldata_id_check.xlsx (10.2 KB) & registered.csv (88 Bytes)
+----------+-----------+-------------+
| personid | first | last |
+----------+-----------+-------------+
| ID124 | John | Snow |
| ID125 | Spongebob | Squarepants |
| ID126 | Clifford | Red |
+----------+-----------+-------------+