I'm wondering if there is a way within a formula field to reference the data within a field on a specific record? Here is the use case, other ideas welcome!
I want a role in my app to be able to indicate text alerts as they come in, by simply updating a single field on a template record.
I then want this information to show up on each record within that same table, so that when users are entering information they are aware of this alert.
Right now, I can only reference the field within the formula not the field data within that specific record. Also, since it is a text field it cannot be put on a lower level table and be pulled up. I would also settle for an alert on the home screen, just needs to be easily entered by a user and not a developer.