Crow Canyon Software Forum
How to get the email address from a person column
Quote from skigeek on July 2, 2025, 2:02 pmI have a person column (p1) in table 1, and it is displaying as smith.john@xyz. This is the list that I am using for the nitro form.
I have table 2 which has a txt column (email) that has an email (john.smith@xyz.com) and this is the one I want to query by using the p1 colum in table 1.
I am wanting to use fetch list items using a query but cannot figure out how.
Thanks
I have a person column (p1) in table 1, and it is displaying as smith.john@xyz. This is the list that I am using for the nitro form.
I have table 2 which has a txt column (email) that has an email (john.smith@xyz.com) and this is the one I want to query by using the p1 colum in table 1.
I am wanting to use fetch list items using a query but cannot figure out how.
Thanks
Quote from supportTeam on July 2, 2025, 3:15 pmHi Archie,
Please let us know if there's a link between items in Table 1 and Table 2 that we can use to fetch the email from Table 2 and populate it in the person column in Table 1.
Hi Archie,
Please let us know if there's a link between items in Table 1 and Table 2 that we can use to fetch the email from Table 2 and populate it in the person column in Table 1.
Quote from skigeek on July 2, 2025, 4:04 pmThere is not really. I probably could create one. I was not thinking on doing that, I was focused on querying across the two tables using the two fields itentified. 1 is a person and the other is the single line txt. I was thinking that there might be a function call on the person field that would return the email. Hope that makes sense.
There is not really. I probably could create one. I was not thinking on doing that, I was focused on querying across the two tables using the two fields itentified. 1 is a person and the other is the single line txt. I was thinking that there might be a function call on the person field that would return the email. Hope that makes sense.