Cell Link from web form

Deepak Adhikary

Hi,

 

I am trying to link the cell to other sheet, once the data is filled up from the web form. The problem I am facing is, whenever the form is submitted & the data is posted on my sheet, it is being posted below the cell which is linked to other sheet.

 

I used the workout of providing the cell background color to white to link the black cell and I guess, while posting the data from the webform, due to background color, it thinks a row has already data (due to white background color) and post the data below that.

 

Please suggest, if there is a way that I can link the cell to other sheet, once the form is submitted.

 

Thank you.

 

Deepak.

 

 

Kennedy Stomps

Hi Deepak-- It isn't currently possible to automatically link rows created from web form entries to another sheet but I've added your vote for this to our enhancement request list. 

 

In the meantime, you might consider a service called Zapier, which allows you to create connections between sheets. For example, you could set up a zap to automatically copy new rows in your web form sheet into a separate sheet, or to update rows on one sheet when changes are made to rows in another sheet. Let me know if you have any questions on this!