Forum Widgets
Recent Discussions
Dropdown Choice Update force reselection
Hi all, I have a drop down field with choices for a 'job status'. I've recently refined the list of choices, and I want to know if there's a way to force a user to have to select one of these new choices next time they update the job record. Currently, they can leave the existing status in place and save the record anyway, with the choice highlighting in red in the report. Is there a way to do this? Thanks in advance.
HTTP Request - Body
Hey Y'all. I have a question on how the Body works in the HTTP Pipelines Channel. Before I begin I have everything working and set up correctly (Was able to do it in Postman and was able to do GET Requests in Pipelines) I cannot figure out how to insert my body in HTTP node. I have tried a lot of things to get this to work. I double checked the encoding but maybe there is another option I need to use? I think my problem lies in the to__json Jinja function (If i even need to use it) Any tips are appreciated!! This body I was able to use in Postman and it worked!
Limiting the Ability to add Child Records Based on Drop Down Field Value
I have a two table application and was wondering if there is a way to limit the amount of Child Records that can be added based on the selection of a Drop Down field? When a user opens the form the first thing they are asked is the level of a dealer. Once that vaue is selected is it possible to have a rule that says if dealer level field is say "Gold" "X" amount of child records can be added. Once that limit is met a message is diplayed telling the user the max amount of records has been met or the "Add Another Record" button goes inactive.
Summarize a value in the same table
I'm building a new Table [Daily Time Cards], now trying to calculate for overtime. I built formula fields for week and year number, with the idea that I would query the same table for [Related Team Member] those number fields and only render total hours logged for the week, not on the same Record ID (or blank, since could be the case initially). Example: A user logging time submitted 38 hours previously this week in prior saved time cards. On Friday they have 4 hours to log. The highlighted field should summarize to 38 The formula for the new timecard should calculate 2 hours at regular time, and 2 hours OT I attempted to make this field work with a formula Query, then tried doing a self to self relationship. I think the FQ is the way to go, but I get an error "Expecting Records list but found text list" on GetFieldValues. SumValues( GetFieldValues( GetRecords( "{Related Team Member.EX.'" & [Related Team Member] & "'}" & " AND {Week Of Year.EX." & [Week Of Year] & "}" & " AND {Record ID#.EX.NOT." & [Record ID#] & "}", [_DBID_DAILY_TIME_CARDS] ), 36 ) ) Recommendations are appreciated.
Adding a group to a user role
When I add a group to a user role, Quickbase seems to also add each member of the group indivdually, with the role set to 'None'. This makes my user list twice as long as necessary. When I delete those indivdual user entries, they just reappear the next day. Is this intended behavior? ------------------------------ Mike Tamoush ------------------------------
Delete option
I'm at a loss right now. I have an app and for some reason I'm the only one that can delete from one of the tables. I have checked the roles and they do have the delete option. I have checked the form and it does not have any rules that restrict delete. I as the admin am the only one that can delete. Any ideas on where else I can look. I've looked everywhere that I can think of. FYI: These are the new forms.Relationship Condition Dropdown stopped to work after formula update
Team, I have a challenge to my relationship update. For my relationship I was using "Formula Field" [SMO_Predecessor_Key] which was selected to create conditional dropdown based on its value. [SMO_Predecessor_Key] used in formula another field [SMO CPS Template] which had some logic in it based on field [SMO]. I no longer need this logic so I decided to rewire [SMO_Predecessor_Key] directly to field [SMO]. After I did it I have problem that my Relationship PROXY field does not work in Legacy Form. It ask to choose [SMO_Predecessor_Key] even if this is already selected. I notice that if I re-select value in field [SMO] in form (i.e. remove value, select it again, even without saving, this starts to work. So problem is with data which are already filled in. [QUESTION] - is there a way to force such refresh to all records and to not need to do it 1 by 1 in form? What I tried: I tried to Import records ID# and field SMO but during Import No update to records (as SMO does not change). Tried to create new field [SMO_Predecessor_Keyv2] and update Conditional Value to it and back. But not working as well. This is how dependency of fields looks line (Blue changed to Green) Current workaround but not well seen by users 😢
