DanialAsghar
Qrew Trainee
Joined 7 years ago
User Profile
User Widgets
Contributions
Re: Recurring Automation based on conditional logic
What I was thinking of doing was creating an Automation that ran on a schedule (create one for weekly and one for monthly) and set the actions to create new record in the table with the relevant information in the task. My issue with this approach is that I can't set any other IF conditions on the trigger... I want to run this schedule only if the recurring status of the source table is true but cant seem to find anywhere to add more triggers if its time based.15Views0likes0CommentsRecurring Automation based on conditional logic
Hello, So I have recently discovered Automatons and it definitely solves half of my problem but I cant seem to figure out the rest. Scenario: We have a PO table and a Tasks table. In POs a type of them are recurring with a active/inactive status with specific schedules (monthly, yearly, etc) and a user selector for documents responsibility. What I want to do is create some sort of Automation whereby if a PO is recurring, based on the schedule, it will automatically create a task for the user responsible every month (or year, etc) while the recurring status is active. My original thoughts were to run an Automation and run a formula at the end but I couldnt find any way of adding in a formula; and cant figure it out using the existing commands. Any help would be appreciated!20Views1like3CommentsButton with conditional logic
Hello, We have a PO system made using Quickbase which currently has different statuses. Currently our implementation uses form dynamic rules check which status the PO currently has... then it creates a Button using the following which will change its status to awaiting confirmation: var text URLONE = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#] & "&_fid_33=" & URLEncode("Awaiting Confirmation of receipt of goods 2")... The second rule checkes the Button if the second status is enabled and if so it creates a button to change the status to one of the other statuses. I am trying to make the code more refined by having creating a button which has conditional logic built in so instead of having 2 buttons, we can just have one.... Can anyone help guide me on how I can do that. Effectively on the form load I want the button to check which status it is in, then if status 4 show that button, if status 4.1 show that button and otherwise dont show a button at all... Thank you!63Views1like2Comments