Skip to main content

Filter data from Link to another record based on Child age in months

  • March 27, 2018
  • 0 replies
  • 8 views

Read only link: https://airtable.com/invite/l?inviteId=inv3WFtNVNtL3nYJr&inviteToken=19b5b1c02f9aa80fe0efc08a2b20814238ef7f80c3a5fb5527a10da8e425bff9

I’m using Link to another record to provide a pick-list of Child Skills for measurement. These Skills are age-dependent where they are only measured where the Child age-in-months is in range for the Skill being measured.

For example: [Skill Being Imaginative, age-months-min, age-months-max]

Pretends that one object represents another, 16, 26
Uses movement to express feelings, 30, 50

Where for a Child aged 20 months only Row #1 may be selected/picked.
Where for a Child aged 30 months only Row #2 may be selected/picked.

Are there any native Airtable functions that can achieve this type of range test against a Link to another record? Are there any Integrations that could help provide this function?

Any and all ideas appreciated.

Thanks,
Nick

This topic has been closed for replies.