I have an app connected to Google Sheets. Phone and Address columns in my detail views used to be interactive, tapping a phone number initiated a call, and tapping an address opened Google Maps. Both stopped working, and I can’t get them back.
This started after I renamed several spreadsheet columns (capitalized the headers, e.g. status to Status, tech_email to Technician_Email) and then regenerated the table structure in AppSheet to pick up the new names. After regenerating, a few things broke that I’ve since fixed (a security filter and some format rules referenced old column names). But tap-to-call and tap-to-map are still dead.
Things I’ve already verified/tried, so these are ruled out:
- Phone column Type = Phone; Address column Type = Address (confirmed in Data editor)
- Callable and Textable are checked on the Phone column
- Quick edit columns on the detail view is empty (nothing forcing edit mode)
- Key column is set to a real ID column (not _RowNumber)
- Column Show? is on; the values display fine — they just aren’t tappable
- Fails in both the editor preview and the installed phone app
- I re-sync the app every time
- Toggling the column types/settings off and back on (re-bind) did not help
Phone values are stored in E.164 format (e.g. +12175550100).
Has anyone seen Phone/Address interactivity break specifically after a regenerate table structure operation, and is there a known fix to restore tap-to-call and tap-to-map? Thanks for any help.
Hi @mosaictechsystems
Take a look at your Google Sheet. You might have added a column before the phone and address columns. Is the phone number in the phone column, and the address in the address column? Check the data, but perhaps the column has increased, but the data hasn’t shifted.
Definitely worth the double check, and everything is in its right spot. It also appears in the app sheet properly the phone number is just no long “clickable”, same with the address not even showing the map like it previously did.
Hi @mosaictechsystems
Maybe you clicked on data that didn’t contain a phone number or address, so it didn’t respond. Or try checking the action below, do this, in the TO section, which contains the phone column, attach to column phone
@mosaictechsystems
Hope you are keeping well.
Try checking under your actions and verify what you see there. Appsheet initially would have generated a View Map, Phone/Call and Email actions, it is possible they are hard-coded to still go to the previous column names you had (that’s if you changed the column names of address and email)
Maybe delete those (Just remembeted now you cannot delete these 
) so check if there are behavioral conditions blocking it with old column names that maybe didn’t update)
It was this hardcoding of the old columns. Thank you very much for your help
@mosaictechsystems
Glad it was sorted… I saw you marked solution as Syamsudin mentioned, was the address click to map issue resolved in the same way? Making sure future users easily identify solution when searching forums..
Yes It was, I was thinking that it was a combination of both responses that allowed me to find the solution and thought I could click both.
So it was all the fields were still populated by the old lower case fields, I went through and updated everything manually.
That’s perfect, many future users will benifit from clarifying when they search issues.
Glad you have got this sorted, it can be frustrating knowing all areas that can be affected with column changes…
