Excellent and detailed explanation! How can I link documents in a SharePoint library to projects created in ClickUp? Any pointers on how or where to find guides to integrating a SharePoint library with ClickUp would be appreciated.
@peonykatara42375 күн бұрын
Hello, I am having a development store same as you I am seeing that you are able to process the POS orders using bogus gateway but in my POS it is showing error like - the order was not completed leave the checkout and try again and when I try another mode cash like, then it shows payment declined so can you please suggest something.
@SolvedSystems3 күн бұрын
Shopify won’t process cash payments on bogus gateway. I’ve put in a request for them to change this. Hasn’t happened yet
@just_illusion14 күн бұрын
Hey, I'm trying to retrive posted comments on every post on a specific Facebook page, I did verify the Api and callbackurl I subscribed feeds and everything is seems perfect, but when i post or add comments on the page nothing comes back to the trigger or it comes blank Any tips?
@SolvedSystems13 күн бұрын
It sounds like something isn’t verified or configured correctly.
@quelchenonvedi17 күн бұрын
Hi, this is very helpful! Quick one: what if I have 2 POS that must be linked to a specific Cutomer in BC? When using "Point of Sales" as Channel Name it won't understand which POS is related to. Any ideas? Thanks.
@SolvedSystems15 күн бұрын
If you imported the Shopify customers from BC, when the sales invoice gets created in bc it will take the customer location code if you are using that setup. You can also listen to the sales invoice table and set the customer location with power automate.
@quelchenonvedi15 күн бұрын
@@SolvedSystems the scenario is different: two Shops in two states (we are in Australia); each shop has its own POS which needs to be linked to an existing Customer in BC. EG: POS 1 = customer 123, POS 2 = customer 456. I managed to set up the two additional integrations as per your tutorial, but when using the channel name " Point of Sale", BC is not able to recognise which POS/customer it is and it integrates the orders against one of the two Customers, regardless. I tried to use the tag, which is one of the available filters provided in BC when synchronizing, but it doesn't seem to work.
@SolvedSystems15 күн бұрын
@@quelchenonvediyes correct. The POS isn’t fully integrated unfortunately this is Shopify and Microsoft’s fault. I’m about to solve this for another customer and can let you know how I do it. It’s possible but I haven’t started that part yet. Reach out if you need a consultation. [email protected]
@quelchenonvedi15 күн бұрын
@@SolvedSystems Thanks! i am currently testing it too, with Postman, to find suitable Fields to intercept the right POS. Will keep you posted. Cheers.
@SolvedSystems15 күн бұрын
@@quelchenonvedi you can intercept the order by firing a webhook then getting the location_ id, looking up the location with the Shopify location api endpoint then using that to update your sales invoice in BC before it’s posted. shopify.dev/docs/api/admin-rest/2024-04/resources/location shopify.dev/docs/api/admin-rest/2024-04/resources/order
@alghamdiaagАй бұрын
your voice quality is not quite good, i barely hear what you say
@SolvedSystemsАй бұрын
Turn up your audio. Just listened and it’s fine on my machine.
@davschmАй бұрын
Thank you very much for this video, i was going about this a different way and it worked for a year, but something changed and it stopped working. Your method does work for me now, and is cleaner and better than what i was doing before!
@SolvedSystemsАй бұрын
Thank you for the positive feedback. Let us know if you need any complex development
@pauloarruda8746Ай бұрын
I'm Brazilian and only here I was able to find what I needed to solve my problem, which by the way was an API connection with Whatsapp, thank you very much!!
@SolvedSystemsАй бұрын
Glad you got some good info to help
@ngllamedoАй бұрын
Hi, you describe how to use the API to update a comment passing the comment ID, but how do you know what Comment you want to update, when your are for example replicating a comment update in other system?. Lets say I previously create a comment coming from Jira and now I want to update this comment in Jira, and I see updated in ClickUp. As there are no custom fields in Comments, and I can't search for this additional field that can save the Jira Comment ID to look for later, I can't see how to achieve this. Thanks
@SolvedSystemsАй бұрын
First thought that comes to mind is comment is within a task, you could assign an id from jira to the task custom field, then get the comments from the task. I would need to look at the jira api to understand how this could be done, but think it could be done.
@ngllamedoАй бұрын
@@SolvedSystems hi thanks for your time in response my question. Yes what you are saying is true. I can search the task from an ID saved in a custom field. The problem is right here. If I have let's say five comments, each one has a Clickup ID, and in Jira I have five comments with a Jira ID. But I can't find the wright comment because I can't save for example the Jira ID of the comment. The only thing that comes to my mind is counting the number of comments that I have in both tools and update for example the comment number three ordering if necessary for creation time. Thanks
@MujtabaAdil-pc4woАй бұрын
Hello sir, this is Adil a junior Data Analyst. As I am working to integrate the ClickUp with the PowerBi. is it posssible to get multiple spaces and the time spend on each task within the spaces ?
@SolvedSystemsАй бұрын
Yes, it should be possible. You might need to bring this data into a blob storage for updating and do transformations in between. If you need help check out our services and reach out. We do a lot of clickup dev. www.solvedsystems.com/#contact www.solvedsystems.com/#package
@namayokiАй бұрын
Very helpful! I cannot find the next video referenced at the end of this video. What is it called?
@oliviatiwaladeadedokun29292 ай бұрын
This is really hard for me to understand as a total novice. What is Postman? What does it do?
@SolvedSystemsАй бұрын
This isn’t a novice video. This is a video for someone who wants to try and develop something with the clickup api and has prior knowledge of postman.
@oliviatiwaladeadedokun2929Ай бұрын
@@SolvedSystems Good to know.
@danielosorio2173 күн бұрын
@@SolvedSystems do you know of a good source/video to learn Postman? Thanks!
@SolvedSystems3 күн бұрын
@@danielosorio217 I don’t have a single video I suggest. You can search postman collections. There are many that are already setup. You’ll have to get an api key from whichever platform that the collection is setup for. This will enable you to understand the APIs quicker.
@RightUpYours2 ай бұрын
Come in 4 years later! I've been trying to figure out how to set stuff like this up for weeks now If I have techs around the country, and need the inventory sorted by location, how could I do that?
@SolvedSystems2 ай бұрын
You could give add a location field in your database. This would allow location filtering.
@RightUpYours2 ай бұрын
@@SolvedSystems I've been trying to make this work with forms for 3 weeks. I think this is my answer!
@johnathon30672 ай бұрын
I see there's similar comments regarding when changing barcode section from default.parent to the name of the barcode scanner..any updates on the issue? Ran into it also...
@SolvedSystems2 ай бұрын
You can put barcodescanner.value in the default field of the form field you are trying to fill in with the barcode value. I make the barcode scanner element clear and put a camera icon under it so it looks like the barcode scanner is the camera button.
@johnathon30672 ай бұрын
@SolvedSystems still not working, showing an error when putting name of barcode thats in the FooterContainer1 to the DataCardValue4 > default. Issue expected text value. This property on this control expects Text Values. The rule produces Control values which are incompatible. Location DataCardValue4 .Default Change rule to produce a (0) value. Thanks for helpings btw!
@SolvedSystems2 ай бұрын
@@johnathon3067 I would have to see what is going on to help further. Please fill out the contact form here for a consulting session www.solvedsystems.com/#contact
@niharikak24882 ай бұрын
Hello , I didnt understand Last submit. Can you help
@jeffhazelwood88652 ай бұрын
Would like to pick your brain on this. We're trying to accomplish this exact thing right now.
@SolvedSystems2 ай бұрын
Hi Jeff, I just shot you an email.
@AdamLundquist2 ай бұрын
This was so helpful!
@SolvedSystems2 ай бұрын
Thank you!
@PowerPlatformDev3 ай бұрын
cool! how to get the download link for the solution?
@SolvedSystems3 ай бұрын
Hi, I’ve pulled the code down because power apps has changed so much.
@jkunkoski41733 ай бұрын
does anyone have a reference for using authentication in the http call? Like from a .cer or just any way to pass the authentication from a .cer cert?
@SolvedSystems3 ай бұрын
If the .cer has a private key you may be able to create it in base64 and pass it in the authentication header. Without knowing what system your authing with it’s hard to tell what you need yo do.
@PeterPanQuails3 ай бұрын
Thank you . This tutorial explains clearly how to use webhook in Power Automate.
@mauricioetienne33793 ай бұрын
thank you very much for sharing this
@Solusign3 ай бұрын
Thanks for the video! Is there a way to duplicate the folder from a template? Or can you only create folder from scratch meaning that you need to map every single thing in Make?
@SolvedSystems3 ай бұрын
You would need to create then map all of your data. I’ve just recently done this for another customer.
@albertjohnmontalbo82804 ай бұрын
great content! was there a video for the power app barcode scanner using a webcam?
@SolvedSystems4 ай бұрын
The webcam is no longer supported.
@josephbrauer29924 ай бұрын
API integrations are new to me. We are paying for the Paylocity API and Paylocity indicated that the integration is simple and straight forward. So far, Paylicty hasn't been very helpful and we are no where closer to using it. At this point, I have been able to use postman to show the API works, but unable figure out how to pull anything. We want to use the Paylocity API to pull user titles, manager info, and employee IDs, and inject this info in Azure/AD. Where do we start? Do we use a service?
@SolvedSystems4 ай бұрын
I have a custom solution built in Microsoft azure logic apps or power automate that handles all of this. Please reach out to me here so we can setup a call. [email protected]
@josephwallis3396Ай бұрын
You aren't going to get any API help from them and you are going to pay for that privilege. Paylocity is the worst company for it integration and support I've ever seen.
@eduardocardenas28444 ай бұрын
If I have items with expiration date and lit number how can I match the info from the SharePoint list and keep track on dates?
@SolvedSystems4 ай бұрын
Use a formula for date comparison.
@user-lc3yj4ds6y5 ай бұрын
I would like to see a video where you can already have a list of inventory set up and be able to move your inventory to diffrent folder by scanning the item.
@SolvedSystems5 ай бұрын
Thanks for the request. We will put it in the lineup.
@puturro5 ай бұрын
how about setting the custom field values at the time you create the task?? the API says we can do it but it throws an error.... "bad request"
@SolvedSystems5 ай бұрын
It depends on the field type. If it’s something like a relationship field you’ll need to use the Set Custom field endpoint. I battled with this for awhile with a customer integration
@lizerbeams5 ай бұрын
Oh my word. I've been searching for this EXACT kind of tutorial for some time. Thank you so much!
@SolvedSystems5 ай бұрын
Thanks for the feedback!
@EminezArtus5 ай бұрын
Whats cost is involved to get access to the API?
@SolvedSystems5 ай бұрын
Now Paylocity is charging $2 per user per month which is crazy. This just went into effect. I have had another customer get access for free for being a long time customer. This isn’t guaranteed
@EduTech_TV5 ай бұрын
Nice, can i store the data in onedrive instead of SharePoint?
@SolvedSystems5 ай бұрын
I’m sure you could, potentially in excel, but excel doesn’t work well with power apps in my experience.
@angelineimendoza72006 ай бұрын
how to upload attachment in clickup customfield using api?
@SolvedSystems6 ай бұрын
I haven’t implemented that, but you should be able to do it the same as in the video but setting the custom field value.
@NeilMartin986 ай бұрын
Could this be linked to an SQL server too?
@SolvedSystems6 ай бұрын
Yes it can be linked to any data source. Please reach out if you need dev help. [email protected]
@eskildbrobak86486 ай бұрын
How did you emulate your own ihpone on your computer, any software that can be used for this?
@SolvedSystems6 ай бұрын
Reflector app for iOS is what I use
@fabioscarel8167 ай бұрын
Can you make a tutorial on how automate the changes for several tasks at once and how to do so based on the value of other fields? It would be a great addition for my team!
@SolvedSystems7 ай бұрын
Typically, this is custom development for customers. Please reach out if you’d like us to work on this automation for you.
@Borier7 ай бұрын
I enjoy watching your videos!
@SolvedSystems7 ай бұрын
Glad you like them!
@leandromanes7 ай бұрын
hi there! how do I get the value selected for a custom field that is a dropdown?
@SolvedSystems7 ай бұрын
In the json schema you’ll see a “value” of the selected option. This value is the order index of the option.
@most_unwanted_316i3 ай бұрын
And what db table is that option saved at? I am teying to join tasks with an options like table to get the option values feom the index value
@tomtebodakoloni32287 ай бұрын
Hittar ingen länk att ladda ner på?
@Akiramenai01057 ай бұрын
Не работает, когда BarcodeScanner отмечаешь, начинает выдавать ошибку "Ожидалось значение Text "
@SolvedSystems7 ай бұрын
KZfaq didn’t translate this. If you can respond in English, I can answer your question
@user-qe5qz8oe2t7 ай бұрын
Great vídeo. Thanks for sharing clickup api knowledge. Sorry for m lack of knowledge, but I dont understand the point of this, because I believe we can do this directly in the task, no? I mean, it seems to me that is possible to attach something directly into any task. Thanks again!
@SolvedSystems7 ай бұрын
You can attach anything to any task. However, to access the API and to integrate another system with clickup that doesn’t already have a connector, you will need to use the API. In order to get access to the API you need an API Token.
@AyaMohamed-op6xx7 ай бұрын
I did all steps you do but there is an error in default when I wrote Barcodescanner1 why 😢
@mannymorales79138 ай бұрын
What a great video, Jeff! It’s amazing how easy this is to implement. Thank you for producing and sharing!
@SolvedSystems8 ай бұрын
Thank you for the compliment.
@netsaishumbayaonda21818 ай бұрын
Can the app be used by multiple users? If yes, can the data from the different users be saved onto 1 sharepoint? Can it scan data without wifi or network and sync when network becomes available?
@SolvedSystems8 ай бұрын
Yes to all of those. You would need to get a collection of the items locally to check against, save the scanned into a collection, then submit when online. This could be done automatically. I haven’t done this with barcodes, but it is possible I believe.
@netsaishumbayaonda21818 ай бұрын
Can the app be used by multiple users? If yes, can the data from the different users be saved onto 1 sharepoint? Can it scan data without wifi or network and sync when network becomes available?
@SolvedSystems8 ай бұрын
Yes all of those things can be accomplished.
@monkimo9 ай бұрын
Do you have system for web cameras to monitor inventory on shelves and trigger re order before stock out?
@SolvedSystems9 ай бұрын
Yes, one could be built with Azure ML studio.
@SolvedSystems9 ай бұрын
If you want us to build this, reach out here for a consultation. [email protected]
@monkimo9 ай бұрын
Thanks Jeff@@SolvedSystems
@SYGRYDA13029 ай бұрын
Thank you for the video, very useful. I was wandering if it's possible to display the result of the assessment in the form right away? So add logic to the form: if at least one questions is answered yes (but still all questions must be completed), then the result is displayed instantly for the responder. If all the answers are no, then other result is displayed. Is this possible to achieve?
@SolvedSystems9 ай бұрын
Yes a dashboard could be built on top of the data with an embedded Power Bi dashboard or Power Apps charts. If you want us to build this, reach out here for a consultation. [email protected]
@user-ct9gp6ti4f9 ай бұрын
it works, thanks a lot
@SolvedSystems9 ай бұрын
Great!
@jeffreymenezes649311 ай бұрын
Formula at 9:03 throws out an error ("There is an error in this formula. Try revisingthe formulaand ruung it again"). how can I fix it?
@jeffreymenezes649311 ай бұрын
Hi, the fomula at 3:15 throws out an error, is it because this video is 3 years old and there have been updates?
@ZeNex74 Жыл бұрын
Tempted to try. I have my app built and can edit and save but if scanning it would be scan a desk then scan a pc. One after the other 500 times. Might get messy with app. At present we scan and auto adds to excel. Then I can save that to my app
@Andy-up1tt Жыл бұрын
This is great however how should i do the reverse, scanning the qr code/bar code to retrieve information about the inventory (data are all in a onedrive excel sheet)
@SolvedSystems Жыл бұрын
Scan the QR code into a filter or search function to lookup that value in your data source.
@Andy-up1tt Жыл бұрын
Perfect thank you so much
@boooney1 Жыл бұрын
Hi Jeff, your 2 videos on Paylocity APIs have been incredibly helpful. Thank you! I've been able to get an authentication token pretty easily in Postman. However I've spent hours trying to configure an HTTP request in a Logic App using exactly the same settings as Postman and am unable to get it to work. Keep getting 'unsupported_grant_type' Do you have any tips on how to configure the http request?
@SolvedSystems Жыл бұрын
Great to hear. Off the top of my head I can’t think of what the issue may be. There are the fields at the bottom of the request for authentication which are collapsed when you add that function. I’ve forgot to check them before and that has been my issue. I’m not sure that will the issue you’re looking at. Send sims screenshots to [email protected]