I have two tables in the same base. Each has a field that contains a member number. However in table 1 the member number is a formula. How can I write a formula that will return a different field (member name) from the second table into a new field i...
Hello --I am interested in developing a formula to assign ID's to a series of payments based on type of payment, date, and information on payee's name. This is for tracking payments in a program that is pairing experienced mentors with mentees.There ...
Hey there. I came soooo close to getting a working formula for what I was trying to achieve but fell at the last hurdle.I have a date field and a number field from a lookup. I am trying to create a formula that gives me a new date based on the the d...
{Rate (from Contract LU)}/{Frequency (from Contract LU)}Rate is a currency field and Frequency is a number field. Both reside in the Contract LU table.I have been using the above simple formula in invoicing successfully for quite a while. I recently ...
Hi Community, this is a little brainteaser for advanced formula wizards. I am stuckHere is the situation:Up to 3 "quality checks" need to be done for some workflow. Each "quality check" has a check box fieldQC1QC2QC3Each quality check also has a sing...
Hello,I've created a database with a form and applications that allow each employee to make holiday requests.They can apply for leave over two months (example: from 10/08/24 to 16/09/24).My requirement: I need to know, for each employee, how many day...
Please help I need a formula for reoccurring seasonal milestones. We have seasonal launch dates and milestones in each season that occur at intervals; -130 wks, -80 wks, -56 wks. I want to calculate the due date of the milestone based on season la...
So I have a single Attachments field in a table that allows for multiple individual files to be attached to a record. I want to create another field that counts the number of files that have been uploaded/attached to that record. I then want to them ...
I’ve attempted to follow the recommendations here to detect duplicates in a field but have not been successful and could use some expert eyes on what I’ve implemented. I did put a reply on that thread but since it’s a couple of years old, figured I s...
I have two tables:Key Source FormulaSourcesWithin the Key Source Formula table I have a field called URL FormatAn example entry is: https://www.website.com/search/?q="Company"&t=weekIn the Sources table I have a value called Company Name Texte.g. A...
