Is it possible pull data from an api and use it in a form a have in my appsheet project?

[Yowil_Amez26]

Hello, I have a form with multiple inputs, and when user inserts an id in an input the rest of the inputs autofill with the information I get from my api. I found multiple ways to get data from an api but thats only if I save the id number in a row.

[dbaum]

---

@Yowil_Amez26 wrote:

only if I save the id number in a row

---

That step is indeed on the critical path. If you need to reference data in making an API call, you must have the data saved to be available for reference.

Maybe you're asking whether there's a way to make the API call without requiring users to first save a form? Consider instead using a detail view with the ID column enabled for quick edit. In that case, you'd still need a row to first exist and the ID column can't be the row key.