About bmayers

bmayers · 01-25-2023

I have a table that we create a PM record on with a PM_Number (equals frequency) 7, 14, 28 day.From there the save event writes a record of it to the PM_Services there with a formula to calculate the Deadline_Date. From there PM_Services rows will ei...

bmayers · 01-20-2023

I have 3 tables i am building reports from. Work Orders PM OrdersPartsI have a column on the Reports table that is an Enum with 3 options Work Orders, PM Orders and Parts. The below select statement im working on to filter the selection down. I cant ...

bmayers · 06-24-2022

I am trying to set up a Downtime Tracker. I have a cell that changes from 0 to 1 this is changing based on a PLC sending info if the machine is running or not. O = machine is running1 = machine is stoppedI need a timer that when 0 changes to 1 there ...

bmayers · 03-22-2022

I have 3 Tables- Parts Database, Request Parts and user filterRef Between Parts Database and Request PartsCurrently using a dashboard view that uses useremail to filter the parts database to find a part and request it. added an action button to add n...

Slice: User Email Not working · 03-19-2022

I have used the useremail slice to filter a table with a dashboard view on 2 apps it works on 1 and not the other can someone please explain why this would be? What i mean by not working is when i go into the UX and make a Detail View of the Useremai...

bmayers · 01-26-2023

Thank you i will check out Looping with Actions see what i can get going. I know it be simple and the bots would work if i just used Uniqueid but then when the users tried to find the specific PM-Job they working on it would be a random code that wou...

bmayers · 01-22-2023

yes sorry it was a really simple solution. I was over looking a small piece all i needed to add was [report_type]="Work Orders" and [report_type]="Pm Orders" to make the select statement work depending on which report type was selected. Select(worder...

bmayers · 06-24-2022

Yes that would work. Thank you. To make the 1 minute delay i would need to have a third variable so like 0- running 1- down for less than a minute 2- Machine is down Now Start Time back to 0 stop time then get the elapsed time. I will give it a shot ...

bmayers · 04-18-2022

Its a detailed view with quick edit columns. its used to filter the data on the table.

Re: Slice: User Email Not working · 03-20-2022

It was so simple lol i had the email address wrong in the first row so i guess it prevented the view from showing anything i got it working thank you!

My Stats

bmayers's Bio

Badges bmayers Earned

Recent Activity

Appsheet API Help

Nested Select()

trigger an auto timer

Execute an action on a set of rows from a different table

Slice: User Email Not working

Re: Appsheet API Help

Re: Nested Select()

Re: trigger an auto timer

Re: Using a Table to fill data on a form

Re: Slice: User Email Not working