ContributionsMost RecentMost LikesSolutionsRe: POST API call returning 404 error Yes, I testing it in the API Portal. Just a few minutes ago I was able to get it working using Postman. That gave me some insight into how the URL should be constructed. So I made some updates in the code and now it's working. I was just about at my wit's end with this project, but now the doors open. On to the next hurdle! ------------------------------ Barry Dolan ------------------------------ POST API call returning 404 error I'm hoping there's something simple I'm missing here. I'm building an app to eventually have users update a record. I'm a newbie when it comes to this, so I have low confidence even in the questions I'm asking. I'm using Ionic Framework to build an Angular app. The issue is this; when I click a button on the app I want to send a payload, in this case it's updating one field with some text, just as a test to get it working. I feel like I'm knocking at the door but it's not opening. When I use API Documentation and test the POST request it works perfectly and I'm able to update the targeted field. But when I trigger the request on the app all I get is error 404: Not Found. I'll be happy to share the code, but first I'd be interested if someone is willing to examine it to see if there's a simple fix that will work, or if it's something that is going to require many programming hours and a hefty fee. If the later is the case then this may not be the correct forum to work this issue out. If interested please let me know what you need to see first. I'd greatly appreciate any assistance. Thank you. ------------------------------ Barry Dolan ------------------------------ Re: Button click to populate a field with the current time I will reconfigure and give it a go. I'm not sure what you mean by your last sentence. But your mod to the syntax makes complete sense. Thanks, Mark Happy New Year! ------------------------------ Barry Dolan ------------------------------ Button click to populate a field with the current time I'm using a formula URL button to input the current time in a "Clock-in" field. I have another formula URL button to input the current time in a "Clock-out" field. It works, and we have the employees use the mobile app to clock in/out each workday. The issue we are having is that if the employee doesn't close out the app after clocking in, when they clock out, it will input the same time from when they clocked in. Does anyone know how I would modify this code so it will capture the current time, every time, no matter if the app has been closed or not? URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=MYAPPTOKEN" & "&rid=" & [Record ID#] & "&_fid_433=" & ToTimeOfDay(Now()) & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#])) ------------------------------ Barry Dolan ------------------------------ Re: Hide import/export GUI Interestingly enough, it gets even better; One of the duties I have for a user is to import a CSV file into a table. Giving the role access to do this, they also have access to edit the app structure and permissions, which is risky, given the role is not admin. I can turn off access to specific table settings, or restrict it globally, but if they need access to specific tables to do this they also have access to all the table settings, and the app structure and permissions. I can't make import/export show on the menu without also letting them access the settings. This doesn't seem right, and if I'm missing something, hopefully someone can provide some insight. Is import/export only an Admin function? That doesn't seem right either. How can we give access for importing a CSV file to a table without giving access to the entire app settings. Thank you in advance, ------------------------------ Barry Dolan ------------------------------ Re: Changing native Save button's redirect behavior I've had similiar issues, and I've found the solution that works best for me in the community. My solution was to hide the native buttons. In the form properties you can select to show the Save & Close button on the bottom of the form. And I inserted this at the end of my URL: & "&ifv=1" to hide the top bar and native Save&Close. And I use a custom button to save and return the user from whence they came. ------------------------------ Barry Dolan ------------------------------ Re: CODE DUMP: Making your Exact Forms look Amazing! Wow! This is awesome. A few weeks ago I tackled my first Exact Form. It was indeed a bit of a chore, and you're absolutely right about getting the basic design done in Word first or you'll be retracing your steps every time it's uploaded. It took me a couple of times before I figured that one out. I'm a newbie in HTML and it took me a lot of time to figure out how to adjust the styles and formatting. But the finished product is great, just like using Mail Merge only better. It works so much better than trying to develop a form with all the fields positioned in such a way to make it look good, which is practically impossible. Thanks so much for our contribution, I'm bookmarking this for future reference. ------------------------------ Barry Dolan IntelliBridge Technology Inc Federal Way WA 206-551-7022 ------------------------------ Re: New Forms Report Link Not Filtering Records Like Old Forms When adding a new field select "Report". It functions like adding a report to the new dashboard. ------------------------------ Barry Dolan ------------------------------ Re: UTF-8 in Gmail Channel My issue is with attachments as well, but it's not that I want to send one. The Gmail channel makes the Attachments URL a required field for some reason. Would love to turn this off, if anyone has experienced it. In case you never figured out the ASCII issue, using HTML in the body solves this. I use this to send an email to an address from an email field on my table and use markup around the field placeholder in the body. <p>Dear {{a.requester}},</p> <p><b>Ticket:</b>{{a.task}}</p> <p><b>Definition:</b></p> <p>{{a.definition}}</p> <p>----------------------------------------------------------</p> <p><b>Solution:</b></p> <p>{{a.solution}}</p> <p>Thank you,</p> ------------------------------ Barry Dolan ------------------------------ Re: Gmail Pipeline Hi Damien, I just recently connected to the Gmail channel and have it working to my expectations. But not without some issues along the way. If you have it figured out by now, you can ignore this, but maybe someone else will find it helpful. My issue was with the Gmail Connector. Their help documentation didn't really spell it out clearly and I ended up starting a support case to get this resolved. During that process I requested that they update their help documentation, and they have. Here's a link to STEP 4 of Gmail connector that may be useful: https://helpv2.quickbase.com/hc/en-us/articles/9713253054484-Setting-up-a-Quickbase-Pipelines-Gmail-connector#:~:text=Step%204.%20Navigate%20to%20Manage%20Third%2DParty%20App%20Access ------------------------------ Barry Dolan ------------------------------