Quickbase Action Add Child Record with Grandchild Text look-up

Question

Hello,I am trying to set up a quickbase action to add multiple child records to another table.&nbsp; This works fine but I cannot write values to a dropdown list that comes from the other table.&nbsp; Basically the action in Table A causes multiple entries in Table B.&nbsp; One of the fields in Table B is a dropdown with entries from Table C.&nbsp; I cannot write entries into this field for some reason.&nbsp; Is there a work around for this?&nbsp;

quickbasecoachd · Answer

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.

michaelberling1 · Answer

So there is a field call [Related Table C] which uses the [Record ID#] although i just use the proxy field.&nbsp; I cannot seem to write numeric values either.&nbsp; The only fields that show as editable within the QB Action page are the regular text fields

quickbasecoachd · Answer

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.

Forum Discussion

Quickbase Action Add Child Record with Grandchild Text look-up

3 Replies

Related Content

Quickbase Resources

Getting Familiar with Quickbase Navigation

A way to look up a previous Record ID's [Date Created] Field

QuickBase Scripts

Posting from an HTML form directly to Quickbase