PiotrKryszkiewi
Qrew Trainee
Joined 5 years ago
User Profile
User Widgets
Contributions
I need to find blocks of dates between multiple start and end dates entries.
Hi, Is there a way to find blocks of "non-interrupted" dates if I have a table with multiple assignments? Below I paste the example. Each assignment has start and end date and person assigned. I would like to find blocks of dates when the assignment was not interrupted by other assignment for other person and create one row for each of this block (Column "Wanted" on the screenshot). ------------------------------ Piotr Kryszkiewicz ------------------------------Limit number of records possible to create using grid edit child table on parents form.
Hi, I have relationship between to tables. A is on one side and B on many side. On the form for record in table A I have attached grid edit report from table B to allow users to create multiple child records at once. Is it possible to restrict user to create only up to 5 child records on this form using grid edit report? Is it possible to require at least one entry in this grid edit report and don't allow user to save the A record until at least one child record is created in grid edit report? ------------------------------ Piotr Kryszkiewicz ------------------------------Pipeline - extract distinct values from table.
Hello, I have Positions table in my app. In each position user should fulfill the email field of user assigned to this position. Now I'd like to extract all emails I have in this table to csv file. I'd like to do it automatically. I found a way to achieve it with pipeline. Currently I am extracting all records so all emails. I don't need duplicated emails, I mean when xx@email.com is assigned to 3 positions I need this email only once. Is there a way to search only for distinct emails in Search Records step or in any other? ------------------------------ Piotr Kryszkiewicz ------------------------------Flag removed projects from next cycle report.
Hello, Each month (around 20th day of month) I am manually uploading the report to Projects table in Quickbase. Users can work on projects and modify them. I would like to flag the projects which were in previous month report but are not in current month report. For example in report from April I have projects with id 1, 2, 3 and I upload them to Projects table. In May my report contains project with id 3 only, so I upload this report and update the values for project 3. But I would also flag the projects 1 and 2 as removed. Do you have any idea, how can I automate this process in Quickbase? ------------------------------ Piotr Kryszkiewicz ------------------------------Possibility to filter by "# of Records" in report.
Hi, I have two related table. Table A is parent for table B. In table B I have the field "Name". Now I would like to show all the records in table B, where value in "Name" field is identical but related record "A" is different. What I did is: I created chart in table A with "Name" field on x axis and "# of Records" (field calculated by Quickbase, not created by me) on y axis. Now I can see all records with bar value higher than 1 means I have duplicated "Names" in table B. Is there any possibility to use "# of Record" in filters and filter out all records where # of Records < 2? ------------------------------ Piotr Kryszkiewicz ------------------------------Check if record from one table exists in another.
Hello, I am working on application where are two tables (let's name them "A" and "B") with field "Email - work". I would like to prepare the report, for example based on new table "C", which will show how many emails existing in record "B" are missing in table "A". I am looking for solution without reorganizing the tables and creating master table for emails. Is it possible in pipelines to take all emails from table "B", then iterate through emails and check if in table A exists the record with this email, if not add record with that email to the "C" table? ------------------------------ Piotr Kryszkiewicz ------------------------------
