I've gotten as far as being able to pull information from a MySQL table into a field of type Database-Dropdown on my Confiform form. Assuming that this success indicates that all configuration steps for the database connection are working properly, I now want to be able to modify information brought into the form and have the changes communicated to the database.
I viewed the CRUD site: (and one or two others that directed me to the site below)
Are there other resources anyone can point out, including ones that perhaps demonstrate how other field types like check boxes and radio buttons are handled? Also, any other suggestions are welcomed.
Probably this is the best page to cover this - https://wiki.vertuna.com/display/CONFIFORMS/Accessing+field+values+and+properties
It explains what is stored (internal value) for each field type and what properties each field type has
Checkboxes operate on true/false and Radio buttons (same as dropdowns and checkbox groups) operate on options with properties id and label
Having digested the contents of the sites you've suggested, I am up against one more obstacle. As I mentioned in an earlier post, I am quite sure I am connected to the db containing the table I want to add a row to via my form. I can populate a database dropdown field with values from the table I am trying to insert a record into.
<ac:structured-macro ac:macro-id="e769fd3d-8d27-451c-ba1a-ccf4e4d32305" ac:name="confiform-ifttt" ac:schema-version="1">
<ac:parameter ac:name="action">Copy ConfiForms Data to DB</ac:parameter>
<ac:parameter ac:name="title">INSERT INTO course_info.booklist(department, courseNumber, courseName, archiveDate, looseLeafISBN, textTitle, edition, publisher, reqOrOpt, notesToStudent, notesToBookstore, authors) VALUES('[entry.department1]', '[entry.courseNumber1]', '[entry.courseName1]', '[entry.archiveDate1]', '[entry.looseLeafISBN1]', '[entry.textTitle1]', '[entry.edition1]', '[entry.publisher1]', '[entry.reqOrOpt1]', '[entry.notesToStudent1]', '[entry.notesToBookstore1]', '[entry.authors1]' )</ac:parameter>
I don't get any errors when I Update the form, but nothing is written to the database. Not much in the way of error messages, attempted writes, etc. in the MySQL side. Any suggestions on what I'm missing, such as the reference to the database (prompted for when I create a Database Dropdown type field? Or, some troubleshoot tips for getting this to work? I can see the records being added to the Edit/View dropdown list at the bottom of the form, and this functionality appears to work fine
Really, without seeing your complete configuration it is hard to tell anything. Open support request with us and we can talk about this issue in more details
ConfiForms has a way to communicate with external databases and it can be set up to react on changes made to ConfiForms records - https://wiki.vertuna.com/display/CONFIFORMS/Configuring+ConfiForms+IFTTT+actions+and+rules#ConfiguringConfiFormsIFTTTactionsandrules-CopyConfiFormsDatatoDB
(have this for 3+ years or so, what "update to the question" you are looking for?)
Hello Community! I hope you've been enjoying the 🍂Apptoberfestivities🍂 (I know I have!) The event is heating up next week with a series of virtual events that we're calling the 🍻🍂Partner App ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events