Solved: Check data from two different tables

stayonpointtatt · 12-04-2020 09:32 PM

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!!

MultiTech

You might try:

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

View solution in original post

MultiTech

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.

Steve

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

MultiTech

You might try:

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

stayonpointtatt

Yup works perfect thank you all!