About Asheetbogo

Asheetbogo · 04-18-2023

hello everybody!I have a virtual Column "VTime" (Expression: =Text(Now(), "hh:mm") and want to use this Virtual Column in a "view", but this column is not showing up for selection when editing the view:Virtual column: "VTime"Test works fine:many than...

Asheetbogo · 03-24-2023

hi everyone!i want to show "historical" data of my table "history" in a virtual column (VHistory):Workaround: Table 1: projects + Table 2: historyGoal:a) for each project in table "history" i only want to see the latest entry (e.g. Tool XS: 2023 > fi...

Asheetbogo · 01-10-2023

hi everyone,how can i alphabeticly sort items of dropdown?a) child-Table: dropdown of column "Street" (items comming from parent-table ...)b) column: "Street" of child-table is connected with "REF" to column "Street" of parent-table:c) parent-table:h...

Asheetbogo · 12-28-2022

I noticed strange behavior when converting "text" to "capital lettes"with expresson "UPPER".step 1:e.g: converting "01mai" to "01MAI" (text > to capital letters) with expression "UPPER"step 2:after saving record everything works fine: "01mai" is conv...

Asheetbogo · 12-01-2022

hi,AppSheet cuts off "leading spaces" when calculating "FIND" expression:GoogleSheetsTable:Row7 = "( Cmd: SID=26)"Row8 = " ( Cmd: SID=1)" <<< 2 leading spaces before "("a) VirtualColumn (VFind"(") caluclates "1" for Row 8 (>>> should be "3)b) Leading...

Asheetbogo · 04-18-2023

hi @Marc_Dillon,Slice? >>> this is a "one shot hit" ! i found out that in my slice checkbox for "select all" was not activated! works perfect now - Thank you so much!!!

Asheetbogo · 03-30-2023

hello @dbaumi tested it out - it works perfect:A) SliceEpression:[Year] = MAX(SELECT(history[Year], [Project] = [_THISROW].[Project]))>>> This showing only one rown for every project (>>> the newest (Year) status of each project >>> MAX([Year] ....)B...

Asheetbogo · 03-26-2023

hello @dbaumthank you so much for your prompt reply - i will test it out an be back if i need further help!

Asheetbogo · 01-17-2023

hello @Vishnu_Tiwari,unfortunately i had no time to test it out until now - maybe @WillowMobileSys can provide a video ...

Asheetbogo · 01-10-2023

Hi @Suvrutt_Gurjar,Hi @Aurelien,thank you very much for hint with "Valid_If" field - i have tested it out - it works perfekt!

My Stats

Mactdl's Bio

Badges Asheetbogo Earned

Recent Activity

vitual Column not showing up for selection in View

showing "historical" data of same table in a virtual column

alphabeticly sort items in REF-Dropdown

BUG: after syncing the app resulting "text" from expression "UPPER" is converted to "number"

AppSheet cuts off "leading spaces" when calculating "FIND" expression

Re: vitual Column not showing up for selection in View

Re: showing "historical" data of same table in a virtual column

Re: showing "historical" data of same table in a virtual column

Re: Rows Total / sub Total

Re: alphabeticly sort items in REF-Dropdown