If I set a limit to the number of items shown on my app, will that be a solution to the 500 max rows for my free account?

While you’re thinking about this, go ahead and vote for looped actions.

This would give us the ability to set up an action to purge any records older than a certain date, etc.