Neste artigo
Associations that organize activities and events often need to coordinate their volunteers. With Banana Accounting Plus, you can create two simple tables linked to each other – Volunteers and Events – to centrally manage who participates, which tasks have been assigned, and the organizational details of each event.
This way, all the information stays within the same accounting file, without the need for separate Excel sheets, giving you a clear, up-to-date, and immediate overview.
In Banana Accounting Plus, you can link simple tables to each other using the RowId column.
How to create the Volunteers and Events tables
- Open the accounting file
- From the menu Tools > Add/Remove Functionalities > Add Simple Table
- Create the simple table Volunteers
- Create the simple table Events.
Structure of the Volunteers table
The table can be customized by adding your own columns and displaying other predefined ones. In this example, the structure created is as follows:
- RowId → unique volunteer code (also serves as the linking key).
- Description → volunteer's full name; automatically appears in other linked tables.
- Email → “Notes” column renamed to “Email”.
- Phone number → column added via Data > Columns setup > Add.
Structure of the Events table
The Events table can include these columns:
- RowId → short code to identify the event (e.g. SPRIFEST).
- Description (DescriptionId) → name of the event (e.g. Spring Festival).
- Date → column added via Data > Organize columns > Add.
- Location → column added via Data > Organize columns > Add.
Creating a link between Volunteers and Events
In this example, the Volunteers columns were linked to the Events table.
- Tools > Add/Remove Functionalities > Add columns to link tables
- In the dialog window, select the Volunteers table.
Banana automatically adds the following columns to the Events table:
- Volunteers Id → volunteer's code.
- Volunteers Description → name of the volunteer (or event manager)
When you enter the volunteer code in the Volunteers column, Banana automatically fills in the volunteer's name in the corresponding column.
Advantages of linking
- Clear overview → you immediately know who is participating in an event.
- Defined roles → assign specific tasks to each volunteer.
- Automatic updates → if you change data in the Volunteers table, Banana updates it in the Events table too.
- Simplified management → no more separate sheets, everything stays in the same file.
- Activity history → keep a record of volunteer participation over time.
This approach is ideal for cultural, sports, or charity associations that want to manage people and events in a simple, organized, and immediate way.