[cosyxu]

Hi Everyone,

Is there anyone meet this situation ?

I want to let my friend to fill in a Dynaform by sending him a link which is generated by Web Entry.

I found the Drop-down list(Select Name) can work on his computer but the function of populating the email and address are not working. I assume maybe because my browser saved the cookies when I generated the link. However, my friend's browser do not have these cookies, therefore the email and address cannot show up after select name.

So, how to solve this problem ? Please, I need some help.

Many thanks,
Yuan

[ethanpresberg]

If I understand correctly, you want to prepopulate data on a web entry form?

If so, you can use code similar to this for your web entry file:

Notice mainly the APP_DATA part in the array. This is where we pass the data for the form to render and populate with.

Code: Select all

<?php
global $_DBArray;
if (!isset($_DBArray)) {
  $_DBArray = array();
}
$_SESSION["PROCESS"] = "19938224056ddbf967443e2004434939";
$_SESSION["CURRENT_DYN_UID"] = "84180149456ddd2194664d6061317361";

$G_PUBLISH = new Publisher();
G::LoadClass("pmDynaform");

$a = new pmDynaform(array("CURRENT_DYNAFORM" => "84180149456ddd2194664d6061317361", "APP_DATA" => array("Email" => $_REQUEST['email'])));

if ($a->isResponsive()) {
  $a->printWebEntry("81728445256dee6e620e626091892649Post.php");
}else{
  $G_PUBLISH->AddContent("dynaform", "xmlform", "19938224056ddbf967443e2004434939/84180149456ddd2194664d6061317361", "", array(), "81728445256dee6e620e626091892649Post.php");
  G::RenderPage("publish", "blank");
}

[cosyxu]

Hi Ethan,


Thanks for your kind reply.

I will have a try today.


Thank you very much.

Yuan

[cosyxu]

Hi Ethan,

Good morning,

Can you please advise on where the Web Service User and Password are set in ProcessMaker 3.0 when creating a web entry form.

I note that this setting was readily accessible in ProcessMaker 2.0 (see screen shot [1] ) however we can't find this setting in ver. 3.0.

screen shot [1]
web entry.png (33.3 KiB) Viewed 7811 times

The situation currently we meet is :

I send a web entry link to my friend sysworkflow/en/neoclassic/35740162456ef20e42d8958056042462/85868877456ef20e4a6e6d9088208618.php

Please find attached screen shot [2]. My friend's form can not populate the email after select the name. However mine works.

screen shot [2]
web2.png (13.92 KiB) Viewed 7811 times

* The form is using external database MSSQL to get the data. Here is the SQL query I used,

For managerName :
SELECT sync_key, first_name + ' ' + last_name AS Whole_name FROM dbo.STAFFDETAIL
Where attributes != '' and email_address != '' Order by first_name

For managerEmail :
SELECT email_address FROM STAFFDETAIL Where sync_key = "@#managerName"

I also found once I logged out from the ProcessMaker I could not use the populate function either.

Thank you for taking time to read this.



Many thanks,

Yuan

[ethanpresberg]

Are there any errors in the console?

[cosyxu]

No, there is not any errors in the console, it seems the dependent field(Email) just doesn't work, and the form could only populate once from the database.

[cosyxu]

Hi Ethan,

We have created a Web Entry form that dynamically populates data from our MSSQL database however this only works if we have an active logged in ProcessMaker session open.

Upon further investigation it seems that the Web Form will use the same "PHPSESSID" cookie as the authenticated ProcessMaker session thus allowing the MSSQL data to pass through and present on the form.

If we don't have an active authenticated Process Maker session open the Web Entry form creates it's own "PHPSESSID" which we suspect is not authenticated thus does not pass the MSSQL data through.

We are looking to create an anonymous Web Entry form for internal use however we need some fields to be dynamically populated from an internal MSSQL database.

Is there any way for the Web Entry form to use a single authenticated web service account to enable the MSSQL data presentation?

This seemed to be available up to ProcessMaker Ver. 2.8 however the setting doesn't seem to be available on version 3.0.

If you could please advise on how we can resolve this issue it would be greatly appreciated as this is crucial to our testing.


Cheers,
Yuan

[ethanpresberg]

Have you created a bug ticket in our mantis? bugs.processmaker.com

[cosyxu]

Yes

[cosyxu]

Hi Ethan,

Yes, I have created a bug ticket with Reference No.0020234.

Hope it can be solved because if this function works my company will use it.

Thanks,

Yuan

[gbalbach]

Did you ever get any resolution on this? Our 2.x cases with web entry doing almost the same thing as your example worked fine in our 3.0.1.7 but when upgrading to 3.2 the same error happens you describe. I should note our example is just using 2 drop down fields, the second being dependent on the first - user selects a ProcessMaker user group, then the group ID is used in the second drop down to populate a list of users from the group, all from the ProcessMaker database (nothing external).

[keyangl]

Hi there,

Same situation for me.
I have 1 dropdown that has 'Types' and another that is dependent on that 'Type'.
When i launch it as a Web Entry, the console says accessToken is null or undefined.
The purpose of Web Entry is for anonymous submissions, how do i fix this?

[amosbatto]

keyangl,
I don't see any problem when I do dependent field SQL queries to MySQL 5.5.47 in ProcessMaker 3.2.1 Community.
What version of PM and what database and version are you using?
Also, was your Web Entry user imported using LDAP?

By the way, web entry has been totally rewritten in PM 3.2.2, so this problem might no longer exist in the latest version of PM.

[keyangl]

Oh right, im using 3.0.1.7.
Thank you