0

Use Formula field to display subset of a linked table??

I have a table called "events". I then have a sub-table called "Expenses"(1:N). I want to create a formula field that only displays records from the Expenses table that have a specific type(one of the fields) like all expenses with type that equal "hotel". How do I write this formula? I tried various select examples and couldn't get it to work. 

1 reply

null
    • Fred
    • 2 yrs ago
    • Reported - view

    Hi James -

    I'm a bit confused.

    James said:
    I want to create a formula field that only displays records from the Expenses table

     A formula field is not really setup to display records. Are you talking about a view element or sub-table?

    If you want to create a special view element to Expenses that shows only "hotel" then you can write something like:

    Expenses[type = "hotel"]
    

    You can do this because you have created the links already so you don't need to do a select.

    This also only works if type is a text field. If type is a choice field then the code changes and if it is a dynamic choice field then it could change again.

Content aside

  • 2 yrs agoLast active
  • 1Replies
  • 64Views
  • 2 Following