A form that sits on live data to fill in text boxes once one is filled out

Help Apps
,
1

Hi everyone,

I have created an app that contains a form I want to send out. See image- My goal is to have the outlet number typed in by the employee and the next 4 textbox automatically be filled out based on live data from an excel worksheet.

I’ve tried creating a queue but it seemed to be in the wrong format when i tried exporting it to a .json. If there is any way to go about this I would love some tips on what others have tried. Thanks!

Screenshot 2024-11-26 113943
Screenshot 2024-11-26 113943738×232 5.44 KB

2

@Allyg

Welcome to the community

is it mandate to have the data in excel? if not loading to dataservice you can directly query in realtime and get it

else create a rule on first field trigger a process to get the data and populated the returned data here

cheers

3

Thank you,

I can try loading to a data service. Do you know of any youtube videos/ examples I can reference how to do it?

4

@Allyg

Just go to dataservices tab and you can create a data service and add data and columns you need

And those data servcies can be added to app as a resource and can use

Cheers