Hello all. I need to copy in the Table1[Customer number] the row number of row in Table2 which contains the same [ID] as Table1 have.In other words, I need to compare the [ID] of both tables and put in Table1 in cell [Customer number] the value of th...

How to replace the date "31.12.2024" with "31 any_word 2024" in Appsheet bot (set row values)? 12 - there can be any month from 1 to 12.

I have 2 tables ([Table1] and [Table2]). And I need to make a condition for bot event for table 1, provided that if in table 2 in the [Date] column in the last row [Date]=TODAY() and in the Table 1 in the column [ID]="123", then the condition is vali...

I need to remove from the value of [ID] ([just in case [ID]="A1-433434534") all the characters before the dash and the dash itself. The characters up to the dash can always be different (A1, B7, D72 etc). The result should be like this – "433434534"....