Please Help! Hi I need my sheets to auto fill on sync

[peter_jenkinson]

hello

Hi I need my sheets to auto fill on sync
instead on only getting the info when I am editing and saving a form

I have this setup
using
ANY(SELECT(PM Permits[Url GoogleD], AND([Permit Date] = [_THISROW].[DATE],[PIC] = [_THISROW].[PIC],CONTAINS([Description of Works], [Asset]))))

its gets data from another table and places it when editing the form

but what I want it to do rather is to just go and auto fill the sheet instead of filling and saving the form to get
it to show up in the google sheets

I just want it to use this
ANY(SELECT(PM Permits[Url GoogleD], AND([Permit Date] = [_THISROW].[DATE],[PIC] = [_THISROW].[PIC],CONTAINS([Description of Works], [Asset]))))

to autofill on sync or something

Any ideas?

thanks in advanced

[peter_jenkinson]

see its only saves these when save the form

[LeventK]

I’m afraid we can’t follow you. What do you mean with auto-fill?? Besides ANY(SELECT(…)) expression selects only the first item in a list.

[peter_jenkinson]

peter_jenkinson1:

ANY(SELECT(PM Permits[Url GoogleD], AND([Permit Date] = [_THISROW].[DATE],[PIC] = [_THISROW].[PIC],CONTAINS([Description of Works], [Asset]))))

its only saving the data to the sheet when I save the form, I want to prepopulate the column rather than saving the form to get it to save to the sheet

does this make sense sorry I am trying to be clear as a can

[LeventK · Accepted solution]

A form can only record a single row of data, cannot auto-fill data across several rows. If you want to record multiple rows of data, you need to use a webhook workflow with preset AppSheet API :: Add row and in your JSON payload you need to use a <<Start>><<End>> expression which should loop around a set of records defined by the key column value.