Pinned Discussions
Forum Widgets
Recent Discussions
Using pipelines to log the date/time including the seconds of a record change
I have a pipeline that logs when a record was changed in a tracker table. I need the date/time of the change to be accurate to the second. I can't have a pipeline copy the Date Modified of the source record to a Date/Time field in the status change record as we would lose the seconds. I can't use the Date Created of the record created by the pipeline as this and the user's action are offset by a second or two. I need this to be when the user made the change, not when the pipeline created the record. I created a Formula - Date/Time field in the source table that is ToUnixTime([Date Modified]), then the pipeline copies that to a Number field in the status change record. This works, however I'm in search of a more elegant solution than creating a formula field in every table that needs this. Is there a Jinja expression that will give me the ToUnixTime() of Date Modified without having to create a formula field?Solved0likes1CommentNeed help deciding between two db setups
I am pretty new to qb and am currently trying to create an app to help my department track a student's requested thesis committee. The (hopeful) process: student will submit form with their identifying info, proposed thesis title, then choose their requested thesis supervisor, and selected reader, both fields pull from the same list of faculty (though if someone is chosen in one field they will not appear in list in 2nd field - that's for another time to figure out). So in trying to build something I came up with two different setups and am wondering which people think would be best. Which do you think will be better longterm. Attached are screenshots of both relationship diagrams. Hopefully they are decipherable.Solved0likes8CommentsHelp with Lookup Fields from Multiple Parent Tables in Quickbase Form
Hello, I have a Quickbase app where a single child table is connected to three separate parent tables. Each parent table represents a different employee group, and the child table is set up to pull employee information from all three. In the form for the child table, I want to be able to look up and select employees from any of the three parent tables. However, I can only select from the first parent table I connected—its lookup field is active. The lookup fields for the other two parent tables appear grayed out and are not selectable, even though they are all connected in the same way, using the employee name as a lookup field. As shown in the screenshot, only the first table’s name field is selectable, while the others are disabled. What might be causing this behavior, and how can I make all three lookup fields usable in the form? Thank you!Solved0likes3CommentsCant See Associated Records
Hi i table 1 app - 3 tables, table 1, table 2, table 3 now i have relation of one to many from table 1 to table 3. this relationship is old and has been working fine but suddenly i cant see the associated records from table 3 at the end of the record in table 1. they use to populate properly earlier. i have not changed anything in the relationship, cant understand why getting this error, it says " sorry...error retreiving data Attached the image as well. Only thing i can think of is another admin, was asked to delete all the unwanted reports so he may have deleted the associated report from table 3. if yes, how can i recreate the same. ? or any other reason for this problem.Solved0likes5CommentsAccess Issues
I have a 1 app - and 1 table. there are 5 users all the users have access to all the fields on the form on the table to view or edit the fields in the own record. So permission is view and modify all fields. and record level restriction is where owner is the logged in user. There is record level resctriction so user 1 cannot see user 2 records. i want to make a report where all the users can view all the records 5 particular fields. but cant view or modify the record of other users. However i want to create a visibility report to show all records from today to all the users but only a few limited fields. I have created the report, disable view and edit to the records and given all records access to the user. But the problem is if the user 1 will do advance search randomly, they can view all records from default search results. If I restrict that then no user will be able to open the records from the search which will be a blocker. how do i get past this ? if i restrict field level then they wont be able to enter or modify their own records as well. so cant do that. how to achieve this?Solved0likes9CommentsCreate child records from Parent List - User field
I have a List - User field called "Leads" in Property table and want to build an automation to create individual record in another table called "Team Role", so that users added to Leads field can be displayed in a table row. The search pipeline step allows creation of record for the first user added to the list, but skips the other values from the List - User. If there is any alternate approach for this, please let me know.Solved0likes3Commentsblock admin console access without denying
I do not want users assigned a "viewer" role or "participant" role to be able to have access to the Admin Console. *My Apps - Account Admin Manage my account - Admin Console I would like "admin" role to be able to share app with users but also not be able to access the Admin Console. I do not want to "Deny" users because I want them to have access to log in to the app and use it, I just do not want everyone seeing the Admin Console information. Is this possible?Solved0likes1Commentexpose the User ID in a report
Jim! ToText(UserToId( [QB Username])) Is anyone using a QB Formula field to display the user id to users in a report? The User Id looks like this "51817980.d2k9" (I changed this to something madeup, apologies if its your id.) I have the admin console connected table and can sync the used id value to any app I want, which is my backup plan. Before I make that change I am checking to see if there is something I missed. Use case: We have users added to an App via a default role in a Group provisioned via SCIM. Some users may need to have an elevated Role other than the default Role. Currently the elevation is indicated by app data managers checking a box on a record. The check box indicates these users require an elevated role change. When users requiring access to the elevated role are indicated, someone has to compare the record in the table and the role in the users table and align or normalize the values ~ that someone also has to be knowledgeable about the process. I have found several Give Feedback where we have asked for the Role and linked them all together in hopes of clarity. If this is something you want too open Give Feedback and search for Role.Solved0likes1CommentQrew Meetups all Cancelled
EstherLaVielle bsimon_personal Second day in a row, I opened the calendar event in Outlook and logged on to the Zoom meeting. There were about 10 people in the room waiting for the meeting to start. Since it just happened yesterday I asked, "is Esther on this meeting?" LauraT said "no" and so I did what Esther said and went to the Events page and looked for Pipelines. I did not notice the date had changed, it took me back to the same event. Oh I guess the event date changed. I have now deleted all my Outlook calendar events. I guess this means I have to come to the Events page on a regular basis and check to see if anything has changed. IMO this new Meeting method adds Grey work and reduces value for the customer. My advice, if there is interest, is to make a plan and stick to it.Solved0likes2Comments