Topics in Quick Base 1970-01-01T00:00:00Z 12111 12014 0 0 0 307 7723323 I'd like to be able to send out an automated email to an employee on the day of their birthday. 2018-04-19T15:10:37Z 2018-04-19T15:10:37Z Aaron Zielinski aaron_zielinski I'd like to be able to send an automated email to each employee in our organization on their birthday.&nbsp; We have their birthdays listed in Base in the format MM-DD-YYYY (04-19-2018).&nbsp; I'd like this to trigger every year on that specific day.&nbsp; Any help is greatly appreciated! question 0 1 1 create 7723029 Select order number from text field 2018-04-19T12:17:32Z 2018-04-19T01:08:58Z Meagan McLeod meagan_mcleod I have a text field includes the subject for order confirmations. Some emails have the subject:<br /><br />Order Confirmation (1234567)<br />or<br />Order Confirmation - 1234567<br /><br />Is there a way to grab only the sales order number? question active 2 4 1 comment 7720880 Align button at top of field in form 2018-04-19T04:55:22Z 2018-04-15T05:17:17Z Gary Boyd gary_boyd_1ihbn3ff0q29e Hi,<br />I've added a formula rich text field button and it appears in the centre of the field on a form. I would like to lift the button &amp; text height so they take less vertical space on the form. I have tried align &amp; vertical align with no success. <br /><br />"&lt;a &nbsp;class='Vibrant Snowy' style=\"height:25px; align:top; text-align: top;\" &nbsp;href='" ...<br /><br />Also, when viewing a form, all fields have automatic grey backgrounds. Is there a way to remove the field backgrounds so they look like the rest of the form (same as they do in edit)?<br />Thanks. question active 2 2 1 comment 7520629 Use a drop down menu instead of pop-out record picker 2018-04-18T22:05:04Z 2017-05-17T14:48:50Z Jordan jordan_beatty Currently, I am setting up alternate relationships between tables for filtered drop down tables. I join the two tables on record ID, then use a proxy field that is a text look up and use a report I generated instead of the standard record picker. I am getting all the entities I am looking for but they are displayed in the pop up record picker for selection, is there any way they can be in a drop down selection instead? question complete 10 6 1 comment 7722932 buttons to copy a table to another table and edit the original table 2018-04-18T21:12:19Z 2018-04-18T21:12:19Z Marisa Carde-Little marisa_carde_little I have Table A which includes the current billing cycle for our jobsite. And table B is the archive table for all the previous billing cycles. What I would like to do is have a button on table A's page somewhere that allows someone to archive Table A to table B ( aka just copy the contents and paste them into table B)<br /><br />I then would like a different button on Table A's page that changes the current billing cycle based on the value in Table C. Ideally, it would replace the old billing cycle id with the new one, and then I need to go one step further and clear the hours worked from the previous billing cycle(percentage per project in my case).&nbsp;<br /><br />I have already thought about the functionality of archiving it and just keeping it in the same table, but I don't see an easy way to copy all the fields from the previous billing cycle into the same table with a new billing cycle id. My fear is that I would end up copying all the records in that table and would create duplicates of people on specific projects for a new billing cycle. I have thought about the possible headache any changes in the table would bring, but I can't imagine it being too bad, or likely to change.&nbsp;<br /><br />Thanks everyone!&nbsp; question 0 2 1 create 7722925 On Add - default Save Button to "Save and keep working" 2018-04-18T21:01:56Z 2018-04-18T21:01:56Z Elwyn elwyn_4a4wz5fz3kv2y When adding a new issue record I ask some prelim questions that I want answered before the user continues.&nbsp; Is there a way I can default the Save button to only show the "Save and keep working" option?<br /><br />Please note that I have not implemented IOL, so if your answer includes this, I would appreciate as much detail as possible.<br /><br />Thanks! question 0 1 1 create 7722891 New Record in Another App 2018-04-18T20:17:41Z 2018-04-18T19:34:28Z Todd Griffith todd_griffith_3gcicialcjamy I have two apps.&nbsp; I would like to have a button on a dashboard (app A) that would create a new record in a table in the other app (appB).&nbsp; When creating this new record, I would like data to prepopulate with&nbsp;set value.&nbsp; I will want to change this code to paste a different value depending on the location I put this button.&nbsp; This button could potentially be added to several other apps. question active 4 3 1 comment 7441980 How do I create a formula field that changes a date field to the the the current month? 2018-04-18T19:30:47Z 2016-12-07T20:35:34Z Lori lori_gx47nbtgbl0hl Current date field:<br /><br /> <b>Date:</b> 10-5-2016<br /><br /> The formula field would then generate<i>&nbsp;12-5-2016 </i>since the current month is December, each month the formula would update to the current month.<br /><br /> I tried using AdjustMonth() and Today() but was having no such luck. question complete 13 3 1 comment field, formula, date field, date, formula field, date formula 7722349 Can you add values in multi-line text fields? 2018-04-18T18:28:18Z 2018-04-17T22:22:16Z Luisana Cardenas luisana_cardenas I need to add values in a couple multi-line text fields. They are not numeric fields so I'm finding it hard to do this. Is there a solution? All options in the fields are numeric but we've made it a multi-line field so that they are forced to choose from a set of codes. question active 3 3 1 comment 7519663 Creating event in google calendar 2018-04-18T18:19:12Z 2017-05-16T05:52:09Z Arshad Khwaja arshad_khwaja_7166138 Is there a native solution to send an event to Google calendar from my app?&nbsp; question complete 20 3 1 comment 7722813 How to format a QB notification email to add a Google calendar event 2018-04-18T17:40:41Z 2018-04-18T17:40:41Z Elena Larrabee elena_larrabee Hey all, I know there's a way to set it up so that QB can "automatically" add events to a Google calendar if the notification is set up properly - can someone tell me how to do that? I have the Google account in question set up so that it automatically adds events from emails, but so far I haven't had any luck getting the QB notification email to trigger this. Any suggestions? question 0 2 1 create 7439366 Is it possible to populate fields in one table with data from fields of another table? 2018-04-18T17:22:25Z 2015-07-28T17:42:04Z Amanda amanda_gzcp1v4hf5iok <p>Before I start trying and make a mess I wanted to ask....&nbsp;</p><p>Here is my situation: I have a tasks table and a weekly agenda table. Employees would like to be able to click a button on a task and move it to the Weekly Agenda table and maybe add more data once in the weekly agenda area. (They want it to&nbsp;</p><p>Rather than having a relationship with reports links, etc... I would like employees to be able to click the button and have the relevant information auto-populate on the new form... I know this can be done within a table, but I dont know if it is possible to do ACROSS tables...&nbsp;</p><p>Any suggestions?&nbsp;</p> question complete 16 3 1 comment tables, add, button, fields, reports, tasks, table, form 7440726 Calendar display not showing 2018-04-18T15:59:56Z 2016-04-18T13:45:02Z Ann ann_d5zwk1l94g5fq I have 4 entries on my calendar and it's only showing 2. Please see pictures for reference. How can I show all 4 entries to the calendar? I have checked my setting and the maximum entries per day is blank. Should I put 0 there?<br /><br /><br /><br />Thank you!<br /><br /><img src="" title="Image" /><img src="" title="Image" /> question complete 2 2 1 comment reference, calendar 7720294 Button URL specific record with Everyone on the Internet 2018-04-18T15:31:02Z 2018-04-13T19:27:23Z Bradley Damron bradley_damron I send an email with a URL button directed to a record that needs to be updated by a specific employee.&nbsp; I do not want other employees to be able to manually change the record id in the url and view other records, is there a way to embed something in the button url unique to that record that is not easily modified?&nbsp; question complete 22 4 1 comment 7722489 formula compilation help 2018-04-18T13:50:57Z 2018-04-18T05:12:18Z Geoffrey geoffrey_gc63mh97rcznb I just need some direction on how to compile an if type formula:<br /><br />I have a questionnaire with a list of approx 20 "Yes" "No" "N/A" options in each (drop down list)<br /><br />I want to create a quick formula that checks all questions.&nbsp; If <i><u>any</u></i> of the questions have the answer "No" it will give me a "Non-compliance" result,&nbsp;<br /><br />and if they are <i><u>all</u></i> yes it will give me a "Compliant" result<br /><br /><br />not sure if this is done with an if statement or not? question complete 6 4 1 comment