Drop down list blank
I am developing a home page, one of fields is having drop down list with a specified list of values. When we go to edit page to feed values for this field we are seeing an extra blank option in the list. I need to have just the options i have specified in the list and get rid of this blank space there as an option. I verified and removed any blank space or extra new line in my list, but it gives still the same. Can someone please help me - how to remove these blank space. ------------------------------ Rishabh Narula ------------------------------8Views0likes6CommentsRemove commas (newbie here) from imported numbers
Hello - I've spent an hour searching the community and cannot find an answer to removing the commas to my uploaded numerical column. I was my numerical field to look like this: 123456789 not; 123,456,789 I have changed the field properties to text and yet I still have commas. I have uploaded twice - no workie. Please help this new person with her first upload. Thanks, Lois ------------------------------ Lois Rockwell ------------------------------7Views0likes2CommentsCounting log edits in a text field
I have a multi-line text field named [Client's referrals] that logs the edits to the field with Date, time and user. We keep track of the people a client has referred to us. I would like to know how many people a client referred to us each month. Is there a way I can count each edit and catch the date? Thanks! Consuelo ------------------------------ Consuelo Viramonte ------------------------------7Views0likes1CommentCustom Error Message For Unique Formula Fields
I have a table called Clients. In this table I have a formula field called Unique Identifier which concatenates a client's first name, last name, and email into a single string. Unique Identifier is also a unique field to prevent duplicate Client entries into the system. When I try to save a duplicate client record a Quickbase message pops up saying "Fields which are marked unique must contain unique values for all the records. You have entered a duplicate value for the unique field "Unique Identifier" Please check your data and try again. (The client was not saved)_" Is there a way to modify/customize this message? I would like for it to say something like "This Client Already Exists" ------------------------------ Abhishek Kumar ------------------------------5Views1like0CommentsSnapshot for a look-up field?
Hello, I have a table that contains my sales reps and their commission plans. Whenever I generate a project in my projects table, it links the sales reps' commission percentage to each project. I have a 3rd table (Costs) that calculates fixed costs on projects and calculates commissions related to this information. The look-up numeric field pulls the commission amount from the projects table. I'm trying to make the look-up field in Costs for the commission percentage be a snapshot, as contracts and commissions change, i can't have it affect older projects that were created during a different contract value. Whenever I change the field to a look-up field, the snapshot option disappears. Can someone help me with this? Thank You So Much ------------------------------ Anthony Wong ------------------------------5Views0likes1CommentCan I Use a "Page" as a Table Home Page instead of a "Report"?
Is it possible to use a specified "Page" from my app as a table's home page rather than a report? I'd like for user's to be directed to a designed Page with multiple reports and information when they click on a Table's icon. I can't find a way to do that. Thanks! ------------------------------ Quick Base Admin ------------------------------5Views0likes4CommentsColumn Header in Table
Hi All I have the name of a field in a database file like this: GEO_Continente_Sigla When QuickTable creates the management forms of this file, the column header of the table shows exactly the name of the field, that is GEO_Continente_Sigla Instead, I want the column name to be just "Initials". Is it possible to change the header of the table column without changing the name of the field on the database? ------------------------------ Adriano Visconti ------------------------------4Views0likes1CommentHow to remove option "None of the above" from radio button options
I converted my text multiple choice drop down to radio buttons using by customizing the form, but after the conversion an extra option called "None of the above" is created. This can create confusion for the users. Please suggest me how to remove this option. ------------------------------ Aswin Babu ------------------------------4Views0likes4CommentsUsing "hidden" fields in dynamic form rules
I have a Request form that I need to validate the date and time for the date the service is requested. I created formula fields to use in the dynamic form rules, but I do not want these fields to be displayed on the form. If I don't include them on the form, the dynamic forms rules don't work. I tried including them, but for edit only and that did not work either. I tried putting the formula fields in a separate section and used a dynamic form rule to hide the section and that also caused the date test dynamic rules to fail. I have a test form with the fields displayed and the rules work perfectly. How can you configure the form so that the fields are not displayed, but they are available to the dynamic form rules? (without using javascript because that is above my skill set.) Thanks in advance for any help! ------------------------------ Julie Meeker ------------------------------4Views0likes4Comments