About Pcullc

Pcullc · 03-25-2022

I have a app that is based on automobiles. I have a column that users put their mileage in every time they get gas. I can't seem to figure out how to send out a notification every time the mileage column hits an increment of 5000.

Pcullc · 03-26-2020

I have 3 users on appsheet. We are using it has an expense reporting. When they put in an expense, and they pick the “Gas” category, I have it asking for the mileage on the vehicle. Now, what I need, is the ability to automatically calculate the mile...

Pcullc · 02-11-2020

I have built an app that records vehicle maintanance for our fleet. mileage is put in with every gas/repair expense recorded. I’ve been trying to figure out two things… First… What expression/action can I use if I wanted it to let me know when its ti...

Pcullc · 06-09-2019

I still dont know how I would do the user license because a contractor to take a job from me and not do another one… or they could do job after job… If they do one job and 35 days later open the app, then I will get charged for them I think… How woul...

Pcullc · 05-31-2019

I’ve been working on this app for days! I can’t figure out workflow rules to change status of both shipments and drivers… When a shipment is assigned to a driver I need the driver status to show busy and the shipment status to show in progress… And t...

Pcullc · 03-30-2022

I am forgetting the categories that are used for the expense tab. That has been forgotten the whole time. How would I add a column to that expression above? Expense[Mileage] And([Category]=Auto,[Category]=Oil Change .... ?

Pcullc · 03-28-2022

Not totally sure how I would get that table structure.

Pcullc · 03-27-2022

Finally got the floor(sum(expense[mileage]) / 5000) to work, but in the column it comes up with 24,317. Not sure what that was supposed to do, but I think it just divided... Is it maybe supposed to send a notification when it finally reaches 25? So i...

Pcullc · 03-27-2022

Here is what I have for the cumulative mileage column..MAX(SELECT(Expense[Mileage], and( ([Date] < [_THISROW].[Date]), ([Vehicle] = [_THISROW].[Vehicle]) ) ))This calculates the previous mileage for the user when they enter the gas fill up screen. Th...

Pcullc · 03-25-2022

Still can not get it to work.. floor(sum(mileage)/5000)). will not work..

My Stats

Pcullc's Bio

Badges Pcullc Earned

Recent Activity

Change status based on number increment..

Mileage calculations

Cell value based on numeric increments

How can I incorporate this app with contractors instead of full time employees?

So confused..!

Re: Change status based on number increment..

Re: Change status based on number increment..

Re: Change status based on number increment..

Re: Change status based on number increment..

Re: Change status based on number increment..