Skip to main content

Hi, dear pros,

can I ask, anyway that I can realize this:

table A: tasks

table B: doctors


if a linked filed from table B writes on table A: for instance: Dr. Brown, i want to have another field on table A can show something like “Health”


not sure how to write formula on something linked to another table

If I understand your example correctly, you have a link field named something like {Doctor} in your [Tasks] table, and it points to the [Doctors] table. When making a link to a record named “Dr Brown”, you want a different oTasks] table field to display “Health”. Am I reading that correctly?


If so, that’s a pretty easy formula. With a single link in a link field, Airtable simply reads the contents (the primary field value from the linked record) as a string, so you just need to compare that string to another string in your formula:


IF({Doctor}="Dr. Brown", "Health")

Does that work for your needs?

If I understand your example correctly, you have a link field named something like {Doctor} in your [Tasks] table, and it points to the [Doctors] table. When making a link to a record named “Dr Brown”, you want a different oTasks] table field to display “Health”. Am I reading that correctly?


If so, that’s a pretty easy formula. With a single link in a link field, Airtable simply reads the contents (the primary field value from the linked record) as a string, so you just need to compare that string to another string in your formula:


IF({Doctor}="Dr. Brown", "Health")

Does that work for your needs?


I think I wasn’t clear.

OK, I have 3 tables

Table A: Doctors

Table B: Tasks

Table C: Major


I want to make Table B has a filed that If any one from Table A linked to Table C, then one field on Table B can write “Professional”, otherwise “amateurish”


The basic idea is, if any doctor has any linked field on table c, the table A can tell, their opinion is professional.

something like this.


@Justin_Barrett

I think I wasn’t clear.

OK, I have 3 tables

Table A: Doctors

Table B: Tasks

Table C: Major


I want to make Table B has a filed that If any one from Table A linked to Table C, then one field on Table B can write “Professional”, otherwise “amateurish”


The basic idea is, if any doctor has any linked field on table c, the table A can tell, their opinion is professional.

something like this.


@Justin_Barrett


In that case, I would put the formula field into your oDoctors] table. Name it something like {Professional/Amateur}, and use this formula:


IF({Link to Major}, "Professional", "Amateur")

Replace {Link to Major} with the name of your field that links to the tMajor] table. This formula will mark each doctor’s record appropriately based on whether or not they have any links to that table.


In any other table that links to a doctor, like it sounds your Tasks] table does, you can look up that professional/amateur status with a Lookup field:


Reply


Terms & Conditions