Link to home
Start Free TrialLog in
Avatar of cyle
cyle

asked on

Embedded View from a response to response form

Hi! I have created 3 forms
    form1      Document  -- works fine
    form2      Response  -- inherits form1num from form1
                                  -- computes for form2num
    form3      R to R       --  a hotspot button (from form2) that gives me this form3
                                  --  this has a view called RR_VIEW
    RR_View is then embedded to the form2.
    The problem is that the embedded view in form2 is empty, but if I view it from view it does have values in it.
    RR_View Select form="form3"
    Embedded view = f3embedview
    SS Category      = form2num (my view has form2num on the left and is categorized)
I guess I have all the info. Thank you.


     
Avatar of CRAK
CRAK
Flag of Netherlands image

Since RR_View only selects "Form = form3", first check if the view is hierarchical (in view properties)... it should NOT be since the parent documents (form1) are not included.
Check if the category in RR_View is ok e.g a reference to a field on form1, or @Text($Ref)
Check if the single category formula in the embedded view is ok with this category. Bear in mind that additional spaces may mess things up, that things are case sensitive and type specific (looking for "123" as text in a view that only has 123 as number in a category may not work (never tried it, but it won't work in @DbLookup... I don't expect it to work here either)
Avatar of cyle
cyle

ASKER

1. No, not hierarchical, only have Allow customization (this fine?)
2. The category in RR_View is form2num
3. The embedded view also has form2num as single category
4. I will not be typing any text since everytime I add data to form3 the embedded view should have that information based on form3num.
Avatar of cyle

ASKER

FYI, when I remove the Single category I can display info but the problem is all of i is displayed.
Is the category a numeric field.. if so try the category of the column converted to text py placing @Text around the field value

~Hemanth
Avatar of cyle

ASKER

I got it and the problem was I removed heading from the view. Thanks for helping.
Avatar of cyle

ASKER

What's the policy or what do I do if the answer was different from given and yet I still want to give some of the points to the expert?
SOLUTION
Avatar of CRAK
CRAK
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cyle

ASKER

Thanks!