Can someone tell me what I am doing daft. I am trying to create a record on a button click that inserts two foreign keys. One is fine from a page parameter - the other is trying to insert the unique user id of an email address typed into a text box. Seems straight forward, either Im doing something…

Is the users “carer_id” their email? I’d think that might be something else which is why it’s not matching any. If so thats an easy fix :grinning:

No the carer_id is the foreign key field that is part of the Create New thing (data record)I want to populate with that users unique id (I have used email above just to try and get a result. Changed below - same issue [image]

Search on User table not returning results

Need help Database

mikeloc December 12, 2022, 6:37pm 4

Hi there, @marcoforte8… the issue could be related to privacy rules, specifically this rule. So, check out that link and see if it helps.

Best…
Mike

Topic		Replies	Views
Bug: do a search for user gets the unique_id but empty values Bugs	1	341	November 9, 2021
About displaying email with unique id from user data Database	2	377	September 3, 2021
Do a search for user action is not working Database	13	1118	August 29, 2023
"Do a search for" returning inconsistent values Questions	8	190	March 4, 2025
Search for Users throws up an empty result even though the user exists Need help	1	1011	September 16, 2021

Search on User table not returning results

Related topics