MichelleCoslet
Qrew Assistant Captain
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: Syncing Sharepoint List to Quickbase Table via Pipeline
Is 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 ------------------------------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 choice
Is 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.Import data into text (Look up) field, numeric (reference) & build in Date Created fields
I 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
