I have an application that requires that the description field be constructed in HTML format. For this, I want to use an HTML Editor control, much like that offered by DNN.
However, in Live Forms 5, I have tried to bind the HTML-Editor control to a database table field, with no success as yet.
Can this binding of the HTML Editor be accomplished in Live Forms 5, if so, how?
Please navigate to Manage > Options > Actions > On Form View > Bind or update a single form field via SQL Query
[HTML Editor] token is aprearing in the dropdown of Personalization. See attached HTMLEditorToken.png
You can write sql query based on html editor token in this action(Bind or update a single form field via SQL Query)
Thank you for your reply. However, I am still not able to bind the HTML Editor field to the SQL query. Yes, the name of the field does show up in the Personalization drop down menu.
However, it does not appear in the Field Name drop down, which as I understand the application, is the field to which the output of SQL query is bound. This is the main area of concern. Unless the field appears in the Field Name drop down I would not be able to bind the output of the SQL query to that field on the form. See the attached file.
Is this a bug or is there a work-around?
Thank you for a great application.
Hans
I guess that we will not be able to use Live Forms for a serious database application, as I have not been able to get the bind to multiple forms feature to work.
I would be helpful if the documentation would include the FULL code and screen prints of the sample application for use as a templete, as I cannot get the cars application to work also.
Unfortunatly, It is not possible at bind HTML format content in any field from SQL at this time. Please add this to our Community Ideas
Please open a support ticket through https://www.mandeeps.com/support/standard and let us know what defficulty you are facing in multiple field build feature.
Please see below SQL Query to know how to bind HTML Editor control to database table
Ex:
update tblEditor set Editor=[HTML Editor] where id=1
I am now using LiveForms 6.0 and notice that there is a "field" called HTML Editor with the ability to assign a Field Name to this control, similar to other fields, such as Textarea. However, when I attempt to bind this control to a SQL query from a database that contains a text file written HTML, I am not able to do so, as the Field Name for the HTML Control does not appear in the drop down.
How can this be changed so that the HTML Control can be bound to a field in a SQL query, for both display (Select) and Update or Insert?
Thanks for a great DNN Module,
BTW ...the above SQL query makes no sense to me....what is tblEditor table???
Thank you for a great application
You can render SQL data in HTML field instead.
See https://www.mandeeps.com/support/knowledgebase/live-forms-actions-on-form-view-bind-multiple-form-fields-via-sql-query
You can use Token Prefix in HTML field.