I really like the search functionality: I could search for a keyword and it would instantly pull up a long list of results: all the places where the keyword was found, with surrounding context: very useful. I’ve just spent a fair amount of time converting a lot of the important keywords in my Rich …

Hi! I’ve nearly got this now (converting References to Reference names): the following code works: it traverses the rich text JSON structure and locates any entities (which I assume is sufficient for finding all References) but now I need to get the actual Reference objects: I’m trying to call getE…

getEntitybyId is the right function to use to get info on an entity, but the first argument needs to be the name of the database of the referred-to entity. Is “entity” really the right name in your case?

Good point: I had tried ‘entity’ and ‘Reference’ but neither worked. So: if this entity is (say) a Reference to a Tag, should I pass in ‘Tag’? I actually use References to several different Databases, so I won’t know a priori which Database name to pass in: the only information I have at that poin…

OK I’m nearly there: I had a stupid JS error (traverse() needed to be async). Fixed that, and if hardcode type as “Tag” then it works. (I still need to replace the Reference with reference.Name, but I’ll figure that out next). However, I have one problem: I’m using References to multiple Database…

[image] masp: Is there a hidden API function that would do that for me? If there is, it’s hidden from me :wink: That’s the thing with references, they could be pointing to any entity from any database, so if you want to get info on the entity, you need to know which database to look in. So …

Sure: a lookup table will work: can you confirm that typeId is a constant? ie. if I get typeId=ABCDEF for a Tag today, will I get typeId=ABCDEF for all Tags, any time? I assume so, because a lookup table wouldn’t work otherwise, but just wanted to check :slight_smile:

OK this is working (uses a lookup to fetch the correct type of Reference, and successfully replaces each Reference with its name): // Lookup table for mapping typeId to Name. Note: this table must be // extended whenever a new Database is added(if it might be Referenced), // or modified whenever a…

I’m a bit confused: I added a formula defined as Count(References), but it’s always zero, even for Tasks that have one or more References in their rich text fields. Am I doing it wrong?

Sorry if I have unwittingly misled you, the References.Count() function returns the number of references to the entity (i e. the things that are listed in the References field. There is currently no way to determine when references/mentions have been added in a rich text field, sorry. I guess a ti…

OK, no problem: I put the script in an action button for now, so I’ll just remember to run it whenever I’ve updated a Task.Details field for now. Other than that (automation) this is a perfect solution for now, although of course I’m looking forward (hopefully) to Reference names being searchable b…

After converting keywords to References, search for keywords is much less useful

Get Help

Mikkling February 13, 2022, 5:20pm 29

This would be useful. I have lots of fields that i update with automations that i really don’t want users to mess with.

Topic		Replies	Views
Trigger on doc changes not working Get Help automations	23	597	April 15, 2023
References reloaded Ideas & Features	77	2717	September 24, 2024
Show in Reference Highlights Referenced Entity more clearly Ideas & Features blocks	13	1434	November 9, 2021
Allow Rules/Formula Involving Rich-Text Fields Ideas & Features formulas , rich-text	27	3599	December 13, 2024
The future of References: thoughts, questions, and ideas Second Brain for Teams	9	879	October 11, 2022

After converting keywords to References, search for keywords is much less useful

Related topics