This special advancement-focused Community Conversation focuses on setting up an automated web service in your database. Three examples explore identifying data in a query and importing the values directly back into the same database environment, enabling transformations to automatically occur on import:
- Update a pledge's status to be "fulfilled" when the amount unreceived is $0.
- Add an end date to an existing "Current Student" constituent type entity row based on a donor's conferred graduation date.
- Add a constituency type of "Alumni" as a new entity row based on the donor's conferred graduation date.