Hello
If in Write action - Update data is updated. If in Write action - Insert data is inserted.
If in Write action - Auto detect data is updated but not inserted.
Why is that? What you need to specify so that the insert is?
Thank you
If in Write action - Update data is updated. If in Write action - Insert data is inserted.
If in Write action - Auto detect data is updated but not inserted.
Why is that? What you need to specify so that the insert is?
Thank you
Hi Maxvl,
The Data Save looks for a record id in the form data - if one is found it updates the existing record, if not it creates new one.
Bob
The Data Save looks for a record id in the form data - if one is found it updates the existing record, if not it creates new one.
Bob
Also you're telling it to update only the records that match the user id, account, AND the date. Is that right?
Right, master need to specify the number every day. Sometimes the number is incorrect, then it is indicated again.
It is not clear why the record is not create...
It is not clear why the record is not create...
use a debug and post the results
Okay well do it this way.
Have a read data action, the where conditions taken from your update conditions you have now. In the "found"event have a save data set to update. In the "not found" have a save data set to insert.
Auto detect only seems to work when you have an id you're checking on
Have a read data action, the where conditions taken from your update conditions you have now. In the "found"event have a save data set to update. In the "not found" have a save data set to insert.
Auto detect only seems to work when you have an id you're checking on
what data format do i need to specify for the update to be monthly?
when {date:Y-m} not executed
when {date:Y-m} not executed
Try
Probably won't work and if it doesn't do
YEAR(model.date):{date:Y}
MONTH(model.date):{date:m}
EXTRACT(year_month from model.date):{date:Y-m}Probably won't work and if it doesn't do
YEAR(model.date):{date:Y}
MONTH(model.date):{date:m}
The syntax is what gave you. Replace model.date with the name of your model and date field (so created I suppose)
This topic is locked and no more replies can be posted.
