ContributionsMost RecentMost LikesSolutionsRe: Critical Path in Project Management UP 👆👆 ------------------------------ Adam Krzyzanek ------------------------------ Re: Critical Path in Project Management To not create new topic. Anybody has idea how to mark task if on Critical Path for Project. ------------------------------ Adam Krzyzanek ------------------------------ Re: Date Field Help Am I understanding it correctly, that you want to have validation if date is in the future or not? You can use 3 separate technics: 1) Form Rules - if you capture input via form you can use form rules that if Date field is Greater than today show error + Block Saving 2) Formula field - You can create formula field which will validate if entered date is in the past. 3) You can use "Table --> Advance Settings --> Custom data rules" to block it in Form and in Grid Edit. ------------------------------ Adam Krzyzanek ------------------------------ Re: App Load Timeouts and app performance issues As far as I know this is about application size and how much GB it consume on "Estimated memory consumption". You can check it under: Home --> Settings --> App management --> Show app statistics --> Estimated memory consumption Also if app is connected to other app you will see different value in GB in field: Est. memory incl. dependent apps. I read somewhere that app will go to Sleep if it reaches size above 25 GB for memory consumption (But I have few long not used apps which are having same Loading screen and are below 20GB). Also you App will go asleep only if not used for 60 minutes (see here:https://helpv2.quickbase.com/hc/en-us/articles/16259648646292-Quickbase-June-2023-release-notes#:~:text=New%20application%20sleep%20time) ------------------------------ Adam Krzyzanek ------------------------------ Re: Approval with Mail reply to Quickbase Yes I know that I can use Mailto for this to construct What I find difficult to imagine is: 1) Where to send this mail (to which mail address as reply) - We use MS Office Outlook. 2) How Pipeline should reach for this mail with answer (should I use Search Email?) Any idea for such process?? How do you see that after I send mail it is add to "Table" where later Quickbasepull it by "Native Connected Table Sync" ------------------------------ Adam Krzyzanek ------------------------------ Approval with Mail reply to Quickbase Team, I am looking for solution where user can click button and approve request over mail. WHAT I WANT: I saw that in some services (like SNOW) you can click on the bottom, and it create "Reply" mail which you send from your mail client. Afterwards this mail it used to confirm in system required fields. Any idea how to achieve it with quickbase? DO NOT WANT: I do not want button to direct user to quickbase app as: 1) I cannot set it to EOTI 2) I do not want to share App Token it button URL 3) Do not want people to be directed to quickbase, as I used it before, and if they are not logged in, they will see XML error. ------------------------------ Adam Krzyzanek ------------------------------ Re: Use of Multi-Select List Formulas If you want to have it as "Multi-select List" field vs checkboxes, than why not to replace checkboxes into such field from very beginning? If you still want to keep check boxes and then move it to Multi-select List which is editable, you need to use Pipeline to copy your formula field into this new Multi-select List field. But then from process point of view, think what should happen next when user will use Multi-select List field and uncheck or check one of it. Should it interact with your check boxes? ------------------------------ Adam Krzyzanek ------------------------------ Re: Issues With New Forms Is your ZIP code treated as "Conditional values"? Is your Country set as Reference or Reference proxy field? Check if all fields required to make it work are available in the form. ------------------------------ Adam Krzyzanek ------------------------------ Re: Quickbase Gantt Plugin Tmeplate I believe you need to create Case for this. But 1 think which I notice is that on screen there is no task number 1. Maybe this is causing the problem. Is it available somewhere and not visible on screen or it was removed? If removed, maybe you can add it and check if Gantt will work. ------------------------------ Adam Krzyzanek ------------------------------ Re: How to select the first of multiple answers returned in a query. You can use formula Part. If result is formula query, then you may need to convert it first ToText. Example Code: //without Conversion Part([Correct Hauler Name],1,";") //with Conversion Part(ToText([Correct Hauler Name]),1,";") ------------------------------ Adam Krzyzanek ------------------------------