Recent Discussions
Unable to insert a row in Sharepoint List
Friends, I have a SharePoint list with book data. I have built a pipeline in quickbase that will insert a new row in the list whenever a new record is created in quickbase I have created the connection to my SharePoint list correctly. It identifies the site and the list. But the pipeline is unable to add a record in Sharepoint. I keep getting these errors consistently. What am I doing wrong? I am new to Sharepoint integration with Quickbase. Please help.
How Can we hide or disable Native Save&Close, save&New and Cancel Buttons in Mobile App
I team... I am really frustrated because I haven't found the way to hide the Native Save Buttons In Mobile App. Is there an easy way to do it? I normally use ifv=1 but it doesn't work in Mobile App. Please help because the Buttons are causing a lot of issues. Thank you! ------------------------------ David Rascon ------------------------------
Is there a way to "Pause" an app
We intercompany charges for Quickbase app usage and I have been asked if there is a way to suspend or pause an app while this intercompany charge is resolved. This app has like 225 users and about 50 roles. I really don't want to go user by user or even by role. I totally do not want to delete the app. Any ideas would be appreciated.
Generate a number
Hello I would like to make a unit number self generate Example 1000-(001,002,003) as more records are created.. is there a way to do this function? where it will generate the unit number based off the last record? Im a still pretty new to QB. Do I need to make the first record from there then ref that field in the max ID and add +1 to it?
Need help with a query formula for ranking dates.
I have a table of Training cycle start dates. Each record is a Training Start Date (FID 6 - Date Field) for a Training Team (FID 25 - Text lookup field from related Table) with a Start Date Status (FID 7 - Text). I have created a Formula Numeric field titled Rank. I need to rank the upcoming Training Start Dates for the Traditional team only, and exclude any dates that are past or do not have a Status of "Available." The one coming up soonest on/after today ranked 1, next ranked 2, and so on. We've tried several formulas without success. var text QUERY = "{6.AF.'" & Today() &"';}AND{25.EX.'Traditional'}AND{7.EX.'Available'}"; If([Start Date Status]<>"Available", null, Size(GetRecords($QUERY))+1) Attempt 1 above failed. Returned rank 11 for all available start dates, past and present. var number position = Size(GetRecords("{6.AF.'"& Today() &"'}AND{25.EX.'Traditional'}AND{7.EX.'Available'}")), $position+1 Attempt 2 above failed. Returned rank 10 for all available start dates, past and present. var text baseQ = "{25.EX.'Traditional'}AND{7.EX.'Available'}"; var text QAfter = $baseQ; var number position = Size(GetRecords("{6.AF.[Training Start Date]}AND{25.EX.'Available'}")); $position+1 Attempt 3 above failed. Returned rank 1 for all dates.
Issue with Dashboard Gauge: New Style vs Old Style
Hello Quickbase peeps! So I ran into some challenges with the KPI Gauge widget. The KPI Gauge shows the correct percentage when creating it in 'Reports & charts' but the problem arises when I add the widget to dashboards; it shows 0%. After some troubleshooting, I've discovered that while previewing the KPI, it works just fine until you turn off 'New style'. Please see attached pics. Not sure if this is a bug or if there's any workaround/fixes for this. *Calculation is using summary formulas Thanks!
