I'm attempting to create writeback solution for creating and keeping track of trouble tickets. Any suggestions on how I can get Ticket_ID to be autogenerated?
If you're looking to build a ticketing solution with an auto-generated Ticket_ID directly from Qlik Sense, you might consider SenseOps Writeback. It allows you to create forms within Qlik that write data back to a database (such as SQL). The backend can be configured with auto-increment fields or sequences, so the Ticket_ID is generated automatically upon submission.
This enables you to manage ticket creation, updates, and status changes directly inside your Qlik app, rather than handling the process externally. Know More about SenseOps Extensions>>
You can even use the Write table from Qlik however you need to know some limitations - you can't re-use the same object or data storage, and the data is deleted after 90 days.
A key point is to use the functions like Now() in the key field to make it always unique.
I work for Inphinity executing all kinds of writeback projects. I can show you how to do it with our writeback in a very simple but effective way. Send me a message and I can jump on a call with you.
