Quickbase Action Add Child Record with Grandchild Text look-up

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • In Progress
Hello,

I am trying to set up a quickbase action to add multiple child records to another table.  This works fine but I cannot write values to a dropdown list that comes from the other table. 

Basically the action in Table A causes multiple entries in Table B.  One of the fields in Table B is a dropdown with entries from Table C.  I cannot write entries into this field for some reason.  Is there a work around for this? 
Photo of Michael Berlinger

Michael Berlinger

  • 80 Points 75 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,486 Points 50k badge 2x thumb
If your drop down list is from a relationship, there is probably a field called [Related Table C].  Suppose that table C is a table of customers and the Key field is [Record ID#].

 The value you need to write into the field for [Related Table C] is not the Customer name, but rather the [Record ID#] of the Related Customer.
Photo of Michael Berlinger

Michael Berlinger

  • 80 Points 75 badge 2x thumb
So there is a field call [Related Table C] which uses the [Record ID#] although i just use the proxy field.  I cannot seem to write numeric values either.  The only fields that show as editable within the QB Action page are the regular text fields
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,486 Points 50k badge 2x thumb
You should be able to write into the Field [Related Table C] if it is a data entry type field, ie not a formula or lookup field.