About SKETCHwade

SKETCHwade · 01-17-2024

Can anyone please help me speed up this Expression?I need to search the data for the last entry of the matching location:INDEX(ORDERBY(FILTER(Toolbox,[Site]=[_THISROW].[Site]),[TimeStamp],TRUE),1)I usually use maxrow() which is much faster, but in th...

SKETCHwade · 01-17-2024

Hi all,I would like to speed up my app.I have old data sources that are no longer in use (along with their respective views and actions).I could delete them but I may want to reenable them in the future. Is it possible to temporarily disable them. Or...

SKETCHwade · 07-17-2023

Hello,Is there a way to allow more "display as primary" actions?I seem to be limited to only 4.The app is used on large tablets so What looks to be a mess in the app preview is not so bad in reality.

SKETCHwade · 05-25-2023

Hi all,I have a table with one entry for each Job.There are two other tables, Labour and Parts.Labour and Parts could have many rows relating back to Job 1 for example.I would like to copy Job 1 and copy all of its related labour and parts rows.(I wo...

SKETCHwade · 04-16-2023

Hi all,Not sure where to report bugs these days?I have a virtual column using an app formula, the type is list and element type is LongText.In Detail view the long text works as expected. In form view it is displayed like a non editable text column. ...

SKETCHwade · 05-25-2023

Hi @HBT I have followed this tutorial but I am stuck on action 05. Action 05 asks you to add action 04 to the referenced action list. It doesnt show up because action 05 is in the Parent Table and so is action 04. What have I missed here?

SKETCHwade · 04-16-2023

You're right, I meant all tasks for this job not all jobs.I didn't necessarily see errors, I was just seeing a huge list of jobs and the couple I went through had no tasks so had to sort that out first.Thank you for your update I have incorporated it...

SKETCHwade · 04-16-2023

Hey @Suvrutt_Gurjar Thank you!This expression actually works the same way every other one I have tried does. Its checking the Tasks individually but I need it to check all of the Jobs Tasks and if they are all complete then its true if any are not co...

SKETCHwade · 04-16-2023

I do realise I could incorporate this so I dont have a VC but considering im struggling so much I figure it simplifies the expression for now.

SKETCHwade · 04-16-2023

This is the VC in the Tasks tableAND([Completed?]=TRUE,OR([Completed?2]=TRUE,ISBLANK([Allocated To2])))

My Stats

ramesh1600's Bio

Badges SKETCHwade Earned

Recent Activity

Improve this Expression?

Speed up app load time

More Primary displayed actions

Copy and set values on this row and all of its Related rows

App Formula Long Text bug

Re: Step-by-step parent child copying method.

Re: Row Filter reference two tables

Re: Row Filter reference two tables

Re: Row Filter reference two tables

Re: Row Filter reference two tables

SKETCHwade's Ideas (2)