About Charles2

Charles2 · 10-29-2019

Hi everyone, Somehow my data file has become corrupted and cannot be restored (it was only test data so no big deal) so I have to recreate the data file. I tried naming the file and all tables the same as before but my app doesn’t recognize them (pro...

Charles2 · 10-18-2019

This is not as easy as I figured… I have a mobile inventory app based on the sample from here. The Slice (MobileAppData) contains all relevant information that should be displayed in the mobile app. I have hidden all columns except for [Serial Number...

Charles2 · 10-17-2019

Hi everyone, I need a bit of help with the ux of my inventory app. On a mobile device, the user can scan a barcode for the product code (MPC; Mfg Product Code) and based on the value the fields group_(MGC; Model Group Code)_ and Description should be...

Charles2 · 10-14-2019

Hi, I’m new to Appsheet and am having trouble calculating a future date based on a given date and device type (e.g. If Notebook then decommission date is in-service date + 3.5 years (3yrs 6 months). I’ve tried several different possibilities but usua...

Charles2 · 10-21-2019

@Steve and @Kirk_Masden, Wow, I guess I shouldn’t work when I’m tired! =^0 I thought I explained everything clearly (at least on Friday it sounded clear). Second attempt: I am using a Slice because the table (StockList) contains more data than needs ...

Charles2 · 10-17-2019

Hi @Lynn, Thanks for the quick reply. The “Stock Management App” is the basis for my app but it doesn’t take the Barcode of the product and populate the other fields either. Maybe I should explain a bit more for clarity; The user scans the MPC of a d...

Charles2 · 10-15-2019

@Suvrutt_Gurjar, How embarrassing! I have been wasting your time simply because I forgot the brackets around the column name! Please excuse this. Next time I will check everything 10 times before I ask for help. Thank you so very much for your patien...

Charles2 · 10-15-2019

@Suvrutt_Gurjar as you can see here it makes no difference if the column is pre-filled - the second row - or empty. The strange date remains the same. Strangly enough if I give it an initial value expression of **EOMONTH(Today(),0) it calculates corr...

Charles2 · 10-15-2019

Good morning @Suvrutt_Gurjar (it’s morning here), That is the formula that I started with and the pics are from this morning after I re-entered the formula. Sorry about the incorrect column name (In Service Date)

My Stats

Charles2's Bio

Badges Charles2 Earned

Recent Activity

Corrupted Data File cannot be deleted from App

How do I search for a value in a Slice that has been scanned into the mobile app?

Filling a field depending on the (scanned) value in another

DateTime Calculations

Re: How do I search for a value in a Slice that has been scanned into the mobile app?

Re: Filling a field depending on the (scanned) value in another

Re: DateTime Calculations

Re: DateTime Calculations

Re: DateTime Calculations