Coda.io - Dynamic data modification
In this post, we will create a table recording the receipt of an award by a particular specialist, and then display such information in each team card view. When a specialist is awarded over the others I want them to receive a visible “online” check mark:
- I am creating a document that will record all decorations and awards assigned to specialists. The table will contain basic information about the awarded person and what he was awarded for.
- The Date column automatically takes the value of the day the row was created, and the Specialist column, allows you to choose from the defined specialists in our company from the “personnel data” table.
- In the main table with personnel data, I create a new column “honors”, which will automatically take values depending on whether the specialist was honored or not:
- Inside the column, I create a form that verifies the presence of the person in the honors table and assigns one “star” for each position. As a result, it displays as many stars as there were honors:
- In the FULL NAME column, I change the formula by adding the value from the “Honors” column.
- Automatically on all views of the cards of specialists appears information about distinctions in the form of stars:
- Also in the table in which we define awarded specialists we have information about awards:
- Final developed view:
