Formula text to find existing text in other fields
Hello!
Is there a way a record can look outside its own record, and look at the whole table when putting a formula text field?
We currently have several documents. Each document has its own record in our main table. Some of these documents are linked, and have revisions. Right now when a revision is introduced, we have to access each previous document record and edit "Updated Version" field. So we have two main fields for this question: "Affected Documents" for new record and "Updated version" for previous(outdated) record.
Basically we want to be able to auto-populate "Updated version" field when "Affected Documents" field is inputted, so that we do not have to manually update those previous records.
Is this possible?
Thank you in advance for all of your expertise.
Is there a way a record can look outside its own record, and look at the whole table when putting a formula text field?
We currently have several documents. Each document has its own record in our main table. Some of these documents are linked, and have revisions. Right now when a revision is introduced, we have to access each previous document record and edit "Updated Version" field. So we have two main fields for this question: "Affected Documents" for new record and "Updated version" for previous(outdated) record.
Basically we want to be able to auto-populate "Updated version" field when "Affected Documents" field is inputted, so that we do not have to manually update those previous records.
Is this possible?
Thank you in advance for all of your expertise.
