Announcements
The Google Cloud Community will be in read-only from July 16 - July 22 as we migrate to a new platform; refer to this community post for more details.

Pre populate new form in dropdown list

Hi, i have a table1 that refers to table2 in a column type ref , with dropdown view.
if i ned to โ€œaddโ€ new row ( es new customers) directly from this view in dropdown menu, and populate some rows depending from current choose in table 1, how i can do it ? i know how works the linktoform, but in this case , i want to do it from โ€œNewโ€ action in dropdown menu

0 3 508
3 REPLIES 3

Steve
Platinum 5
Platinum 5

This isnโ€™t directly possible, and would take a great deal of effort to do indirectly (if itโ€™s even possible).

i 'm trying whit this formula in the coloumn that i want to populate
if(isnotblank(text(top([Related Table1],1))),โ€œMyvalue1โ€,โ€œMyvalue2โ€) and seems working
the new row has the related table empty, but if i add new rows from the drop menu, the related table is present, even if the row is empty

Hi Fabio.

Could you please explain your formula in a little more detail? Did it have the desired result?

Thank you

Top Labels in this Space