Like Dual Authentication - verifying info in data

(0) Share

Report

Posted on by Jeffrey_H

118

Hello,

I'm working using a button to look up 2 variables in a Sharepoint List

The 2 variables are:

Student ID

Security Code

When I click on the button, I'm want to go out and verify both

If it's TRUE then it will show in a display box.

here's an example

I used this before when just looking for a Student ID = 'sbox - ID'

On Select = UpdateContext({varSearch:'sbox - ID'.Text})

Now I would like to add a second level of verification with the same search button.

On Select =

UpdateContext({varSearch:'sbox - ID'.Text});
UpdateContext({varSearch:'sbox - Security_ID'.Text})

I'm sure its fairly simple to accomplish this - please give suggestions.

Again, I am attaching an Excel file that has the data from the Sharepoint List: [Student Thank You Cards for Donors]

I have also attached the app that I am creating.

After this works I will be looking at screens CheckOut_1 and CheckOut_2

My vision for CheckOut_2 is to scan the QR code next to the Fund and then send a command to the printer to print that address to a label printer.

Kinda outside of the norm, but it's a work in progress. I would also appreciate suggestions for this but only after the Search button and lookup up is resolved on the 'Lookup Info' screen

Student Thank You...

All responses (6)

Answers (0)

scalca on at

Like (0)

Report

Re: Like Dual Authentication - verifying info in data

then you have to use && instead of ||
LookUp('Students', 'security code column' = varSecurityCode && 'Id column' = varId)
or Filter() if you want all matching records to be returned instead of one only
Jeffrey_H 118 on at

Like (0)

Report

Re: Like Dual Authentication - verifying info in data

it kinda works, but I would like to have both filters Student ID and Security Code to be filtered/searchable and only display in the gallery if both match in that record.
scalca on at

Like (0)

Report

Re: Like Dual Authentication - verifying info in data

LookUp returns always one record only if this is what you want.
But this formula in your items property can't work.

As I mentioned store Id and securiry code in two different variables e.g. varSecuritycode and varId
Then LookUp('Students', 'security code column' = varSecurityCode || 'Id column' = varId)
With that you would retrieve the first record matching security code or id
If you want all records use Filter()
Jeffrey_H 118 on at

Like (0)

Report

Re: Like Dual Authentication - verifying info in data

Did you have a moment to look at what I sent you yesterday ?
Jeffrey_H 118 on at

Like (0)

Report

Re: Like Dual Authentication - verifying info in data

Here's the Item's property I believe.
scalca on at

Like (0)

Report

Re: Like Dual Authentication - verifying info in data

are you trying to search for a student record based on student id and/or security code provided in search box ?
so records would show up in the gallery below ?
is there an error message ?

this code snippet you proposed
On Select =
UpdateContext({varSearch:'sbox - ID'.Text});
UpdateContext({varSearch:'sbox - Security_ID'.Text})
would end up to update the same variable varSearch, I think you need two different one in order to have the correct search query
can you pls share the items property of the gallery below