Hi,
I just started using Xano and I'd like to learn if it's possible for me to trigger a workflow on the creation or update of a record in the database? One of my uses cases requires the data in a field to be used in an (external) API call to receive a response that can be saved in another field.
For example: let's say I have a field called 'country' and another called 'capital_city'. When a record is created, the data saved in 'country' is used to make an API call that will return the capital city, which will then be saved to the 'capital_city' field.
Can someone walk me through how I could accomplish this? I'm not sure whether this use case fits a function or a task? I haven't upgraded to a paid account yet, so I don't really understand how tasks differ from functions.
Thank you! I appreciate your time!