Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I'm writing a Python script and would like to add a user to a particular role in one of my apps. She is already provisioned in my company's realm, and I have her user ID number. I see that API_AddUserToRole exists and is well-documented, but I want to use RESTful APIs rather than XML. I see that there is a RESTful API for adding a user to a group, so I have to imagine there is something similar to add a user to a role in an app, but I can't find it. Any suggestions? In particular, I'd need the correct URL to POST to.------------------------------Aaron AlpertReliability Engineer, Mainspring Energy------------------------------
So I have a bunch of pipelines that are used to create records on my app. For each of my pipelines that create records, there is an html request that is used to transfer ownership based on the person who last modified the record which will always be the person who created the record in this case. Example: https://bpmp.quickbase.com/db/bq99vrcwx?a=API_ChangeRecordOwner&rid={{b.id}}&newowner={{a.last_modified_by.email}}&usertoken=************ Last night, a user created a record, but the record owner field pointed to my name. When I checked the activity of the pipeline, I went to the body of the response and it showed my name in last modified property of the object. And this was in the first step of the pipeline where a user triggers it by making a change. I wasn't even logged into the app the time the pipeline had run. Does this have to do with usertokens? Any help would be much appreciated. ------------------------------James Dalton------------------------------
Hello Everyone! Thanks in advance for any thoughts on this post! This is my first post here, so thanks in advance for any advice! My Problem. The clients whose application I am currently developing wants to be able to export data to CSV file in some areas of the application but does NOT want to let an end user have the ability to export all the data a report result may end up showing due to sensitivity of data, in this case sales data. Once the end user analysis sales data via the report's filter and groups, the client wants to limit the number of rows from the report to the first 50. So, I am hoping to get some feedback from the community on possible solutions to this problem. Some basic information about what I currently know. I understand how the native QuickBase export feature works and how this can be turned on and off for tables and roles. I also understand that there is a way to create a formula button that export data directly to a file locally. Furthermore, I have tried to com
I've recently started working on setting up a Quickbooks Online pipeline. I started with creating a vendor in Quickbase and then triggering an event to create the vendor in QBO. That worked just fine. Next, I'm trying to create a pipeline that will fetch the vendor and then create a bill under that vendor. When I try creating the pipeline, the fetching seems work just fine, but under the create bill section, it asks for me to manually put the vendor in pipeline itself. That means I would need to create a separate pipeline for every vendor, which makes no sense. Can anyone give me some guidance? I thought because of the lookup, it would basically know where to create the bill. UGH!------------------------------Lenny Brooks------------------------------
Anyone know why the last field in this formula fails to copy information (that's why I have it there twice). URLRoot() & "db/" & [_DBID_JOBS] & "?a=API_GenAddRecordForm&_fid_91="&URLEncode([Record Copy])&"&_fid_104="&URLEncode([Related Commercial Account])&"&_fid_31="&URLEncode ([Related Customer])&"&_fid_36="&URLEncode([Related Franchise])&"&_fid_95="&URLEncode("Reconstruction")&"&_fid_95="&URLEncode("Reconstruction")& "z=" & Rurl()------------------------------George Bramhall------------------------------
I'm importing a flat file of workorders into a staging table, then looking to load it into the production tables. The file has about 24 columns of parts that could be installed, with a count. Looks a bit like the below: DOORBELL CAMERA INDOOR CAMERA OUTDOOR CAMERA TAKEOVER MODULE DOOR/WINDOW SENSOR 1 2 1 1 2 I'm not using this data for inventory .. it's purely informational. Using pipelines - is there an easy way put all those columns into a single multi-line text block, separated into a list - skipping over the blank ones? EG -- that first record would like the below or similar: Doorbell Camera: 1 | Door / Window Sensor: 2 Thanks! ------------------------------Malcolm McDonald------------------------------
I am trying to set a field to [MyField] * .68 I tried this: {{a.MyField .68}} but that syntax wont even save. I also tried {{My.Field}}*.68. This saves, but produces an error when the pipeline runs. I know I could make a field in my Trigger table that does this calculation, but I would rather learn how to multiply in Jinja!------------------------------Mike Tamoush------------------------------
Hello Everyone, Need help on this as I am new to creating Quickbase apps and tables. I am currently working on a resource allocation table (summary table) report. I am able to summarize by the allocation percentage and show them by week. My issue is the graph only shows the start date week. How do i incorporate the end date as well so that overlapping weeks would have a value? ------------------------------Timothy Dumancas------------------------------
I'm having issues handling timezone alterations in Pipelines and would love some help. I currently have a form that allows a user to input a time in local time (we are blind to who that user is), select a timezone, and submit. What I would like is to convert that given local time with the timezone to UTC.My current approach is to take the time argument and add a time delta to account for the UTC conversion like so:Time received: 18:02 PSTTime - UTC: 2:02 UTC + 1In pipelines, that would mean:{{time_rec}} + time.delta(hours=({{time_rec}} - {{time_rec | timezone('America/Los Angeles')}} ))Or at least, I was hoping that this would work, since the application's time setting is UTC by default, so taking the differential between the given time and the timezone should provide the proper delta in hours. I would like to use Pipelines for this rather than a formula field to automatically account for Daylight savings time throughout the year and in multiple timezones. That would make the function:
Hello, I have an app (App Alpha) that has a table (Table A1). I have another app (App Bravo) that has a table (Table B1). Table A1 Table B1 I would like to move Table A1 to App Bravo. I have created a copy app and table to test this, but each time I get this error: My question: Is there a way to move or copy Table A1 from App Alpha, into App Bravo while maintaining or at least being able to fix the relationship without having to recreate the relationship? Any ideas or suggestions would be greatly appreciated. Thank you ------------------------------Shane Miller------------------------------
Every week, we need to send a report of confirmed reservations for the upcoming week to the relevant park manager. We have a lot of park managers. I have already created a report that shows all confirmed reservation records for the next ten days, which is then filtered further by park/superintendent. The real issue here is figuring out an easy way to click a button and send that report (since non user emails are not allowed as recipients in notification subscriptions) to all relevant emails. Further, the report looks like this: When the non-user recipient receives this open email notification, they can look at this report, but they lack the permissions to be able to view the records linked within this report (by clicking on one of the underlined numbers). Is there a way to, instead of sending this whole report to non users who are then unable to view the records linked within, send the actual records themselves that this report filters for, but in an automated way? Can't afford
Is there a way to tell how many versions of a file are in a file attachment field?I have another post describing a caching issue with browsers and rich text file link fields. I have discovered a work around but it would involve knowing the number of revisions uploaded to the file field. If I could count the number of revisions, or even check to see if the name of each revision 'exists', I can defeat the cache issue.------------------------------Michael Tamoush------------------------------
What would be the correct syntax to add to this formula to designate the dimensions of the popup window ? URLRoot() & "db/" & [_DBID_CONTACTS] & "?a=API_GenAddRecordForm&_fid_12=" & URLEncode ([Record ID# - Company])& "&z=" & Rurl()------------------------------Eric Fixler------------------------------
Any option to sort a Text list with words in alphabetical order? I need to sort something like this: BB;CC;AA;DD;EE;GG;FF to AA;BB;CC;DD;EE;FF;GG in a formula.I'm currently looking at using Part to break the list into individual elements then use Min to look for the elements and extract the first word, but then I need to recreate the list minus the word I already found, this need to happen for every word (max 20)I'm already in like 40 with no end in sightAm I on the right track? Any help will be appreciated.------------------------------Saar Litman------------------------------
Hello, I built an app that uses QuickBase form to allow users to provide different information about expiring licenses. In this form I'm also introducing various error messages that should explain which field values are wrong and why and also prevent the form from being saved. Form contains two date fields named Expiration Date and Reminder Date and I want to introduce field named Reminder Date Error Message, that will work as follows If Reminder Date is an earlier date ten Expiration Date it should be empty. If Reminder Date is empty and Expiration Date is filled in it should be empty. If Expiration Date is empty and Reminder Date is filled in it should be empty. If Reminder Date is date later then Expiration Date it should return message "Reminder Date is later then Expiration Date". Currently my formula looks like this If(IsNull([Reminder Date]) and IsNull([Expiration Date]),"",If([Reminder Date]<[Expiration Date],"",If([Reminder Date]>[Expiration Date],"Error- Reminder date i
I am trying to have a button in an email notification. The button is simply a link to the record, but there are reasons we want a nice pretty button vs a standard hyperlink. If I make a URL button, it passes into the email as a text hyperlink. If I make a rich text button (as seen in Kirk Tracys magic buttons), this comes really close to working. It will show a button that has the font size and color as the button in the app, but all the padding is gone. I tried adding blank lines above and below the text to 'trick' it into thinking it was larger, but that didn't work. I suspect it is something to do with how Outlook reads the button code. Anyone know the details on how Outlook processes the look of the button, and how to modify padding and other parameters that outlook will recognize?------------------------------Mike Tamoush------------------------------
Hi everyone, thanks in advance for help! I have a HR app that I maintain pay data in and one of the reports I generate is our bi-weekly payroll report so that our accounting team can process and verify payroll. Often we plan raises in advance and that is entered into our HR app but we do not want it to take place until that pay cycle. So I am making a summary field that takes the last entry in the compensation table (most recent pay) as long as the effective date is on or before the pay date. The challenge is how to know when my payment date is. I have formula field calculating this coming Friday with the following code: //Determine the Friday of this WeekLastDayOfWeek(Today()) + Days(-1) So that should work by giving me today's date of 02/24/2023 but we are bi-weekly on payroll. By chance today is a pay date so that works. But if we were in next week the next pay date would be 03/10 but the formula would return 3/3. How do I calculate that bi-weekly Friday date?----
Hello, I have 4 text fields that I want to combine the data to make a unique name/code that goes into the Unique Name Field, what's the best way to do this? I basically want whatever is listed in the 4 text fields to combine together into the Unique Name Field(currently formula field) Thanks.------------------------------Derek Pipal------------------------------
Hello, I have an agenda table (records with a date and holds the meeting details) and agenda items (child to the agenda table). I want to be able to "flag" agenda items and use a pipeline to add them to the "next meeting". The Agenda Item's parent would change and be added to the Agenda record that is flagged as "the next meeting". I am first trying to get a checkbox formula that would be dynamic based on the meeting date or days until the next meeting. The meeting frequency can change so I didn't want to use a formula like this: If([Meeting Date]>Today() and [Days Until Next Meeting]<=7,true,false); So, I am trying to figure out the right path. Is there a formula/query I can use in the pipeline that looks for the next date after today? Or a formula or query to check the box on the Agenda record to indicate it is the "next meeting". I have a "Days until next meeting" field that is calculating, (you guessed it) the days until t
Hello, Using the 64 bit Word doc template, attempting to either open an Exact Form from Quickbase or Save As to Quickbase, I receive the error message below. I am following this guide. If I purposefully enter an incorrect password, the resulting error message is a password error, so my credentials are correct. I have application creation permissions (am admin). Any thoughts on troubleshooting steps? ------------------------------Michael Rose------------------------------
Hi - I have a parent table connected to a child table. In the child table, I need to either Allow "More - Copy this record" and keep it associated with the same parent record OR prevent the "More - Copy this record" function completely I've read about not selecting Auto-fill - Copy the value when using "Copy this record" to add a new record so that users will basically add a blank record. But i actually don't want that to happen. Hope this makes sense. Thanks, Carrie------------------------------CARRIE IWASAKI------------------------------
Does anyone have experience using <table> to put Sections next to each other? I have you used this trick before, and it works well. But it seems that report links and Formula URL buttons mess up the formatting and sections overlap. Does anyone have experience with this or know how to combat the formatting issue when adding in report links?------------------------------Mike Tamoush------------------------------
Is there a way to add multiple child records from a parent table to a join table at one time and have them linked to both parents? I want the records created in the join to be linked to both parent tables, but I don't want to have to have individuals edit each individual record created and manually link to the other parent. Please note the following: The number of child records being added would not be static and would vary from entry to entry. Tags have relationships elsewhere in my build so it is not as simple creating the relationship of Batches have many Tags. The way I currently have it set up is there are two Parent Tables (Batches and Tags). These two tables are connected by a join table. The Tag table is pre-loaded with tags that each have a unique Tag ID, so the tags already exist. The tag IDs are sequential and unique. The action starts after a Batch in the Batch Table has been created, however it doesn't trigger immediately after creation. The actio
I want to queried all data from a table/report to save it into a local database. I've tried to export it into CSV format, however, got the problem as attached image. Please suggest ways to overcome it with: no filter applied one extracted data file only (like a svn dump file) I've read QB HTTP API and wonder if it can help to over come the "too large" issue?
Hello, I have tried every variation of this I can think of and can't get it to work. I have an app that is open to the public. When a record is added there, I have a report link field in my main application that displays the record that was added in the matching record. I would like the matching record in my main app to also highlight on the table tab so I can see that something was submitted without leaving my main app. My last attempt to do this was to turn on custom data rules and use this code If(Count([CRP]) > 0, "<span style='color:red'>" & [Bill of Lading Number] & "</span>", [Bill of Lading Number]) CRP is the name of the report link that displays in my main app showing me what was entered in my open app and the Bill of Lading Number is the field that links the submission from the open app to the corresponding record in my main app. I may be way over complicating this. Any thoughts? Thank you so much in advance. ------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.