Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
5 years ago

Editable Report Link with Conditional Dropdown?

I have a child table that includes a conditional dropdown. Is there anyway to use this on a report link that is editable? On first glance it seems no, but sometimes people in the community have sneaky tricks....

------------------------------
Mike Tamoush
------------------------------
  • ..  not really understanding the question.  Can you post a screen shot or more explanation?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • MichaelTamoush's avatar
      MichaelTamoush
      Qrew Captain
      See below.

      When using an editable report link, to add new entries you can simply make selections/enter data on the next blank row. One of my selections in this scenario is a related field with a conditional dropwdown. In my picture below, the field the condition is based on (where it says NAD-A) is only filled in the following circumstances:
      a) the entry has already been saved or
      b) the child is created in the traditional way using an add 'child' button which actually takes you to the new record form.

      You can see on a new row, the conditional dropdown field isn't filled in yet, so the selection cannot take place (if I click make a selection it instructs that I need to choose that column first. The column that says nad-a is a lookup field from the parent.).



      ------------------------------
      Mike Tamoush
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        I have not tested but one work around might be to add a dummy field or move the data entry fields so that the first column get populated, such that the record does have some data entry which would cause the lookup to be populated.  I will try a test when I get a chance.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------