SQL for insert data on TextBox in DynaForm

Forum rules: Please search to see if a question has already asked before creating a new topic. Please don't post the same question in multiple forums.

2 posts
First unread post

2 posts

SQL for insert data on TextBox in DynaForm#825324

By razinkac - Tue Jul 09, 2019 4:04 am

- Tue Jul 09, 2019 4:04 am #825324

what SQL looks like in this video for Textbox (Price, Author, etc) ?

Webinar: Connecting ProcessMaker to Your PostgreSQL Database

thanks!

Re: SQL for insert data on TextBox in DynaForm#825338

By amosbatto - Tue Jul 09, 2019 9:31 pm

- Tue Jul 09, 2019 9:31 pm #825338

I don't have the SQL queries used in that webinar. Do you have a specific question?

This documentation might help you:
https://wiki.processmaker.com/3.0/DynaF ... Connection
https://wiki.processmaker.com/3.0/DynaF ... erties#SQL
https://wiki.processmaker.com/3.1/Dependent_Fields

If you want to use SQL to populate a text field in a Dynaform, first create a Database Connection to your database. If you want to query the ProcessMaker tables or a PM Table, then you don't need to create a Database Connection.