Check data from two different tables

AppSheet AppSheet Q&A
1

Hello thanks you to the community for all the appsheet info much appreciated!
Currently I have an app with multiple tables. I want to be able to check from table A if table B has matching input data for example table A[Name] = table B[Name] and if it does I want the current column row to state true. I tried to compute this value from looking throuhg the community forum but its not working well…

UNIQUE(
  IFS(
    ISNOTBLANK([Name]),
      SELECT(
        Table B[Name],
        ([_THISROW].[Name] = [Name])
      )
  )
  + IFS(
    ISNOTBLANK([Email]),
      SELECT(
        Table B[EMAIL],
        ([_THISROW].[Email] = [EMAIL])
      )
  )
  + IFS(
    ISNOTBLANK([Phone]),
      SELECT(
        Table B[Phone #],
        ([_THISROW].[Phone] = [Phone #])
      )
  )
  + IFS(
    ISNOTBLANK([Appointment Date]),
      SELECT(
        Table B[Appointment Date],
        ([_THISROW].[Appointment Date] = [Appointment Date])
      )
  )
)

Any advice would be appreciated on how I can make that happen!!

2 Likes
2

Welcome @stayonpointtattoo

If you’re looking to connect tables together, have you checked out references? Connecting these tables together with a reference might do exactly what you’re looking for.

If you’re wanting it where, on TableB I can select a record from TableA; then on TableA see a list of all the TableB records that match - a reference will do that.

1 Like
3

Change UNIQUE(...) to ISNOTBLANK(...). Otherwise, your expression looks fine to me.

4

You might try:

and(
  IN([Name], Table B[Name]),
  IN([Email], Table B[Email]),
  IN([Phone], Table B[Phone])
)
3 Likes
5

Yup works perfect thank you all!

2 Likes