Hello,
Is there a function in AppSheet that will take a job title and make an inference based on a search for it, since employers have different name for different job titles.
Thanks!
No, although you could build your own table of related terms that might work.
I have thisโฆ how can I proceed? My understanding is to use refs but Iโm not sure.
Rory
Note that I havenโt tried this myselfโฆ but if I were to, I would create a user_titles
table that includes a related_titles
enumlist referencing itself:
You could make an onsave action that ensures consistency across all user_titles
as you update them. For example, if you add the related term โOwnerโ to the user_title โCEOโ, you would also want to add the related term โCEOโ to โOwnerโ. There would also be ways to ensure this level of consistency with virtual columns. Hard to say which is better - it would depend on how large your table is and how often you intend on updating it.
For my own curiosityโฆ Iโd like to know how @Steve would approach this.
Iโd seen this topic and couldnโt think of a good way to do what @Rory_Vaughan wanted, but this made me reconsider! I like the direction youโre going!
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |