Hi community. As the title says, we’re implementing a Transaction log table that records all inputs in our custom app.
We have two custom apps built with ReactJS. The first app is an Item View feature that contains a form for collecting user input. The second app is an Account Settings View feature that manages credentials and request payloads used by the Item View.
When a form is submitted from the Item View, it sends an HTTP REST API request to our backend application, which is also hosted in monday.com using server-side code.
Our goal is to maintain a transaction log tables for every form submission coming from both the Item View and the Account Settings View. Each form should have its own corresponding table of records. The transaction logs table will be part of our App when it is installed.
What do you think is the best practice for implementing this? Below is our idea we think are best so far:
Create a new Board View that aggregates two tables using the monday.com GraphQL API. This is currently our preferred option. However, the challenge is that the app is not yet installed initially, so the tables are not created beforehand. Is there a way to automatically generate these tables when the app is installed?
Would love hear other ideas for this approach. Thanks