Datablaze add row button

Questions and Help
1

Hi Team,

Can i use the button() function from within a datablaze field, that upon clicking, it copies the entire row into a new row (can be within the same table or different), but updates 1 field which is the date.

My use case is for marking off when a prescription is dispensed. A button would then trigger another row to be created. The new row would contain 1 updated date field for when the repeat on the prescription is due and would be set to 28 days plus the original date in the original row.

Any other ideas on how to automate this if the button code block wont work within datablaze?

Thanks in advance

2

Hi @rohan.r
How many rows do you expect to have in your table? And would managing the same workflow from a snippet, instead of from Data Blaze directly, work?

I can propose a snippet that would do the same.

3

Hi @Dan_Barak1 ,
currently theres about 1000 rows, with about 50 rows added each day. Id prefer to stay within datablaze and use different views for different users, due to the volume of work that needs to be completed. Im also thinking of using webhooks from datablaze that would throw a duplicate row to zapier that would send it to another table in datablaze, when a certain field is ticked as complete (prescription dispensed).

What would your snippet proposal be?

4

{dbselect: SELECT `drug name`, renewal, rowid() AS `Row ID` FROM Table1; space=id; menu=yes}
{`new date`={time: YYYY-MM-DD; at={=renewal}; shift=+1M}}
{button: try
{dbinsert: INSERT INTO Table1 SET `drug name`=`@drug name`, `renewal`=`@new date`; space=id; autoaddfields=no;instant=yes}
catcherror
notify("Oops")
endtry; label=Insert new row}