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


#1

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


How best to organise Children to Measured Skills and Skill Score
#2

You can’t filter available records in Linked Record fields: Linked Records Filter Options.

Also, I can’t think on an integration to do it.


#3

Elias; thanks for the link in Linked Records Filter Options.
I hope @Jacob_L is taking this back as a feature request via an earlier direct email support request. Fingers crossed this has some serious consideration.

Nick