Search for existing user or perform XHR request to generate new user record from remote source

[Kevin_Admin]

I have a “users” sheet that contains registered users which are referenced in other tables. I’d like the ability to have a field either autocomplete a user record based on email (like google admin does) from the sheet of existing users, OR, if the entered email is not found create a new user record based on the result of an API call to one of our services which would return a JSON object describing the user fields to be populated. Is this possible? Is there another pattern that would accomplish this in a simple (for the user) way?

[Steve]

Kevin_Admin:

autocomplete a user record based on email

help.appsheet.com

App Formulas and Initial Values

How you can set app formulas and initial values to dynamically assign values.

Kevin_Admin:

create a new user record based on the result of an API call to one of our services which would return a JSON object describing the user fields to be populated

There is no inherent support for this, but you might be able to kludge something together.

help.appsheet.com

Invoking Webhooks from a Workflow Rule or Scheduled Report

Webhooks allow you to invoke a remote web service to perform an action by sending an HTTP request message to that web service.

help.appsheet.com

API: The Essentials

How to use the API to make changes to your app.