I’m migrating from using Excel to Knack and so far I am really impressed.
However, I am now trying to reference data records in an object (for example, historical exchange rates) that I need to look up based on a value (such as date) in a different object.
Ideally, I need to use the looked up value in a Knack equation (so I can calculate a foreign currency value), or failing that set a field in the referencing object with the looked up value so that it can be used in an equation (to calculate the foreign currency value).
In Excel this was accomplished using VLOOKUP. However, In Knack, I understand it requires a custom API, but I am not a developer, so I need more help than is available in Knack’s API documentation.
So, if you have experience creating APIs like this, where do you recommend I begin.
Alternatively, if you are a freelancer who could help with this and similar future requirements, please let me know.