Відео

Thank you 🙏 very much appreciated

Difficult to trouble shoot here. Drop me a mail at my website and we can connect to take a look. chprojectsupportlimited.com

Excellent 👍 glad to hear that it helped 😃

Pretty sure I’ve done it with KTL. 🤔 I’m on vacation this week but will circle back.

I’ve not tested this specifically but I’m pretty sure it worked when I last needed to refresh a details view from a web hook response. You will need to be using KTL. Not found a reliable JavaScript method for this but aside from user KTL in all apps I’ve not been looking. The below is using KTL to refresh a view, specifically a details view on a header page rather than refreshing a table view. $(document).on('knack-form-submit.view_183', function(event, view, data) { commandURL = `hook.eu1.make.com/isr56h772kzud2y5oq8wifexk6k7cr1k?recordid=${data.id}`; $.get(commandURL, function(data, status){ ktl.views.refreshView('view_5'); }); });

Yes, they are case sensitive!Apologies if I didn’t make that clear.

Yep, regex and ChatGPT are great bedfellows 👍

Not that I know. 🤷‍♂️ Sorry, I’m not a Make guru 🤣

After some more research, it looks like you can convert the field (after import) but it displays a warning that requires you to tick a small box (that warns you existing data will be deleted) before you are given the option to save.

Agreed 👍

Thank you Gary, I really appreciate the positive feedback 🙏

Wow that would be cool 😎 I’m afraid I don’t have a solution for that use case. 😢

Copied from Normand’s GitHub explanation for Keywords. The keyword _hc (Hide Column) hides a grid’s column(s) based on the header’s exact text. The columns are only hidden but as you state, still exist in DOM (Document Object Model). You could use _rc ( Remove Column). This will delete them from the table and the DOM. Using _hc to remove a column will maintain API calls capability and allow filtering on its field. _rc is “somewhat” more secure than _hc since it’s not as easy to peek at data from the browser’s console. Though someone could intercept the data before it’s been removed, i.e. while it’s being sent by the server. Both options have their uses. You can read more under the keywords section on GitHub. github.com/cortexrd/Knack-Toolkit-Library/wiki/Keywords#keywords-list

@@chprojectsupport thank you for the detailed explanation, this will come in handy for sure.

Hi 👋 the link is in the video description 👍 github.com/cortexrd/Knack-Toolkit-Library

I’ve not had experience in adding a digital signature, if you mean one that tracks the IP address of the person signing and act as a legally binding signature. Obviously there is a signature image field in Knack but I presume you don’t mean that? If you could provide some more detail there may be others I can ask on your behalf.

Hi Jordan 👋 Thank you for your comment. I just realised that I hadn’t put a link to the JavaScript in the video description. I’ve just updated it with a point 3, which is a link to a Dropbox text file. Without seeing your code it may be that there is a minor error or there is something else in the JavaScript panel that is stopping it from running. I’d recommend using the link to copy the code replacing the view id. Happy to connect if you can’t get it to work. I’ve been using the code for several years.

@@chprojectsupport ah, the linked code is slightly different than the screenshot in the video. Now it works, but it seems to be almost instantaneous, despite how many milliseconds I change it to (5000 vs 50000 vs 500000 acts the same) and therefore renders the Search by Keyword box useless since it clears it out within a second or two :/ Thank you so much for your help!

@@jordandotson6730 - I'm so sorry, I just checked an I managed to put the wrong code in the Dropbox link. I'm surprised you got it to work at all. If you use the link again you will see that I was missing the line that actually fetches the view. You just need to replace the view ID in two places. I tried it with 5 sec and 10 sec and it works as expected. That's always one of the issues with code, its so easy to get it wrong 😉 - Using the auto refresh keyword with KTL is a lot easier. Let me know how it goes?

@@chprojectsupport Yes! It works now! Thank you!

@@jordandotson6730 - Awesome, its a handy snippet when you get given the right code!! 😂

Hi Leah, I really appreciate your feedback. Since I did the video I have found another way to invite users without having to send them the password. 🤩 I’ve not got around to doing a video for it yet but if you’re interested please let me know. I’d be happy to connect and walk you through it. 👍

There are almost endless possibilities combining the power of Knack and KTL. 🚀 I’ve only just started my KTL journey and learning new things all the time. I appreciate I’m probably preaching to the converted, but hopefully it may enlighten others to the possibilities 👍

It certainly simplifies the process of building. Hopefully one day these features will be standard in Knack. Until then I’m incredibly thankful to Normand 🙏

Before KTL, I would set the table to hide empty columns and then force that column (with a "hide value" display rule) to be empty. KTL is so much more elegant. The native method (hack??) hides columns you are not targeting, that just happen to be empty.

