Hi @Scott_Collier-Weir ,
We deal in pharmaceuticals and our product database is huge i.e. 30k rows. If I can solve this issue then I want to build an internal app in Coda for invoicing. Adding all the rows to the Coda doc would not be efficient as we don’t necessarily sell every single product in that list. However, it is very helpful to just be able to type and the select the product.
In addition, I wanted a way to keep the prices of products up to date so that my colleagues don’t have to go and look up the price.
I think that you are right that there are possible workarounds. Based on this thread that you kindly replied on, I think that the searching Google Sheets scenario is a great workaround.
It may be that there are other better workarounds so if anyone else has any ideas, do let me know. As it stands, I am thinking of using this scenario as an opportunity to learn JavaScript and create a Google Sheets pack. I think it would be a good next step in my personal development…
Regards,
Shaheed