ContributionsMost RecentMost LikesSolutionsRe: Displaying Formula - Text Field on a Code PageI see - so the issue is that we can pull in a record ID# for any record in your table, but we'd need to know how to target it. When a user opens the link, how do we know what record ID# should be displayed? Is it just the next record ID# available or something like that? ------------------------------ Christine Suarez ------------------------------ Re: Displaying Formula - Text Field on a Code PageAnother question for you - how are your users getting to this custom form/code page? Are they coming from a link on the form of the record itself? I'm trying to work out how we're going to know which Record ID# to pull in with the API call. ------------------------------ Christine Suarez ------------------------------ Re: Displaying Formula - Text Field on a Code PageMakes perfect sense - I'll post a snippet in the morning that you can dump into your page. We can work through the rest of need be. ------------------------------ Christine Suarez ------------------------------ Re: Displaying Formula - Text Field on a Code PageIf you're on a code page, you can't pull in a formula text field like you would on a form, but you can query for its value with javascript via the API (either the XML or REST if you happen to have a preference). If you're comfortable with that, I can post a code snippet up here to show you how to do it. ------------------------------ Christine Suarez ------------------------------ Re: Issue with Report Filters Not Functioning ProperlyJust so we're on the same page - you have a single table called "Evaluations Settings," right? I assume that's where you store each Evaluation record (regardless of type)? And you've created 18 different variables (which I'm assuming you're actually referring to fields in the table) for each type of evaluation, each with a corresponding default value. Referring to this part in your last response: "Eval_Type_HealthProf contains Health Professional QA". Which is impossible because that variable does not exist in the "RCDP" evaluation." This is what I was getting at - your "RCDP" evaluation does in fact have a "Eval_Type_HealthProf" variable (I think what you mean is field here). Your "RCDP" has a value for every variable (field) you created. Every time you create a field, it exists for all records you create in your evaluations table. Does that help? Happy to try to show you in another way. Try this: create a new report and include all of the fields you refer to as variables in it. I'd every record/evaluation, regardless of what type you intended them to be, will have a default value in every field. ------------------------------ Christine Suarez ------------------------------ Re: Issue with Report Filters Not Functioning ProperlyI probably should have led with this instead. So, every evaluation is going to have a value for all the "hidden variable" fields you created. For instance, when you create evaluation #2, Eval_Type_HealthProf will always contain the default value of "Health/Professional QA" regardless of the type of eval it actually is. In other words, every record you create with that setup with all contain all the default values for all the hidden variable fields, so they're all going to show up on every report. Hope that makes sense. ------------------------------ Christine Suarez ------------------------------ Re: Issue with Report Filters Not Functioning ProperlyOut of curiosity, if you put your hidden variable fields directly in the reports, do the fields appear to actually contain the values? ------------------------------ Christine Suarez ------------------------------ Creating CSV with Pipelines/Paginating with REST APIHi all, I want to first note that I've seen the really excellent explanations by Sharon Faust (QuickBase Junkie), Scott Galloway, and what's on QB University for doing something similar (but less complex, I guess) to what I'm about to describe. I'll link to those at the end in case anyone stumbling upon this could benefit from those. Ultimately what I'm trying to do is use the Audit API to generate a CSV file and drop it into a third party cloud storage location. Most of the individual pieces of this are in place. I can pull data from the Audit API. I can generate a CSV by pushing query results into a Bucket channel pipeline table (if it doesn't require pagination, which is the big issue – more on that in a minute). I can then use the "Download CSV" step to grab a download URL for the CSV. I can then use the "Fetch CSV" step to grab the CSV data, which I then send to the third party cloud service with a "Make Request" step. The problem for me is that the Audit Log generates tens of thousands of rows per day, so I'll need to paginate through it and build out the CSV file. I can do that with callable pipelines. The problem is that the only generation of CSV data can happen within a Pipeline Bucket channel table (not to be confused with the other table under the Bucket channel that doesn't have a CSV step – see attached picture for reference). I don't see a way to reference the Bucket channel table with each iteration of the callable pipeline so that I can continue to build out the table until it's filled with all the rows from my original Audit query. I feel like I'm missing something obvious here, but I have hit a wall. If I happen to figure out anything on my own, I'll be sure to post here. Just hoping someone else has dealt with this and can nudge me in the right direction. For reference: QuickBase Junkie's "How to use Pipelines to email a CSV file in Quick Base" - https://www.youtube.com/watch?v=gra6zBkeg0g QB University's "Archive data with the Bucket channel" - https://university.quickbase.com/build-powerful-pipelines-using-included-features/647381 Scott Galloway's Empower Session "API Pagination with Callable Pipelines with Scott Galloway" - https://university.quickbase.com/empower-2021/849480 Thanks so much in advance for your time! Christine ------------------------------ Christine Suarez ------------------------------ Re: Pipelines - Create a csv fileHi Evan, I just wanted to bring some attention back to George's original post. Any insight on how Pipelines might be capable of doing this? I've tried to see if I could get a hold of .csv data by using an API_GenResultsTable call with the csv option in the URL, but that triggers an XML error during the pipeline run. It seems like there are built-in tools to handle the consumption of cvs data well, but not the creation and transportion of csv data. You seemed to indicate it might be possible in your response to George, so I figured I'd follow up. Thank you!! ------------------------------ Christine Suarez ------------------------------ Re: Pipelines - Create a csv fileCurious if any kind of solution was ever figured out for this... ------------------------------ Christine Suarez ------------------------------