In my country, all invoices have a mandatory QR Code that follows a structure like A:value * B:value * C:value * etc (no spaces between * and values) having 40 possible fields, and the last field, S: can have multiple values like S:value1;value2;value3.p
What i am trying to do is a Pack that or inserts the full code in a column row, and autofill each field to the correspondent column, or that reads the code and autofill the value to each correspondent column. I need the option to manually choose what value goes to what column or if it simply dont go anywhere (i think i saw somewhere like a workaround to this using auth fields or something like that)
Since i already have a table where i am inserting the invoices details manually for 2 years, i would like that the fields are inserted as value (text, number, etc) , and not as formula result, in order to keep the previous values.
I dont have a problem with scanning the code to an excel or something like that and then paste the value on the table if it simplifies the pack development, but i really like the idea of using tasker, as a already existing pack does.
Anyone can help me, first, on if it is possible to make such a pack, and second, give me some help in making it? I already develop some versions (not gonna lie, through gpt/claude and cursor) but i can get it right.
I don’t have a complete answer and I a not even sure I fully understand how you want to process the data that goes into Coda, but this might get you started.
Tasker can send a webhook to Coda (set up the receiving end up in a coda automation). Once the automation is triggered by the webhook, you can use all the information delivered by the webhook (probably json) and do with it whatever you want.
This has been done for barcodes, QR codes, gps data, etc. I have experimented with this and successfully send barcodes and data into Coda with tasker. At some point I had to get some support from tasker and the pointed me to a different version of tasker - and then it worked.
Thank you for your answer. Ultimately and ideally, at last instance, that is the mean from getting the QR Code Data. I really apreciate the fact, that tou confirmed to me that is possible.
What i want to do to is basically, grab the code data, lets say that is: A:56984 * B:83738 * C:name * D:506.78.
I want to that code to go on the existing table as a text/number value (not like function result/non editable) as i chose in the pack settings to that table. Example: field A: goes to column Vat numberr as 56984, field B: not used, field C: goes to the column Vendor Name as name, field D: goes to the column Invoice Total as 506.78.
Hope, i expressed better this time.
Sorry for my english as well
That is exactly what I understood and yes, it can be done. But you will need some code to extract the values from the json and put the values in the specific fields (columns) of your table.