This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I'm thinking I can use a 'formula' field to do this task. Can anyone help with the 'Formula' field... or is there a better suggestion. Thx.IFFirst 4 characters of a record in {Unit & Week} = First 4 characters of a record in {Unit Name} AND {2023 Fee...
I created a new base in preparation for moving some spreadsheet data. Column 'A' of the sheet is dates.I'm thinking I can set the primary field as a 'date' field and include 'time' in order to make each record unique. After import (copy & paste) I ca...
Field 1: is a currency fieldField 2: a checkboxField 3: is a currency fieldI need a Formula in field 3 to do this: IF field 2 = 1, copy & paste the value in field 1 to field 3.Thank you.
Hello,
I’m comfortable with spreadsheets… not so much with databases.
So, here’s my dilemma:
I have a base with 49 records (names of people is the primary field) - 27 people exiting the program from last year and 22 returning to continue service. The...
Thank you!I thought the Primary Field data had to be unique and did not know AT assigned a unique identifier so as to allow duplicate entries in that field. So, I'll set the base up pretty much like the spreadsheet except utilizing 'Linked fields' an...
Thank you... not working. Here's what I wrote in the formula: IF(AND({Cleaning Fee}, {2021 Cleaned}), IF({Cleaning Fee} = {2021 Cleaned}, {Cleaning Fee})) Do you see my error? Field 1=Cleaning Fee (Currency)Field 2=2021 Cleaned (Checkbox)Field 3=Cle...
