Help

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

1556 0
cancel
Showing results for 
Search instead for 
Did you mean: 
NickHarrington
4 - Data Explorer
4 - Data Explorer

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

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.

airtable-range-on-skill-tables.png

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

0 Replies 0