A form button that will force record add on a specific form.
I have a tasks table, but I want to allow users to enter simple tasks or complex tasks. One form for simple tasks and another for complex tasks. This works for complex tasks and is the default form for all roles. URLRoot() & "db/" & [_DBID_TASKS] & "?a=API_GenAddRecordForm&_fid_145=" & URLEncode ([Project Number])& "&z=" & Rurl() I am trying this one for simple tasks, but it still loads the complex tasks form (ID=11) even though the URL says form ID 16. URLRoot() & "db/" & [_DBID_TASKS] & "?a=API_GenAddRecordForm&_fid_16=" & URLEncode ([Project Number])& "&z=" & Rurl() Also, this latter one is not loading the related project like the first one does. There has to be a simple way to load form 16 even though it is not the default for all roles.
Time Zone change
Good morning, I am building a Transportation application for my team to use. When we request a pickup time from our transportation vendor, it is always in central time since we are based in Texas. Can QB convert the central time to local time based on my selected city? For example, I have an employee who needs to be picked up at LAX at 10 a.m. Pacific time, but we can only enter 12 p.m. Central time. How can I build a formula in QB that will convert noon central to 10 AM when I select LAX as a city? The same goes for all the cities we service. How can I make sure Daylight savings are accounted for? I have attached a spreadsheet of the cities we service regarding their summer and winter times.
QR Code to form
I am trying to Make a QR Code Using the quickchart.io formula I have made one that will take me to the inventory part. Is it possible to have it take me directly to making child record ( Inventory Usage ) form for that record??? its setup as Inventory > Inventory Usage i would like to have a binder with all the parts that can be scanned to "Check out" the part(s) and take the user directly to the form so they can deplete the inventory. Any help on this would be greatly appreciated.Generate a number
Hello I would like to make a unit number self generate Example 1000-(001,002,003) as more records are created.. is there a way to do this function? where it will generate the unit number based off the last record? Im a still pretty new to QB. Do I need to make the first record from there then ref that field in the max ID and add +1 to it?
Formula help with multiple choices
I thought I saved the one I added so if this is duplicate I apologize, I could not find my original. I want to have a formula field that says this but the , between Pacific Dunes 2 and [#of people in party}+1*9.63 is turning yellow and I have tried ( ) and,, but I can't get this to work. It tells me its expecting a comma If(Contains([Salesroom]="Pacific Dunes 1","Pacific Dunes 2", [# of people in party]+1*9.63) What I would ultimately like is If(Contains([Salesroom]="Pacific Dunes 1","Pacific Dunes 2", and GSlandsend [# of people in party]+1*9.63) or If[Saleroom]="Playa Grande" [#ofpeopleinparty]+1*7.81) that way I only have to have one field instead of 3 fields - I have two of the fields working like this If(([Salesroom])="GS Landsend", [# of people in party]+1*9.63) But as soon as I add more salesroom it doesn't like it Thank you so much Edit I was wrong its not even multiplying correctly so there is something wrong in the *9.63 or *7.81 Example - column # of people 3 and then plus 1 would be 28.89 but its coming out a weird number of 11.63 ?? I actually got it to add correctly by If(([Salesroom])="GS Landsend", [# of people in party]*9.63)+9.63