Best way to extract URL parameters

AppSheet AppSheet Q&A
, ,
1

I am setting up a new app to scan QR codes that have custom URL with parameters. This app is linked to google sheets.

The app is currently working, and properly scanning QR codes, and storing the info into a spreadsheet.

Now, we need to extract the URL parameters into separate columns

Here is a URL example: www.mysite.com?VAR1=one&VAR2=two&VAR3=three

I’d like to extract the 3 variables above, each one in it’s own column

VAR1 | VAR2 | VAR3
one | two | three

What’s the best formula to extract URL parameters? MID() ? FIND()?

2

AppSheet is really not well designed for parsing.

INDEX(
  SPLIT(
    INDEX(
      SPLIT(
        [Url],
        "VAR1="
      ),
      2
    ),
    "&"
  ),
  1
)
3

Thank you, I’ll try the above.

Would be better to setup google sheet formulas to automatically extract variables from the URL?
Otherwise, do you have any other suggestions? Such as setting up a workflow or similar automation (with external providers, like MS Flow or similar)?

Such as : when a new row is added > extract VAR1, VAR2, VAR3?

4

FHLPC:

Would be better to setup google sheet formulas to automatically extract variables from the URL?

If I had a need to extract URL parameters, and the simple parsing I suggested above wasn’t sufficient, I would next try to do it with formulas in my spreadsheet (probably using Google Sheets’ REGEX functions)–with the understanding that processing done by the spreadsheet wouldn’t occur until the app syncs.

FHLPC:

Otherwise, do you have any other suggestions? Such as setting up a workflow or similar automation (with external providers, like MS Flow or similar)?

I’m afraid I have no experience with external providers, so I have no advice to offer there.

5

I know this is an old post, but wondering, is there a way to refer to that [Url] from the current page?