About james38

james38 · 05-09-2021

Hey All, I hope somebody can help me. I have a product list and each item has a [Replace By] date. Is there a way of displaying how many years are left in a numerical value? example years left “2” by subtracting current date [9/9/2026] - [Today] = 4 ...

james38 · 05-04-2021

Hey All, Im new to appsheet and I am working on an expression that I am probably making a huge mess of. I have a column called [CONDITION] which has an enum list 1-5 value I also have a column called [DATE] which is todays date I would like the user ...

james38 · 04-29-2021

Hey All, Very new to appsheet. I want to create an app that deducts 1 from an initial value each year. It’s to help us manage the state of our physical equipment. Do you have any ideas how this could be done? Totally green I’m afraid

james38 · 04-29-2021

Hey All, I am very new to appsheet and I am looking to add some automation to my app. I have managed to create a bot that emails a user when a record is updated. But really would like it to send an email when a particular field is changed Can somebod...

james38 · 05-13-2021

Thanks Suvrutt This is working beautifully now #topman

james38 · 05-09-2021

Thank you so much. It worked. Do you know how I can get the virtual column to update after the user syncs?

james38 · 05-05-2021

Steve you are a legend, works great

james38 · 04-30-2021

Hey @Dan_Bahir I have achieved the result I wanted thanks to you. in the email body I displayed: Asset <<[ASSET]>> location has been updated Item has moved From:<<[_THISROW_BEFORE].[LOCATION]>> To: <<[_THISROW_AFTER].[LOCATION]>> Thanks Buddy

james38 · 04-30-2021

My Stats

Mikkel's Bio

Badges james38 Earned

Recent Activity

Display Years left in signle digit

Year Expression

Annual Countdown

Field Automation

Re: Display Years left in signle digit

Re: Display Years left in signle digit

Re: Year Expression

Re: Field Automation

Re: Field Automation