Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

web Application Issue: Data being captured but not displaying in Recipient folder

Avatar

Avatar
Validate 1
Level 1
mayank_singh
Level 1

Likes

0 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
mayank_singh
Level 1

Likes

0 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
mayank_singh
Level 1

03-03-2020

Hello Everyone,

 

I am having an issue with the web application.

 

Whenever I fill the form the data is being captured and can be seen in my response logs. But when I tried to look into the folder where I configured the records to be stored the same is visible until I configure the list and try to check the data from the joining table.

 

Configuration: 

Recipient table is connected with a custom table I created with the name of "XYZ" for example.

 

The recipient table has a foreign key of my table(XYZ) and shows connected in the structure just like the link that you can see for the folder in the below picture.

 

mayank_singh_0-1583228474022.png

 

Issue:

I created a web form to store basic details i.e. First Name, Last Name, Email and One column(XYZ) table, which displays fine when configuring the fields of my form.

 

After that, I added a storage activity and configured the data to be stored in a folder under Profiles and targets> Recipients > Test Profiles with the reconciliation condition(email) and added the END activity.

 

I checked the form in the preview mode(Enable Debug mode: Checked) and added the data asked based on the respective fields.

 

The form logged the responses perfectly fine.

 

I went ahead to check the folder where the data should show after being captured and it is showing up fine until I don't add the other column from configure list option.

 

The moment I add the column to view its data the folder shows empty/blank with no records and the moment I remove it the data added is visible again.

 

Troubleshooting done so far:

I added other fields in the form from the below list and mapped it to respective fields, which are highlighted below:

mayank_singh_1-1583229128210.png

After the above process, I configured the list the data is showing fine for these.

 

The issue happens every time I try to add a field related to my table or the folder highlighted in the first snapshot and both the icons shows that they are related in the same way.

 

I would really appreciate if any can find a solution or give me a workaround to resolve this at the earliest.

 

Thanks

 

 

View Entire Topic

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

960 likes

Total Posts

1,090 posts

Correct Reply

508 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

960 likes

Total Posts

1,090 posts

Correct Reply

508 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

03-03-2020

Hi,

 

The column you're adding to your view is causing the view to perform an inner join against a table that doesn't have data in it.

In your web app you need to write this data, alongside the captured recipient data.

 

Thanks,

-Jon