Ok, two questions. I get the logic, I just donโt know the syntax.
I have two tables, โMembersโ and โLogโ. โMembersโ is a read-only table with three columns, Name, Number and Delinquent (this is yes/no). The Number column is the Key. Numbers are unique.
(EDIT: Googled it and found this, so Iโm going to take that for a spin: https://appsheethelp.zendesk.com/hc/en-us/articles/205319178-References-between-tables)
My questions:
(1) Our ferry operator records members in the Log table as they board the boat. The operator enters the memberโs number, and once they do that I want to grab and display the Name associated with that number from the Members table. Syntax?
(2) I want to check if that member is delinquent. So I want to grab the value of the Delinquent column associated with that number on the Members table and display it. Syntax?
Thank you!
(1) [Number].[Name] (2) Add a show field (text field) with the formula [Number].[Delinquent] The number field on your Log table has to be a ref field.
@Aleksi_Alkio worked beautifully, thank you!
Youโre welcome
User | Count |
---|---|
42 | |
30 | |
25 | |
23 | |
13 |