Discussions

 View Only
  • 1.  Cross App form not showing text lookup field info

    Posted 03-28-2023 08:01

    Hi all! 

    I have a cross app form on a child table (App B) with a parent table (App A) because users of the form in App B need to see the information inputted by users in App A, but do not need to have access to change it. I've modified the permissions on the fields in App A and App B so all users have a minimum of view access, but when I look at the form in App B, all of the fields appear blank even though they have data in them in the parent table in App A. I keep thinking I'm missing something simple. Thoughts/ideas? 



    ------------------------------
    Becky Heineman
    ------------------------------


  • 2.  RE: Cross App form not showing text lookup field info

    Posted 03-28-2023 08:16

    Uses will need View access to App A.  They need to be on the list of Users in App A.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Cross App form not showing text lookup field info

    Posted 03-28-2023 08:44

    Thanks Mark! I'll double check but I'm fairly certain users in App B have view access to App A and are all on the User list. They can view the form - but it's blank for them as participants just as it is for myself and I'm an admin in both apps.  Feels like I'm missing something simple though. 



    ------------------------------
    Becky Heineman
    ------------------------------



  • 4.  RE: Cross App form not showing text lookup field info

    Posted 03-28-2023 08:51

     OK well that is a different story completely if you as the admin cannot see the look up fields. Have you been messing around with field level permissions? Have you perhaps messed up the field level permissions for Related Parent? 

    Is the child record in fact connected to a Parent?



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Cross App form not showing text lookup field info

    Posted 03-28-2023 10:13

    I can see the fields themselves (since they are part of the table to table relationship) but the information in the field is blank - so I see the field title and then nothing on the form. I've checked field level permissions on the related parent field and all roles are set to view or modify. All of the child fields show the correct related parent field. 



    ------------------------------
    Becky Heineman
    ------------------------------



  • 6.  RE: Cross App form not showing text lookup field info

    Posted 03-28-2023 10:18

    Well I'm curious, so if you like,  contact me directly by the email in my signature line and I will have a look on Zoom.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 7.  RE: Cross App form not showing text lookup field info

    Posted 03-28-2023 10:52

    Thanks Mark!  I'm fairly certain I've whittled it down to being the table to table relationship not being the right kind or needing the reference field changed. 



    ------------------------------
    Becky Heineman
    ------------------------------