ContributionsMost RecentMost LikesSolutionsRe: Can I have more than three fields displayed in a default record picker?Great, thanks for the info ------------------------------ Jemma Data Analyst & Visualisation United Kingdom ------------------------------ Can I have more than three fields displayed in a default record picker?I have an app which holds two tables with a relationship. One of the fields which is pulled through in my child table is a reference proxy from the parent table. So the user completes a form then picks the associated record from a drop-down and that data forms part of the record. I can pick three fields to display for the user to select the right record. Three fields isn't really enough for them to identify the right record though. I can see under Advanced Table Settings there is an option to build custom data rule... not sure if this might be my solution... ------------------------------ Jemma Data Analyst & Visualisation United Kingdom ------------------------------ Populate table with field from another table based on two fields matchingHi there I have a table of financial values called [Role-based Limits] which are unique based on two fields - [role]&[region]=[value] A user can add more than one [value] based on [role] and [region] by adding a new effective date. So, a unique value would be [effective date]&[role]&[region] In a second table called [Authority Limits] I have employee data. There is a relationship (1 authority limit to many Role-based Limits) In [Authority Limits] table I also have [role] and [region] fields. What I want to do, is when role and region are populated in [Authority Limits], the latest [effective date] and associated [value] fields are populated from the [Role-based Limits] table. I do have a look-up field for the [value] in the [Authority Limits] table, but this is just a dropdown of all of them. How do I do this?? ------------------------------ Jemma Data Analysis & Visualisation United Kingdom ------------------------------ Re: Using HMTL to modify text fieldsPerfect, thanks Evan Martinez ------------------------------ Jemma Data Analyst & Visualisation United Kingdom ------------------------------ Using HMTL to modify text fieldsHi there I'm trying to get creative with some text fields. But, my HTML syntax is not right, because it's not working. It's applying the first item in my span style tag but ignoring the rest. This is what I am putting in the text item properties. The text displayed is the word "Quoted": <span style="background-color:#563D82; font-size=20px; font-color=WHITE"> <B> Quoted </B> </span> HELP!!!! ------------------------------ Jemma Data Analyst & Visualisation United Kingdom ------------------------------ Using HMTL to modify text fieldsHi there I'm trying to get creative with some text fields. But, my HTML syntax is not right, because it's not working. It's applying the first item in my span style tag but ignoring the rest. This is what I am putting in the text item properties. The text displayed is the word "Quoted": <span style="background-color:#563D82; font-size=20px; font-color=WHITE"> <B> Quoted </B> </span> HELP!!!! ------------------------------ Jemma Data Analyst & Visualisation United Kingdom ------------------------------ Display field only if checkbox is not emptyThis is very straightforward but I can't figure it out in my own because i'm a noob. I have a checkbox field called [Profit-share arrangement] If this is selected, there is a follow up question called [Profit-share arrangement appropriate] I need to know the syntax to include in the follow-up question's formula field to only display this if the checkbox is checked. e.g. =IF([Profit share arrangement]=TRUE.....? ------------------------------ Jemma Dicks ------------------------------ Despatch an email when a date approachesHi there :-) I have a calculated date field called 'Next Review Date' This field is a formula, set 6 months ahead of another date which I enter. Two weeks before the 'Next Review Date is [today], I would like an email sent to two people. I am a noob at QuickBase, so I have NO idea how to go about this. ------------------------------ Jemma ------------------------------ Re: Formula syntax to reference a related tableDon't worry, i've figured it out. I went to the relationship between the tables, and added the 'date range covered' field as a lookup value. Then I updated my formula to show this field if the checkbox was checked. It only took me a day! :-P ------------------------------ Jemma ------------------------------ Re: Formula syntax to reference a related tableI'm guessing i've done it wrong by trying to pull the value through via a formula! I don't know how to create lookup fields yet, I really don't know how to use QuickBase... ------------------------------ Jemma ------------------------------