Mapping the Resource Field in FileMaker

Text Fields

Mapping the resource to a text field is the simplest and most flexible approach, as it easily supports assigning multiple resources to the same event. If you're new to DayBack, consider starting with a simple text field for the resource. This allows you to quickly understand how DayBack operates, and you can later switch to a calculated or related field if needed.

It's essential that the text field remains editable so users can drag events from one resource to another for rescheduling. You can use an auto-enter calculation as long as the field is still editable.

Using Related Records for Your Resources

In some cases, your event may only contain the ID of a resource, while DayBack needs the resource's name. Since the resource field mapped in DayBack must be local to the event's table, you can't map directly to the related field. Instead, create a calculated field or an auto-enter calculation to pull the related resource's name (or names) into your event.

However, when editing the event, you'll want DayBack to update the ID rather than the name you've mapped. To achieve this, follow the instructions in the "Calculated Fields" section below to modify DayBack so it edits the correct field.

Calculated Fields

You can map the resource to a calculated field, but you'll need to adjust DayBack's FileMaker scripts so that they don't attempt to edit the calculated field directly. This can be particularly useful when you want the resource to represent a combination of two other fields. For instance, in a school setting, you might have a calculated field that combines a room name and a teacher's name, separated by a carriage return. Learn more here: Using Calculated Fields for Status or Resource in FileMaker.