Grid Edit Address Field

  • 1
  • 1
  • Question
  • Updated 2 months ago
  • Answered
Hello,

Any ideas on how to use the Address field in Grid Edit? 

My users need to load ~100 businesses to the app, including the address of the business. The Address subfields aren't available options to add to a Grid Edit form, and when Grid Editing a normal table report, the Address field stays intact (without the subfields) and is not editable. 

Thanks!
Photo of Heather Bryant

Heather Bryant

  • 1,106 Points 1k badge 2x thumb

Posted 2 years ago

  • 1
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
In fact you can build a table report and select coumns of the individual address field components, and then Grid Edit
Photo of Heather Bryant

Heather Bryant

  • 1,106 Points 1k badge 2x thumb
Mark, do you have a trick for showing the Address field in View mode of the report and the sub fields in Grid Edit?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
To answer this question, in fact you can make a form, yes a form that lists the field you want to use for Grid Edit. I took back to the name that form Grid Edit Form. .

And then in your forms usage you can specify that that form gets used for grid
Edit on a particular report. Therefore when they go into Grid Edit mode, instead of seeing the combined address field, the users will see the individual address components.
Photo of Heather Bryant

Heather Bryant

  • 1,106 Points 1k badge 2x thumb
Hey Mark,
I went to implement this in a new app and the sub fields aren't accessible on the form to create Grid Edit.

They were for sure last year, right? I'm not going crazy?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
Hmmmm, you are right, but now I don't specifically recall that they used to be there.  I just tried also to make a form to see if the individually address subfields could be put on a form and no they cannot.

I do know that you can make a saved table to table import to import the records into themselves and that would allow you to populate the address subfields.

Like filter the import on where the sub fields are blank, but the data entry fields are not. Then make a URL formula button to run the import or run it on a scheduled or record change Automation.
Photo of Heather Bryant

Heather Bryant

  • 1,106 Points 1k badge 2x thumb
I am pretty sure I was able to use your solution, with the caveat being you couldn’t edit the form after creating it. But I don’t know now
Photo of Heather Bryant

Heather Bryant

  • 1,106 Points 1k badge 2x thumb
Thanks Mark! I was trying to add to an existing report. This worked great. 
Photo of Jonathan

Jonathan

  • 100 Points 100 badge 2x thumb
Is there any way to also include the search field so I can paste an address from somewhere else and have it populate the individual subfields automatically?