Hello - I have some questions relating to using Data Sources:
- What is the correct approach to make and use calculations based on values in a Data Source field? For example, if a user enters a date on a form that is stored in a Data Source row, I need a dynamic field that calculates the number of days between today and that date (with some error handling etc). In a spreadsheet this would be easy but I can’t see how this could be replicated here. Is the only approach to calculate these things on the fly, using Javascript?
- Similarly, what’s the best approach to adding a look-up based on the Data Source value? For example, a user chooses an item from a dropdown list, and the Data Source table stores this together with a category field based on looking up the item in a separate developer-maintained list?
- Is it possible to access a particular Data Source via an API or to export a CSV in an automated way, for example once a day, ideally via secure file transfer? This would be to faciliate back-end scripting, for example, creating emails based on a Data Source contents to be sent via a separate email service.
Thank you!