Recent Discussions
syntax help with formula
I am making a formula and I am having trouble with syntax I want the statement to say If([Sale]="Yes", than show [Manifest Price] but if ([sale]="cancelled" show 0.00) I need the syntax for "than show" "and but if" Edit I got some of that formula to work If([Sale]="yes",[Manifest price w/o iva],([Sale]="Cancel"),(0)) all it give me is the Cancel ones at 0 The manifest price one is blank0likes0CommentsChild Table - Grid Edit Issues
On the old style forms, I could show child records and say "allow edit". Then, when I clicked edit on the parent, it opened the child record grid edit table for me to add many new records. They all carried down and created a parent relationship. In the new forms, it doesn't do that. I can hit Grid Edit and it pops up a new window which lets me add records, but the parent relationship isn't auto created. I'd have to go carry down that field. Both the pop out and needing to carry down that relationship are a huge pain. Is there a work around?0likes0CommentsDocument Template creation - Save PDF to field in record
Hi, I basically imported the following YAML. And everything is looking ok until it comes to the Body of the “Save File to a Table” Where I am getting a “This field contains invalid jinja references” error. Thank you so much for helping! Below is the Body (image also below): { "to": "bts4ydgrs", "data": [ { "340": { "value": { "fileName": "{{a.json.fileName}}", "data": "{{a.json.data}}" } } } ], "fieldsToReturn": [] } } } ] } "fieldsToReturn": [] } The Below is the YAML I imported: # Doc Gen Testing # # Account slugs: # - quickbase[CHANGE ME]: Realm Default Account <None> # - microsoft-outlook[CHANGE ME]: # <None> --- - META: name: Doc Gen Testing - ACTION quickbase[CHANGE ME] quickbase_api make -> a: inputs: method: GET url: https://api.quickbase.com/v1/docTemplates/1/generate?tableId=DBID_CHANGE_ME&format=pdf&pageSize=Letter&filename=Invoice&margin=1 1 1 1&unit=in&orientation=portrait&recordId=1 name: Generate Doc - ACTION quickbase[CHANGE ME] quickbase_api make -> b: inputs: body: "{\n \"to\": \"CHANGE_ME_TABLE_ID\",\n \"data\": [\n {\n \"6\"\ : {\n \"value\": {\n \"fileName\": \"{{a.json.fileName}}\"\ ,\n \"data\": \"{{a.json.data}}\"\n }\n \ \ }\n }\n ],\n \"fieldsToReturn\": []\n }\n }\n }\n \ \ ]\n}\n \"fieldsToReturn\": []\n }" method: POST url: https://api.quickbase.com/v1/records name: Save File to a Table note: 'Write the record ' - LOOKUP quickbase[CHANGE_ME] record look_up -> c: inputs-meta: table: '"Demo App: Invoice Files" <CHANGE_ME>' export_fields: '"File" <6>' inputs: id: '{{b.json.metadata.createdRecordIds[0]}}'0likes3CommentsA form button that will force record add on a specific form.
I have a tasks table, but I want to allow users to enter simple tasks or complex tasks. One form for simple tasks and another for complex tasks. This works for complex tasks and is the default form for all roles. URLRoot() & "db/" & [_DBID_TASKS] & "?a=API_GenAddRecordForm&_fid_145=" & URLEncode ([Project Number])& "&z=" & Rurl() I am trying this one for simple tasks, but it still loads the complex tasks form (ID=11) even though the URL says form ID 16. URLRoot() & "db/" & [_DBID_TASKS] & "?a=API_GenAddRecordForm&_fid_16=" & URLEncode ([Project Number])& "&z=" & Rurl() Also, this latter one is not loading the related project like the first one does. There has to be a simple way to load form 16 even though it is not the default for all roles.0likes2CommentsDynamic Filter - Default Date Range? (without filtering)
Good morning! I have a dashboard I built with a field called CLOSED DATE. I set this date as searchable and then as a dynamic filter. It works as is, but the date range in the filter is pretty large. 2018-2025. Is there a way to set a default date range that isn't dictated by additional filters? I set filter rules to be from Jan 1 2025 - Dec 31 2025 and that is the new default for the filter, but I can't select anything outside these dates. I would love to set the default to 2025, but have the ability change this to later or earlier if needed. Any suggestions are appreciated!0likes1CommentDuplicating Page/Dashboard on New App
Hello, I was wondering is there a way to create a copy of a Dashboard I have in one app and move it to another new app I created. Example: In App 1, I have a page/dashboard named "Clinical Admin Dashboard" with various widgets and images. I would like to copy and use that same dashboard as a template in App 2 so I may revise and update it for the new app. Is there a way to do this? Please let me know what suggestions you may have. Thanks in advance!Solved0likes3CommentsReport Formula - Combine some, exclude some, and include others.
I have a field [Types]. there can be A, B, C, D, E, or F. I need a summary report about these [Types] but the output needs to show, A, B, C+D, and exclude E and F. I'm using filters to exclude E and F. So I'm trying to use the Report Formula to create a new field [Performance] and using an If statement to say: if( [Type]="A","A", [Type]="B","B", [Type]="C","G", [Type]="D","G") The hope was that by renaming C and D to G, it would add those counts together when I add this Report Formula to the Column Group. but its only adding "C" not "D". Is this possible and I just have the wrong formula, or am I just going about this all the wrong way? Thanks, ASolved0likes3CommentsPosting from an HTML form directly to Quickbase
I would like to make a very simple HTML form (i.e., first name, last name, phone number, email address) that posts directly to a non-sensitive QB app. I am doing this in lieu of a mobile form in order to make it appear seamless on the related website, vs the more clunky mobile form link or iFrame window. I have no access to server-side configurations, so I am prepared to expose a user token in the HTML. Does anyone have any code that they could share that would give me an example of how to do this? Thank you in advance for your assistance.Solved0likes3Comments