Being able to hide columns that “do” have a value, and by user role is a game changer for me 😊

@@chprojectsupport Especially by User Role. That really has changed the way I do things. I was using scene (page) based rules to hide duplicate tables like in your example... The maintenance on those across complex application is killer.

Thanks 🤩

Thanks David, I appreciate your encouraging comments. The video was originally 1 hour 45 mins. It took me a while evening to edit it down to something more concise. Not my typical length video but I thought some may find it interesting 🤔 I’ll certainly be doing more KTL videos, there are so many great keywords to go through.

Woohoo 🥳

Hey Dave, how ironic that we were doing the same subject. Feel free to link this variation in your video if you feel it would be useful to others 👍

Actually, I just finished the code to support inline editing last night! It will be in next release, probably later today.

I’ll be doing an in-depth walkthrough in the next few days. Make sure you’re subscribed 👍

Thank you for the feedback

The Accounts object and User Roles can be confusing 🫤 Data doesn’t copy between the objects. I’d recommend only having the additional fields in the Accounts object and avoid, if possible adding custom fields to user roles. Happy to connect if you want to walk through it.

Hi Matthew, thanks for the feedback. I’m glad to hear that it’s making a difference 👍

Yes, he is a genius, it is official!

I appreciate your comments, it’s all about trying to help people build better applications

Oops, I’ll circle back on the next video and correct that error. Just goes to show that I’m still learning 😆

Thanks for the info! I saw this and will do a follow up video diving a bit deeper. 🚀

Yes, something I need to be more familiar with and learn how to do, with your help, as always 👍

KTL and Make.com are powerful tools that will help you immensely as you progress with your Knack journey. Obviously, I’m very bias, but Knack is an amazing platform. Like most complex solutions, there is a learning curve, but it’s worth persisting. I’m fully engaged in client work through most of the year but I do offer 1 on 1 tutoring, if you’re interested. I’d you’ve not signed up for a Knack plan yet I offer free / discounted rates if you use my Knack affiliate link as I get a generous kickback 🆓 www.chprojectsupportlimited.com/

Thank you for the positive feedback. I have only recently started to use KTL, which I hope I made obvious in the video narration 😆 So far, I’ve found it invaluable in being able to add some great functions to help me build better apps. I’ve only scratched the surface, but I wanted to share my journey so far and encourage others to explore. 🚀

Normand truly is amazing and it’s great to hear how much KTL has improved your daily workflows.

You are welcome! 🙏

Not that I know of, sorry but I’ve not managed to get images or signatures into the Word Template.

@@chprojectsupport Did you ever figure out a way todo this Carl?

Thanks Callum. I appreciate your positive feedback. I’ve also been looking at Documint. However, my process only requires a fairly inexpensive PDF conversion tool and a Microsoft Word template. I’ve used it many times with lots of clients and it seems to work quite well.👍

@@chprojectsupport No worries. Also, this solution in this series is so much better than documerge or whatever it's called these days which I see lots of people get sucked into. it works but is SO expensive!

Happy to connect on Zoom to see if I can help. Not sure I can throw any light on “text formatting” but it may be worth a chat. Contact me at : carlholmeschps@gmail.com

Thank you for your positive feedback 🙏

Thank you for your reply. I appreciate that the video series stopped at number 11 🤣 I recorded these July 2023 and have been busy doing client work since and not had time to finish. I’m aware that Knack are working on a new builder environment, as I’m part of the user testing program, so I wanted to get this released while the layout was still valid. The building principles will remain the same, as will the core functionality, just the interface will change slightly.

@@chprojectsupport Yeah, I'm pretty excited for the updated Builder Environment. I just didn't want anyone to think that Grid view would only be for directors the way it was shown configured. Viewers should watch the whole series and keep an eye out for how to Filter the SOURCE data. That will help them in a pinch.

Glad it helped! 👍

Yes, you can toggle headers on or off under the print manager dialogue

I think you found the answer 😉

I think you found the answer 😉

It’s simply an empty edit form that is used to trigger the JavaScript webhook to Make.

You're very welcome! 😊 It’s a little complicated but it helps ensure you have a well maintained data set 👍

Thank you for the inspiration and additional code. As a non coder I appreciate you sharing. I notice that you have to specify a field number in your code. If you use the below it will work with any file or image field. /* Target all file upload fields with hover over */ input[type=file]:hover { background-color:#c1e1ec; transform: scale(1.02); }

Glad to help - it’s a handy feature. I often connect objects to themselves so you can insert new items with record rules. 👍