ContributionsMost RecentMost LikesSolutionsRe: Syncing Sharepoint List to Quickbase Table via PipelineIs a script the only way? i thought that was the purpose of pipelines. I have the same issue. Our production staff uses Sharepoint but Engineering uses QB. When an operator adds a record to the sharepoint list, i need ENG to sign off on it in QB. Then the record in sharepont status would change accordingly. ------------------------------ Michelle Coslet ------------------------------ Form rule: triggered when a field CONTAINS a wordHow would i set up a form rule to display a window prompt if a field contains the word "Solder"? My options are limited to Equals, does not equal, >, <, is between, etc. ------------------------------ Michelle Coslet ------------------------------ Formula help I am trying to create a numeric formula. Hope someone can assist If [ORDER QTY] is between 2 and 8, [SAMPLE SIZE] equals "2", If [ORDER QTY] is between 9 and 15, [SAMPLE SIZE] equals "3", If [ORDER QTY] is between 16 and 25, [SAMPLE SIZE] equals "5", If [ORDER QTY] is between 26 and 50, [SAMPLE SIZE] equals "8", If [ORDER QTY] is between 51 and 90, [SAMPLE SIZE] equals "13", If [ORDER QTY] is between 91 and 150, [SAMPLE SIZE] equals "20", If [ORDER QTY] is between 151 and 280, [SAMPLE SIZE] equals "32", If [ORDER QTY] is between 281 and 500, [SAMPLE SIZE] equals "50", If [ORDER QTY] is between 501 and 1200, [SAMPLE SIZE] equals "80", If [ORDER QTY] is greater than 1201, [SAMPLE SIZE] equals "125". ------------------------------ mkosek mkosek ------------------------------ Change field type from Text Lookup to a multiple choiceIs there a way use a Text (lookup) field also as a multiple choice field in a form? I have a field called 'Assembly Id' that is Text(Lookup). On my form, the user selects from a drop-down list the Assembly ID they are working on. I would like for them to be able to select more than one Assembly ID. Is this possible? Thank you in advance! ------------------------------ mkosek mkosek ------------------------------ Re: how to I set up the following duration formula?How do you handle this situation if the [date created] is Date/Time and the [Date Finished] is just a date? I don't think I can change the Date Finished type at this point without messing up a lot of data. I just need the amount of days from start to finish. Re: Import data into text (Look up) field, numeric (reference) & build in Date Created fieldsWhat do i do with this information though. I saved the Operators table as a spreadsheet. I see the record ID (Operator ID in my case). Not sure on the next step. Thank youImport data into text (Look up) field, numeric (reference) & build in Date Created fieldsI have a spreadsheet full of data that I need to import into my App. The three fields that are NOT available to import into are: Assembly ID[text (look up)] field Related Operator[Numeric (reference)] field Date Created(Build in Date/Time) field Is there a way around this? I have over 7k entries that need to be imported so doing so by hand is not really an option. TIA Re: which picture upload option uses more data space?Perfect response. Thank you!which picture upload option uses more data space?1. Attaching a photo via "attachments" 2. Adding the same photo to a rich text field Which type uses up the most data space? Same picture, same format. Re: Native solution to populate fields by scanning a barcodethanks! your reply had me thinking that maybe I can scan direct from my phone. Found the IOS app, Scankey and it works perfect. Thank you!!