Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello,I'm trying to connect our QB app to our team's SharePoint, but every time I try to connect it says "remote API returned authentication error: access token is empty."It doesn't take me to another page to log in to SharePoint or anything. What am I doing wrong?
We have UTF8 encoding on in our app for foreign language characters. I have a report that I need to export to populate HubSpot that we are integrating into Quickbase. When I export the file to CSV, the encoding is lost. I've looked at Excel help and saved the file as a CSV UTF8, but it doesn't correct the problem. Has anyone found a solution for this issue?
I need to use the Docusign action through Pipelines to upload a document for signature and have the actual signature tag auto-assign to the right spot in the document for each applicable signer but haven't been able to do so. I've tried every iteration of anchor tags that I can find in public forums and docs - but nothing gets picked up like I expect. When the document is upload - I can assign the actual signer but then they are prompted to drag the signature block onto the form and sign then. For the purpose of this question - I cannot use Templates so neither pipeline action for templates will suffice. I've tried Template Matching in Docusign but I'm not overly confident on the foolproof nature even if I could get it to work so likely not an option either. Essentially what are the options to upload an arbitrary document to Docusign and have the signers already mapped in the document?
In the new forms, if you have an embedded child table and click the add record button. It will "popup" the add record form without redirecting to a new page, or opening a new tab. Is there a way to make a formula url or formula rich text button do that?
I have a Projects table and a Tasks table. We would like to have a button inside the Projects record to be able to print a report from the Tasks table without actually showing the report itself on the project form.If we add the report to the page, and use the More / Print functionality everything works, but for several reasons we would rather not have to show this report on the form and just have the button do its magic. Is this even feasible or do we need to show the report and have the user use the More / Print functionality?
Would love to create a rich-text formula button on dashboard that will create a new record in LEAVE REQUESTS table where Related Faculty = User. Here's my try at a formula:var text facultyRecordID = ToText( GetFieldValues( GetRecords("{'[FACULTY EMAIL]'.EX.'" & UserToEmail(User()) & "'}", "FACULTY"), [Related FACULTY] ));var text ButtonWords = "New Leave Request";var text urlONE = URLRoot() & "db/" & [_DBID_LEAVE_REQUESTS] & "?a=API_GenAddRecordForm&_fid_15=" & $facultyRecordID& "&apptoken=$APPTOKEN";var text urlTWO = URLRoot() & "db/" & [_DBID_LEAVE_REQUESTS] & "?a=q&qid=11";var text url = $urlONE //& "&rdr=" & URLEncode($urlTWO);& "&NextURL=" & URLEncode($urlTWO );// Begin button stylevar text bgcolor = "#b71a1a";var text txtcolor = "white";var text style = "style=\"text-decoration: none; text-align: center; backgr
I have a Quickbase table where I track physician credentials. Since each physician can have multiple credentials, each physician has several rows in the table, depending on how many credentials they have. This structure is necessary due to the table relationships required for other functions in my app.However, I want to create a report that shows all the credentials (along with the renewal and approval dates fields) for each physician on a single line, instead of multiple rows. Is it possible to aggregate the credentials into one line per physician in a report?I'd really appreciate any help you can provide.
json_records_path:/systems { "id": 6816675, "url": "https://api.opensolar.com/api/orgs/146358/systems/6816675/", "name": "No value", "uuid": "F234D90E-E9E4-4F18-ADC9-89C0B9420385", "order": 0, "system_lifetime": 0, "inverter_range": "No value", "dc_optimizer_active": false, "dc_optimizer_efficiency": 1, "show_customer": true, "is_current": false, "auto_string": true, "discount": 0, "adders_per_system": 0, "adders_per_panel": 0, "adders_per_watt": 0, "kw_stc": 1.68, "battery_total_kwh": 19.6, "price_including_tax": 5862.5, "price_excluding_tax": 5862.5, "net_profit": 13797.04, "module_quantity": 5, "co2_tons_lifetime": 15.48, "project": "https://api.opensolar.com/api/orgs/146358/projects/5616041/", "org": "https://api.opensolar.com/api/orgs/146358/", "pricing_scheme": "https://api.opensolar.com/api/orgs/146358/pricing_schemes/27
I have inquired in the past and was told it at the time it could not be done but wanted to see if things changed. Is there a way I can use data in Quickbase to show up on a list in Fastfield? I would like to do customer inspections in Fastfield but the information in a dropdown for customer name to be fed from Quickbase. Thanks!
There is a Master Copy and the Master Copy has a multi select with the master SOP names. I have a document storage app which has a table named Manuals and a table named Supporting Documents. Each has a File Attachment field of the same name. Each Manual has multiple Supporting Documents. This is handled by a standard one to many relationship. I found out today that each Supporting Document could potentially ?support? multiple Manuals. This could be handled by simply uploading the Supporting Document file multiple times, each record being related to a different Manual. Due to storage space and modifications of files I do not want multiple Supporting Document records that contain the same file attachment. I tried to use a multi-select field in the Supporting Documents table that would check off the multiple Manuals, and through a report link field link the Supporting Document to the Manual records. This won?t work because there are over 250 Manual records, and the Multi-select c
Is it possible to create a form rule for a modal to display, and it include a clickable link?
I have three tables in QuickBase: Physicians, UT Advanced Privileges, and Physician Privileges.Physicians and UT Advanced Privileges are parent tables to the Physician Privileges table.The issue: In the Physician Privileges table, the fields are displaying as reference numbers instead of showing the actual physician and privilege names.How do I fix this to show the names instead?
OMG... is there any way to get rid of the collapsable side panel for the user role EOTI?The main problem is that it defaults in the expanded position. If the default was collapsed, not so bad. I'd rather see it disappear entirely for EOTI. This thing is such a pain for customer forms.Thank you, Chuck
I have a Pipeline "Pipeline Create" which adds an "Event" to a Google Calendar, when an entry is made in a QuickBase "Events" table. Yay.But I can't figure out how to update that Google Calendar entry when the Quickbase record is edited.The update step seems to want me to lookup an entry in the Google calendar and to specify an Event ID. But how to I set that Event ID in the "Pipeline Create" Pipeline which created the calendar entry?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------
Is it possible to do a wild search in regular table view?Let's say I want to search for pras* + eggsor egg + olivePrashant is my namePrashant eats eggs with butterPrashant goes for rock climbingPrashant makes eggs with olive oil------------------------------Prashant Maheshwari------------------------------
Greetings,I couldn't delete this post so, I am just completely modifying it, for anyone who navigated their way back to this and is thinking, "This isn't what I was looking for". lol I have two tables with completely different data. I want to create a third table which would be made up of the contents of each record in table1, duplicated for each record in table2, so I can add additional formulas, etc for a report.table1 structure Name -- StartDate -- FinishDate -- Amounttable2 structurePeriod -- BeginDate -- EndDateDesired mergerName -- StartDate -- FinishDate -- Amount -- Period -- BeginDate -- EndDate --...Example outputName1 -- StartDate -- FinishDate -- Amount -- Period1 -- BeginDate -- EndDate --...Name1 -- StartDate -- FinishDate -- Amount -- Period2 -- BeginDate -- EndDate --...Name1 -- StartDate -- FinishDate -- Amount -- Period3 -- BeginDate -- EndDate --...Name2 -- StartDate -- FinishDate -- Amount -- Period1 -- BeginDate -- EndDate --...Name2 --
Hey ladies! I hope you are all having a lovely start to your December. I wanted to reach out to formally update the group that we are not hosting any more events/meet ups through the rest of the year, and are looking to pick discussions back up in January.Please feel free to delete/reject the calendar invite for next week as we will not be hosting a session. Thank you all who have participated in getting this wonderful Qrew group started! We are very much looking forward to announcing our plans for 2025 and picking things back up in the new year. For now, I hope you all have a lovely and safe holiday season :)
So we are using the "Simple Project Manager" App to manage our projects now, and I've ran into a pipeline issue. I'm trying to link the status of one of my tables in a separate app to create a new task in a project for me.I feel like it should be set up correctly, however when I go to set a "Related Project", it only gives me options from the default data set in the project management app. Which at one point, the project management app prompted me to wipe? It doesn't show any of my projects, just the stock example ones.Any ideas for something I might be missing?
I went in and updated my records to make sure the field # of REQUEST DECISIONS APPROVED = 7 to try to trigger this pipeline but it didn't and I'm not sure why. Can anyone see what I'm missing? If there's other info needed to help understand, let me know.Kim------------------------------------------------------------------------------# NOTIFICATION REQUEST FULLY APPROVED## Account slugs:# - quickbase[qAyK4n7]: PIPELINES <None>---- META: name: NOTIFICATION REQUEST FULLY APPROVED enabled: true- TRIGGER quickbase[qAyK4n7] record on_update -> a: FILTERS: - AND: - of_request_decisions_approved equals 7 inputs-meta: export_fields: '"# LEAVE REQUESTS TOTAL, # of PENDING REQUESTS AA, # of PENDING REQUESTS ASSOC HEAD, # of PENDING REQUESTS DEPT HEAD, # of PENDING REQUESTS DIRECTOR, # of &n
I have a button that updates fields on the current record, but I also need it to populate the current date and time in the child record. How would I accomplish this?Thank you!
I have an App that is used by our external suppliers, I created a Home Page for each supplier and added supplier specific reports. In my admin role I can view the reports and the Home Page, however, in the supplier Role I cannot review the reports and thus the Home Page is blank. The report is available to Everyone, and every Role setting that I can think of is set to allow the supplier to view the appropriate table and reports. What am I overlooking?
I'm having trouble trying to build a report that only shows distinct dates for a given variable. Scenario: I have multiple entries with activity date ranges. If those multiple entries contain the same date(s), I only want to count each calendar date once, no matter how many entries there are that contain that date. Does anyone have advice on how to achieve this?
Does anyone know if there is a global app setting that will let me change the "From" on system generated emails to a specific user, rather than Notify@..., like we can do on notifications for specific tables?This is for the ad hoc type emails, upper right corner button of a form view.
Will renaming an App cause any issue ?
I have an App that is used by our external suppliers, I created a Home Page for each supplier and added supplier specific reports. In my admin role I can view the reports and the Home Page, however, in the supplier Role I cannot review the reports and thus the Home Page is blank. The report is available to Everyone, and every Role setting that I can think of is set to allow the supplier to view the appropriate table and reports. What am I overlooking?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.