RoulaHabbal
7 months agoQrew Cadet
Looking up a Field in a Different Table in the Same Application without a Relationship.
Hello:
I have one application with many tables. The two tables in question are:
- Applications
- Student Demographics.
Applications Table Fields and Types:
- Name (formula-text)
- Phone Number (formula-text)
- Email (formula-text)
Student Demographics Table Fields and Types:
- Name (text)
- Phone Number (number)
- Email (email)
Values
- Name Field ID: 7
- Table Alias: [_DBID_STUDENT_DEMOGRAPHICS])
- Table ID: btn82xxxx
Goal: I am trying to look up the name, phone, and email fields in the Student Demographics table and transfer the data to the Applications table (without a relationship) using a formula.
Challenge: I am receiving different error messages.
- "Expecting text but found number."
- "Expecting text but found record list."
- GetRecord(7,[_DBID_STUDENT_DEMOGRAPHICS])
- GetRecord(7,"btn82xxxx")
Questions:
- Am I using the correct function?
- Is the Record ID the same as the Field ID?
- Am I correct in selecting a formula-text field type for the phone number and email fields?
Thank you,
Roula