Forum Widgets
Recent Discussions
Looking for Date/Time Field 1 = Date/Time Field 2 pipeline jinja
I begin with one trigger step and in the next step I need to filter records to match date time fields in both tables. My workaround is the native "is on date" filter but it would be best if I could include the timestamp portions of the field. Is there a way to format jinja to accomplish this? I've tried several variations but here is an example of one. {% if a.pull_date == b.pull_date %} {{"TRUE"}} {% else %} {{"FALSE"}} {% endif %}
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!
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.
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.
