In my app, I have a dog list, dog detail, walk form, walk list, walk detail, and walk inline views.
The image below is the dog detail page. I have added an action to this page, the + icon next to the dog name. This links to the walk form where I can select the name of a dog from a list. I would like the action to behave the way it does when I tap the word โNewโ in the Walk inline history. Tapping new brings up the same exact view (walk form) but prefills the dog field with the correct dog name depending on which dog detail page I was previously on. This was configured for me when I started building the app, I canโt figure out why the New action behaves differently than the + action
Thanks Steve,
I have tried a few variations on the formula below where form view name = โactivity_formโ column name = โnameโ column value = โnameโ
LINKTOFORM(activity_form, [name])
LINKTOFORM(activity_form, name, [name])
they both test ok, link to a blank screen.
Activity_form records walks in a google sheet called โwalksโ
The column I want to pre-fill is called โnameโ and is pulled from a sheet called โdogsโ
I have tables named Dogs and Walks respectively. I am not sure which one to associate with the form.
I wish I could just find and copy the action that the โnewโ link in the screenshot creates, but I cannot locate it.
Any help is appreciated. I am very inexperienced in formulas and appsheet in general, but I am learning.
Associate the form with the table to receive the data collected by the form: Walks. You probably have a system-generated Walks_Form form for the Walks table. Iโd recommend using that rather than creating a new form, unless you have a particular need for a different form configuration.
That actually wouldnโt give you what you want.
From everything youโve said about your app, I suspect youโre using the Name column as the key column of the Dogs table. If so, you may want to reconsider that. A key column value must be unique within that column of that table. If Name is the key column for the Dogs table, you could not have two different dogs with the same name.
I was using similar formulas. I made a video to show you the results. Maybe it make it clear what I want to do. Maybe itโs not possible.
Youโre correct I was using the name column as key, because it wouldnโt let me use _rownumber. I added a new column called key, that is blank in the google sheet. If I make that the โkeyโ it doesnโt display any results in the deck view.
User | Count |
---|---|
41 | |
28 | |
28 | |
23 | |
13 |