ContributionsMost RecentMost LikesSolutionsRe: Quickbase email I.P address's blacklistedDid you open a support case so they are aware and take action to fix? Re: Can I use concatenate in Quickbase?What he said: ^^Values from visible but not acting like itI am using script to get values then insert into fields. The app is used seasonally so has not been active since last fall. Something has change affecting how the values behave. This is in an add record situation and the values are visible to my eyes as the form displays but do not behave as if there. Formulas using the fields have no result and Reference fields do not bring in Lookups. Once the record is saved, they behave. However, we need them to behave while still in the add mode. Here is the pertinent part. The bolded ones } else { console.log("inspectorNumber is not blank"); if (addRecord) { // Insert inspector number into appropriate field $('#_fid_695').val(QNumber); $('#_fid_10').val(location); $('#_fid_9').val(CCP); $('#_fid_374').val(inspectionTable); } else { // Add to the edits field $('#_fid_769').val(inspectorNumber + ' ' + inspectorName); } Re: Automatic import and Export Excel/CSV from Local pc to quickbase without using third-party apps of quickbaseOne Drive is not listed. If you watch the video, you will learn a lot and may see something you can use. DropBox is free to use, secure, and easier to use then OneDriveRe: Automatic import and Export Excel/CSV from Local pc to quickbase without using third-party apps of quickbaseQuick Base will not sync to your local machine directly. However, with DropBox (free) you can have a folder on your machine that sync to DropBox which in turn syncs to Quick Base. Here is a video on how: https://youtu.be/rPJqVULt5Cw Re: I would like to create a column that references two other columnsChange "Yes" to TRUE Without Quotes. "Yes" is text and TRUE is Bool If( [Column1]=TRUE,[Column2] ) Re: I would like to create a column that references two other columnsThis is assuming Column One is a Text field. If( [Column1]="Yes",[Column2] ) Re: Need help with a formula changing phone format from (000) 000-0000 to 000-000-0000I don't think so. It not really a search a and replace type of a function. If you have only one slash, you can concatenate what is left of it with what is right of it with an opposite slash in between. If there are multiple it gets much more complicated.Re: How do I retain the leading 0 in a formula field coming from a date field?Yup, that is what I forgot. Making it a text valueRe: How do I retain the leading 0 in a formula field coming from a date field?Try this which is untested by me If( Month([Invoice Date])<10, Year([Invoice Date])&"-0"&Month([Invoice Date]), Year([Invoice Date])&"-"&Month([Invoice Date]) )