Discussions

Expand all | Collapse all

Grid Edit Address Field

  • 1.  Grid Edit Address Field

    Posted 04-05-2017 17:32
    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!


  • 2.  RE: Grid Edit Address Field

    Posted 04-05-2017 17:44
    In fact you can build a table report and select coumns of the individual address field components, and then Grid Edit


  • 3.  RE: Grid Edit Address Field

    Posted 04-05-2017 17:52
    Mark, do you have a trick for showing the Address field in View mode of the report and the sub fields in Grid Edit?


  • 4.  RE: Grid Edit Address Field

    Posted 04-05-2017 19:39
    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.


  • 5.  RE: Grid Edit Address Field

    Posted 03-01-2019 16:15
    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?


  • 6.  RE: Grid Edit Address Field

    Posted 03-01-2019 16:31
    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.


  • 7.  RE: Grid Edit Address Field

    Posted 03-01-2019 16:49
    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


  • 8.  RE: Grid Edit Address Field

    Posted 04-05-2017 17:46
    Thanks Mark! I was trying to add to an existing report. This worked great. 


  • 9.  RE: Grid Edit Address Field

    Posted 01-03-2018 21:08
    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?