I have tried all type of write action but doesnt give what i am looking for
i put update where condition aid=student_no
what i am looking for is if this student no exist update if not insert
after there is insert update and all other sections exists, dont tell me use switch or php😲
Auto detect works off of the primary key. If you're having trouble what you can do is have a read data action looking for the record to update. If it's found, have a save data action set to update. If it's not found, have one set to insert.
Can also try the "Insert - on duplicate key update"
"Insert - on duplicate key update" will do what you need!
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
insert on update doesnt work
i have read aid:student_no
then form data provider is this db read
then i have module Student[name].........
then when i say db save what ever you say doesnt work
even when i open text puts comes loaded with new student page whit your suggestion
What is the debug result of the "save data" ?
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
