Content Suggestions

Feature Requests
42

3 posts were split to a new topic: Code formatting

43

Database has events, can run functions based on create, delete, inserts has access to row data or range of data.

Pub/Sub, Client/Server, or a SignalR type infrastructure (real time UI updates), goes hand in hand with the database events.

Tables, when viewing a table, filters, search table.

44

Welcome to the Forum!

The above probably belongs as its own, independent Feature Request, under its own, specific title. It deserves separate attention.

This sounds a lot like SQL’s triggers and views.

Filtering is already supported. See “Query Operators” in Searching (querying) a Table. Also see Views.

Triggers and Transactions go hand-in hand.

  • If a trigger receives bad data, then to prevent writing the bad data into the database, it should probably abort the current transaction.
  • If a trigger requires adding detail records, in some other table, then it should probably extend the current transaction to include that update. That way, if the original update/add/delete fails, and the parent record isn’t written, then the (orphaned) detail records won’t get written, either.
45

I would like to know how to work with dates.

46

This is best asked in general Q&A (Questions and Answers).

While Anvil uses Python, it does not define Python. That includes Python’s date type. Anvil’s documentation focuses largely on Anvil, leaving documentation of the language and its data types to other, widely-available sources.

For example, there is good information in Python’s own reference material (e.g., Our Documentation | Python.org, datetime — Basic date and time types), and in blogs and tutorials across YouTube and the web (e.g., Ten Python datetime pitfalls, and what libraries are (not) doing about it | Arie Bovenberg).

47

I was looking through past forum entries last night and came across a thread from last December where folks were sharing their work. I was impressed with some of the GUI’s I saw. So I’d love to see a tutorial (or tutorials!) about how to make more complex or sophisticated looking user interfaces. I assume we’d learn about different layout components and how they can be used together to create beautiful interfaces.

Of course, the existing tutorials–designed to show something else–aren’t going to distract learners with complex user interfaces. But wouldn’t it be cool to demonstrate what Anvil can do?

Before discovering Anvil I tinkered with Flutter. The Flutter world is full of tutorials demonstrating sophisticated interfaces. I don’t need to learn to make a Twitter or Yelp clone with Anvil, but I do think this topic would be a selling point for the framework.

3 Likes
48

Probable typo in

Existing text:

… This is an irreversible change to our app, …

I suspect you intended this:

… This is an irreversible change to your app, …

Edit 1: Step 1 and Step 4 are listed twice.

Edit 2: If I’m not mistaken, Anvil’s Routing feature depends on Layouts. It might be useful to mention this up front, as a solid reason why one might want or need to port their App to Layouts.

2 Likes