@J_jvs
Displaying a tip during an app start is relatively easy. However it won’t be working as expected, when the user minimizes the app and let it run in the background app drawer. To display a tip in a form when the user is entering a data, is easy too. To achieve that:
- Create a Tips table with ID, Tip# and Tip columns. Tip# is Number type and the rest is text.
- Import this table as Read-Only to your app.
- In the table that the form data belongs, add a Virtual Column with Show type and Text as content type.
- In the Content property of this column, you can use an expression like this:
ANY(
SELECT(
TipsTableName[TipColumn],[Tip#]=RANDBETWEEN(1, MAX(TipsTableName[Tip#]))
)
)
This expression will display a random tip from the Tips table everytime the user opens that form to enter some data.
LinkedIn
Twitter
