Discussions

Expand all | Collapse all

Related Table Troubleshooting

  • 1.  Related Table Troubleshooting

    Posted 11-22-2019 12:43
    Edited by Ivan Weiss 11-22-2019 12:49
    I am getting an error on one of my forms....  Any ideas on how to start troubleshooting this?  Not even sure where to start....



    ------------------------------
    Ivan Weiss
    ------------------------------


  • 2.  RE: Related Table Troubleshooting

    Posted 11-22-2019 13:04
    Edited by Austin K 11-22-2019 13:04
    Is this happening on an Administrator account that for sure has access to that field or the table it is on? Or are you testing as anything else when seeing this?


  • 3.  RE: Related Table Troubleshooting

    Posted 11-22-2019 13:28
    Yes, I am an administrator with full and complete access

    ------------------------------
    Ivan Weiss
    ------------------------------



  • 4.  RE: Related Table Troubleshooting

    Posted 11-22-2019 16:24
    Ivan,

    1) Did you set any Unique Field Level Permissions?



    2) The Opportunity Name is starred as a required field.  Is that set with the field property or is it a form rule?  If it is a form rule, where do you have Related Opportunity?   




    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------



  • 5.  RE: Related Table Troubleshooting

    Posted 11-25-2019 09:28
    Don,
    1.  There are no restrictions on the field on this form.
    2.  It is set as a form rule.  When Task Type is equal to "Opportunity" show "Opportunity-Name" and require "Opportunity-Name"  BUt that Opportunity-Name is the field that is giving me an issue showing me the opportunity it is connected to.

    ------------------------------
    Ivan Weiss
    ------------------------------



  • 6.  RE: Related Table Troubleshooting

    Posted 11-25-2019 10:02
    Edited by Adam Keever 11-25-2019 10:22
    Could it be related to any Role based permissions?


    ------------------------------
    Adam Keever
    ------------------------------



  • 7.  RE: Related Table Troubleshooting

    Posted 11-25-2019 14:13
    That is what I thought but I am the administrator.  So I dont think they would appear on my end

    ------------------------------
    Ivan Weiss
    ------------------------------



  • 8.  RE: Related Table Troubleshooting

    Posted 11-25-2019 14:44
    Hi Ivan,

    When you look at the field settings for that field under the reference and value fields are there fields selected and does it show what relationship this field is part of?


    ------------------------------
    Evan Martinez
    Community Marketing Manager
    Quick Base
    ------------------------------



  • 9.  RE: Related Table Troubleshooting

    Posted 11-25-2019 17:31
    Evan, this is what I get:



    ------------------------------
    Ivan Weiss
    ------------------------------



  • 10.  RE: Related Table Troubleshooting

    Posted 11-25-2019 21:27
    Ivan,

    Throwing a dart with this but ...... uncheck the box to treat blank values as a zero.

    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------