Retrieving data from database to populate as a default value in an app

[psja]

Hi all,

I am designing an app that takes user input to be loaded into a database.

Eventually, there will be a database of historical user input.

Would I be able to read the data from the database and put the previously entered answer as the default value in the app?

For example, the user previously enters '100' into a Numeric Up Down tool and it is saved into the database.

Would I be able to read the value the next time the app is loaded and put it as the default value of the Numeric Up Down tool?

Please let me know if more context is required.

Thank you!

[apathetichell · Accepted solution]

Not easily. This is a situation with chained apps - and you'd need to follow this guide:

https://community.alteryx.com/t5/Engine-Works/Dynamic-Hard-Coding-Chained-App-Sorcery/ba-p/764585

the particular part of the interface tool you are trying to edit isn't a variable so it would need to be changed in the app xml prior to running.

[psja]

Ah, I see! I'll try the guide out. Thank you!