Question/Help: How can we remove the duplicate entries and just have unique workstream populate in the Projects_Form
2. Projects Form Sub-Workstream Drop Down:
Issue: While clicking on the “Sub-Workstream” drop down in the project form, it’s showing the list of “Workstream” similar to the above snip and not Sub-worksteam as shown in the first attached snip. Please see below:
The [Country] is shown only after [Continent] is selected and [Document] is shown only after [Country] is selected. Both [Country] and [Document] are dependent dropdowns.
Thanks @Suvrutt_Gurjar - It did work but now giving me this error “Unable to add row to table ‘Comments’. → Invalid request provided to AppSheet database”
AppSheet Database started as an independent project outside of AppSheet and grafted on later. As a result, you have a wildly inconsistent pair of interfaces. I don’t find Database particularly intuitive, requiring me to learn an entirely new set of skills without any obvious benefit. Google Sheets is something I already know well, so it’s easy for me to work with it. In fact, AppSheet’s original target market was spreadsheet users who wanted to build an app atop their spreadsheets.
Because Database was not originally designed for AppSheet, there are some glaring gaps in its AppSheet integration, not the least of which is the inability to choose the key column! No virtual column keys, no composite keys, no using keys to enforce unique data values.
Labels must be defined in the database, which means labels cannot be virtual columns, which means no dynamic labels.
Databases appear to have many more limitations than Sheets for tables and rows, but oddly suffer from some of the same performance constraints that Sheets do.
Configuring and connecting a worksheet is much simpler than configuring and connecting a Database table. With a worksheet, there is very little configuration of the worksheet needed: just add columns and their headers. Everything else is done in the app editor. But with Database, there’s so much back and forth to configure columns in Database then back to the app editor to configure them more.
There have been numerous posts here about odd behavior using Database that disappeared once switched to Sheets.
Why might you see Database as a compelling option, @Fabian_Weller ?
@Suvrutt_Gurjar - Apologies for the late reply. I worked out the solution. Please see below:
Add a new table and create a text column Sub-Workstream and Workstream ref to Existing Workstream table (Mistake was adding column to Workstream table vs creating a new table)
Add Column to project table “Sub-Workstream” and ref it to the Sub-Workstream table that was created in step 1.
