Conversion from textlist to text?
I'm trying to write a formula for two fields-- Field 1 has Option 1 and Option 2. I'm trying to configure it so that if the user selects Option 2, then another field will pop up for them to answer. Right now, my formula works because I have Field 1 set as a Multiple Choice field type. However, I need Field 1 to be a Multi-Select field type, and when I try to change it to a Multi-Select, then my formula does not work. I get this error: Invalid formula provided in form rules: [{"errorMessage":"Formula Error -- Type MismatchThe expression [_fid_18] on the left hand side of the operator \"=\" is of type textlist while the expression \"Vendor\" on the right hand side is of type text.","ruleIndex":11}] What's the best way to implement this?
Working with %%rid%% and checking a box
I know this has been probably answered before, but I just can't get this formula to work. I want it to save a record (even a new record or already created one) and check a box. I am going to use that box in a pipeline. Here is my formula. Can anyone see what I am doing wrong? It does not check the box (fid is 599). var text RID =If(IsNull([P-Referral Record ID#]),"%%rid%%", ToText([P-Referral Record ID#])); var text URL = URLRoot() & "db/" & Dbid() & "?a=er&rid=" & $RID & "&_fid_599=1"; var text LABEL = "Send Consent to JotForm"; "<a class='Vibrant Success SaveBeforeNavigating' data-replaceRid=true href='" & $URL &"'>" & $LABEL & "</a>"
Formula to populate a field based on another field that contains a specific text string?
I'd like to have a field on a form automatically populate based on if a specific text string exists inside of another field. Let say field 2 will be populate with the text "red squadron" if field 1 contains the text "red". Can I do this with a formula using contains or would I need to create a table where all possible combinations that contain the text "red" would align to being in red squadron?
Trying to format with 2 decimal places
I have a Formula Rich Text field to display a grand total. If the cents end in 0 like .10 it drops the final 0. Here is my formula "<p style=font-size:14pt;color:red;><b>"& "$" & ToFormattedText(Round([Total with Tax & Fee],0.01),"comma_dot",3)& "</b></p>" What do I need to add to show that final 0?Looking up a Field in a Different Table in the Same Application without a Relationship.
Hello: I have one application with many tables. The two tables in question are: Applications Student Demographics. Applications Table Fields and Types: Name (formula-text) Phone Number (formula-text) Email (formula-text) Student Demographics Table Fields and Types: Name (text) Phone Number (number) Email (email) Values Name Field ID: 7 Table Alias: [_DBID_STUDENT_DEMOGRAPHICS]) Table ID: btn82xxxx Goal: I am trying to look up the name, phone, and email fields in the Student Demographics table and transfer the data to the Applications table (without a relationship) using a formula. Challenge: I am receiving different error messages. "Expecting text but found number." "Expecting text but found record list." GetRecord(7,[_DBID_STUDENT_DEMOGRAPHICS]) GetRecord(7,"btn82xxxx") Questions: Am I using the correct function? Is the Record ID the same as the Field ID? Am I correct in selecting a formula-text field type for the phone number and email fields? Thank you, Roula
In-App Formulas - Removing Duplicates From A List or String
I'm working on a formula to concatenate values from multiple multi-select text fields while removing any duplicates in the output. My goal is to create a unique, semicolon-delimited list that’s easy to process further. Here’s a breakdown of the fields I’m working with: [Related Modification - Operator Access] [Related Project - Operator Access] [Related Phase - Operator Access] [Note Replying To - Operator Access] [Related User - Affiliation] Quickbase’s formula language doesn’t support loops, assignments, or a direct Unique() function to filter out duplicates. Here are some of the approaches I’ve tried: Using Conditional If Statements I set up If statements that check each field’s value with Contains to see if it’s already present in the accumulating list. While this approach works in theory, I have been having trouble with type and syntax errors. It also quickly becomes verbose and difficult to maintain as the list of fields grows. var text initialList = ToText([Related Modification - Operator Access]); var text withProject = If(not Contains(ToText(initialList), ToText([Related Project - Operator Access])), List("; ", ToText(initialList), ToText([Related Project - Operator Access])), ToText(initialList)); ... and so on for each field Using List and Split Functions with Unique() Equivalent I attempted to split the concatenated list and simulate unique functionality by adding fields conditionally. Unfortunately, Quickbase lacks a direct Unique() function for removing duplicates from lists, so this approach didn’t work as expected. Help Requested Has anyone found an efficient way to concatenate and de-duplicate multi-select text fields in Quickbase? Ideally, I’d like a solution that’s concise, scalable, and doesn’t require manually adding each field with repeated If and Contains checks. Are there workarounds, or perhaps Quickbase functionality I’m overlooking, that could streamline this task? I would much prefer to keep the processing in the table as it pulls from other tables where the data can change. So it needs to be quite responsive and I don't want to have to declare an excessive amount of triggers. Any insights, examples, or alternative approaches would be greatly appreciated!
