ContributionsMost RecentMost LikesSolutionsFormula to Reset the allowance/values on January 1st of every yearHI I have a situation where i am trying to keep track of all the allowances for my techs. Each tech has allowance of $ 500 and that resets on 1st of January every year. All there expenses are reimbursed withing this allowance as soon as they turn in. I have created a table to get all those entries. All the new hires have to wait for atleast 365 days in order to avail this allowance. I have a setup a field to calculate the no of days worked but i am confused with part where i need to reset there limits every year. Can you please help me with this. Thanks ------------------------------ Amandeep Dhillon ------------------------------ Re: Sort of using Vlookup in QuickBase- setting up a field to look through multiple records and then match and assignThank you Mark, it worked perfect. ------------------------------ Amandeep Dhillon ------------------------------ Sort of using Vlookup in QuickBase- setting up a field to look through multiple records and then match and assignHello I have 20k records with about 124 fields in table -1. One of the field is City (Text field). Now i have another table-2 where i have added all 150 Cities assigned to us and each City has unique Region Code (BC1A, BC 2A sort of). I want to recreate that same Region field in Table 1 with all the records. I have tried creating a formula-text field and apply the if-else as well as case condition but it returns error that City field needs text value which confuses me further as its already a text field. is there a way to automate this filed. Thanks for your help. ------------------------------ Amandeep Dhillon ------------------------------ Adding email address to Address book without adding usersHello I have about 80 technicians and i want to email them there routes everyday. I have a generic report and i usually filter the tech out and email him the report from quickbase directly. I have to manually punch in the email address of each tech. is there a way that i can save all the emails to addressbook and it can be populated automatically rather than manually inputing them. I also have limited user license and i don't want them to be assigned either. ------------------------------ Amandeep Dhillon ------------------------------ Re: Converting Date From mm-dd-yyyy to dd/mm/yyyy Hi Mark It worked perfectly fine. Appreciate your help. ------------------------------ Amandeep Dhillon ------------------------------ Re: Converting Date From mm-dd-yyyy to dd/mm/yyyyHi Mark Thanks for your response. The first solution has error- Cannot use "-" operator on types text. whereas with second solution result is dd-mm-yyyy and blank fields as 00-00 whereas my specific requirement is dd/mm/yyyy Please help. ------------------------------ Amandeep Dhillon ------------------------------ Converting Date From mm-dd-yyyy to dd/mm/yyyyHello I am trying to convert the date from mm-dd-yyyy to dd/mm/yyyy and i have used following formula Left(NotLeft(ToText([Last Drop Status Change Date]),"-"),"-")& "/" & Case(Left(ToText([Last Drop Status Change Date]),2), "01","01","02","02","03","03","04","04","05", "05","06","06","07","07","08","08","09","09", "10","10","11","11","12","12")& "/" & Right(ToText([Last Drop Status Change Date]),"-") My issue is that it works on all the fields that have date values but with blank fields it returns the value"/ /". Can someone help me in figuring this out. I was thinking of using IF and else with this formula but its not compatible. I would appreciate all the help and insights. ------------------------------ Amandeep Dhillon ------------------------------ Re: Getting information from one app to talk to another app Hi Mark What will be Application token in this ? Kind Regards, Amandeep Dhillon Project Manager Work 604-353-9215 5680 Production Way Langley BC V3A 4N4 This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Re: Is there a way to search multiple records and open multiple records with one button/click?HI Mark Thanks for your response. My situation is that i have 30 K orders and each order is identified by Term "DPO". Then further each DPO has 60 different fields like address, customer information etc. This information is pulled directly from salesforce as i have connected the table with salesforce account. Now my challenge is that i have to edit multiple DPO's at same time for instance i need to mark there status as scheduled, but when i go into report i see all 30 k DPO's and they are staggered . So i have to manually search each DPO and change its status to Scheduled / completed . I am looking for a way to serach all 20- 30 or whatever no, to edit them in grid view at sametime by changing 1st DPO manually and then selecting all other s and using Ctrl+D. I hope the description paints a better picture. ------------------------------ Amandeep Dhillon ------------------------------ Re: Is there a way to search multiple records and open multiple records with one button/click? HI Ning I am in same situation as you. I don't have IT background. Are you able to break it down in steps for me. I also want to search multiple records under one Common heading at same time. I would really appreciate your help. ------------------------------ Amandeep Dhillon ------------------------------