Forum Widgets
Recent Discussions
Removing Invalid Characters for File Name
Good Afternoon, I am trying to manipulate a simple text field to remove the following characters: \ / : * ? " < > | So that I can use it for file names. When I try SearchandReplace, it keeps throwing up syntax errors for these characters despite my double quotes around them. Is there a way to get these characters removed to prevent any file upload issues due to file name? Thank you for the help!
PIpeline - split multiselect and create records from it
I can't seem to wrap my head around this. I have a record with a multiselect field. When conditions are met, I want a pipeline to take data from the record and create a new record in another table, creating one record for every value in a multi-select field. I can't seem to figur eout where I would put the jinja to split those values and then loop through them. Googling came up with the following for the Jinja: {% set selected_values = a.your_multi_select_field | split(';') %} But where would I put this? Seems like I need a step after my trigger to do this, but there isn't a "jinja" channel.
API not deleting attachments
Hi all, hoping someone may be able to assist. Am using a pipeline to remove attachments using the format of 'fid_14=&delfile_fid_14=1' The result of this is that whilst the attachment looks to be removed from the form, it still is actually being stored (app file manager shows the attachments still exist). Has anyone else encountered this or possibly have a solution ? Cheers in advance.
Unrelated Data
I suspect I know the answer to this question, but am hoping that someone has better solution. I have unrelated data except for the fact that is time stamped. I need to chart both series. The two options I know are: Export to SQL and use Tableau, then embed a Tableau report in QB. Create a table of dates to force the different sets to be related together. Anyone know of another method?
Importing excel into multi select text field which is connected to another table inside same app
I am trying to import data by adding existing data which is in another table but I am seeing a weird behaviour that rather than selecting the option which is already present it tries to create new option and as the option is more inside the main table it is throwing me error. Please give a reply ASAPMatching Fonts on Templates using Rich Text and Standard text
Hi, I'm very new to the quickbase world and trying to manage an app that was built for my agency. My question is about changing the font that prints from a form in Rich Text. We have several forms that use templates to print out and when there are both rich text fields and standard text fields used, the rich text fields default is different than the standard text in both size and font. This obviously looks terrible but I can't find a way to adjust it. I have read several articles and conversations about using rich text with HTML tags, but I can't find a way to actually adjust the font (I think prior to 2023 the options in Rich Text fields, were well richer). Can someone offer a suggestion. BTW, I am not a programmer so I need basic instructions on where to find things and how to adjust them. HELP! And TIA - HayleyCould not parse XML input
Hi, I'm getting errors on my pipelines for a multi-line field. Quickbase reported an error: 11 : Could not parse XML input : XML Parsing Error. not well-formed (invalid token) at line 3 column 353 (which is byte 700) When I look through the activity log and the original db i'm seeing these characters: †and “. When I talked with the users they said they did not put them in the field. After a little research it looks like it was a copy and paste issue. My question is how can i prevent this from being sent through the pipeline? Thank you
