What did you learn this week? w/o 13/4/20

[jcadence]

Hi everyone!

You all have been teaching us some incredible tips and tricks as of late and I’m really excited to see what everyone has discovered recently. For example, a number of you stated that you would be interested in helping with language translation which prompted us to start this thread.

Ready to share this week’s discovery? What was ONE thing you learned or built this week that made your application(s) better?

[Steve]

How to add any number of rows from any row within a table:

Add any number of rows from any row within a table Tips & Tricks 💡

Definitely a frequently-asked question: how do I add some number of rows to a table automatically? It’s possible, but it’s not easy. This article details an approach that can be accomplished entirely within AppSheet (no API use), within the app itself (no workflow use), and accommodates an arbitrary number of rows (no built-in count maximum). While I’ve tried to make the guide accessible for less-experienced app creators, make no mistake: this is an advanced technique. I hope you find this us…

Updated doc:

help.appsheet.com

How to Manage Your Subscription Plan

After you choose your subscription plan, you can enroll in that plan.

[hru]

I learn LOOKUP() for numbers, it was a bit disappointment that I got lost with the understanding that LOOKUP() is only for text value , but thanks to community for showing me the correct understanding on it.

[jcadence]

Hi @Heru! Can you post a link to the discovery of your answer?

[hru]

Here is the link to the discussion thread.

Why if I call(lookup) data with a long number the results are always changing? Questions

Upps… I got lost by reading the return value syntax: return-column : The name of the column whose value should be returned as literal text value.

It was kind of English things, I believe, since the expression assistance also show something like this:

Which read by me, and lead me to wrongly believed, that LOOKUP() only works for text value, which surely was an incorrect understanding.

However, it was clarified by community with the discussion contained within the thread.