NeveLeem
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Create formula User field using another user field
You mean something like If (UserListToEmails([Analyst])="analyst #1 email address", "supervisor#1 email", UserListToEmails([Analyst])="analyst #2 email address", "supervisor #2 email") ??? When I tried this, it gave me an error. "The types of the arguments or the number of arguments supplied do not meet the requirements of the function UserListToEmails. The function is defined to be UserListToEmails (UserList ul).Create formula User field using another user field
Hello. I have an analyst field-user and leadership field-formula user. All users are QB users. For Leadership field, I created a formula to say something along the lines of If ([Analyst]=ToUser("analyst#1 email address"), "supervisor#1 email address",[Analyst]=ToUser("analyst#2 email address"), "supervisor#2 email address") However this formula did not work... Does anyone have any idea how to make this work? Thank you in advance!Date stamp formula for checkbox
Hello. I have a quick question regarding date stamps. I have two check-boxes on my form: import and export. For both, I hope to create a formula date stamp field to see when users ticked these boxes. We have a few older records to see when they were imported and exported. When they built this application, they did not anticipate the importance of these check-boxes. Is this at all possible? Thank you very much for all of your help!Formula to change one letter in a text field
Hello! I have a text field. This text field will always have "XXXX-XXXX" format, unless there is a revision to the document. In which case, it will turn into "XXXX-XXXX 01" I was wondering if there is a formula to turn that "0" to "R", to signify revision status, without changing other "0"s? This "0" will always be in the same 11th spot. Thank you for all of your help!Formula text to find existing text in other fields
Hello! Is there a way a record can look outside its own record, and look at the whole table when putting a formula text field? We currently have several documents. Each document has its own record in our main table. Some of these documents are linked, and have revisions. Right now when a revision is introduced, we have to access each previous document record and edit "Updated Version" field. So we have two main fields for this question: "Affected Documents" for new record and "Updated version" for previous(outdated) record. Basically we want to be able to auto-populate "Updated version" field when "Affected Documents" field is inputted, so that we do not have to manually update those previous records. Is this possible? Thank you in advance for all of your expertise.Could I link my SQL to my database to upload daily?
My group has a SQL script that we pull from our company's data mart daily. Currently we download daily data into excel format(.xlsx), which we manually import into QB every morning. But another group went to a QB training in Nov 2015, and said that they heard that we can link our QB to SQL, so that we do not have to go through so many steps just to upload the data every morning. Does anyone know if this is possible (oh and free, without using another web-platform or program)? Thank you very much in advance!
