Can I use quickbase actions within the same table?
Is there a way to create an action to modify fields in the same table where the action is taking place? For example, when I change the status to XXX, I want the follow up date field to be changed to 45days from the schedule date field.7Views0likes0CommentsTying Fields Together
I have an app with 3 connected tables: When adding a "Permission" to an "Access Group" I can choose/write in a new Department: I want the Department to be tied to the Employee. When I add that employee's name to another Access Group, I want it to auto-populate the "department" field. Also, when I go to the "Employee" table, I would be able to sort by department. Does anyone know how I could do this? Thanks!25Views0likes2CommentsFormula URL - Edit then Add
Hello Everyone, I'm trying to create a single button that will allow our users to add an effective end date to a record on form ID 11 and then when that is saved redirect to the add record api using form ID 10 populated with data from the previous record. Since I haven't been able to get it to work in a single button I created 2 buttons. Indivually both buttons work but combining them isn't. Any ideas? Step 1 code: URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#] &"&dfid=11" & "&rdr=" Step 2 code: URLRoot() & "db/" & Dbid() & "?act=API_GenAddRecordForm&dfid=10" & "&_fid_6=" & [Paragraph] & "&_fid_7=" & [Publication] & "&_fid_8=" & [Description] & "&_fid_11=" & URLEncode([Staff Contact]) & "&_fid_17=" & [Effective End Date] & "&_fid_19=" & [Record ID#] When I combine the code I'm using this URLRoot() & "db\n/" & Dbid() & "?a=er&rid=" & [Record ID#] &"&dfid=11" & "&rdr=" &URLEncode(URLRoot() & "db/" & Dbid() & "?act=API_GenAddRecordForm&dfid=10" & "&_fid_6=" & [Paragraph] & "&_fid_7=" & [Publication] & "&_fid_8=" & [Description] & "&_fid_11=" & URLEncode([Staff Contact]) & "&_fid_17=" & [Effective End Date] & "&_fid_19=" & [Record ID#]) I feel like I need a pause before the & "&rdr=" in the third line as I get an error saying something went wrong. For now I will keep it 2 separate buttons but it would be great to combine them and using the save function on the edit record to trigger the second step.Solved43Views0likes4CommentsLogging causes dynamic rules to not work
I have an approval box that I want to log when and who approved or rejected. When they reject, an email should send and another box should come up to the right of the notes box. I assume because of the log, it is causing my rule to fail? Dynamic rule16Views0likes2CommentsQuickbase and Firefox not working well together?
Does anyone use Firefox? I used to use it exclusively, but after some update (not sure if it was a firefox update or QB update), I have seen a lot of issues. Many GUI issues where the options (grid edit, customize report, etc) simply do not show up on new reports. Also, some reallllllyyy slow loading times. Nothing is consistent (I can't force the issue), but it is consistently weird. I have since switched to Chrome and have had no issues. I am just wondering if others have seen this, and if anyone has pinpointed the issues and figured out how to recreate.3Views0likes0CommentsRename existing entries in a table
Is there an easy way to rename all historical records in a field (similar to a find/replace in Excel)? We've changed the name of a specific group of people: Something along the lines of "reporters" will now be called "reporting party". In addition to changing the text option in the dropdown for newly created records moving forward, is there a way to do find/replace type function within QuickBase for all existing records? I suppose I could export all records, change them in excel and the import them back, but there are a lot of existing records and I'd prefer to do this within QuickBase if possible.22Views0likes2Comments