Need to toggle between forms

Question

I have two forms for the same table.&nbsp; One is in English the other in French.&nbsp; Both forms enter the same information in the same fields in the table it is just that one has the questions in English and the other in French.I was doing the switch between the two based on the role.&nbsp; I had a French Branch role that defaulted to the French form.&nbsp; However I now need to set up an Everyone on the Internet user so many others can log in BUT I need some sort of URL button or something that when the click on it they go to the French Form.Any help would be greatly appreciated.

chayceduncan2 · Answer

Its straightforward enough - just set up 2 url buttons - one for each form. Each button would then have a '&dfid=' parameter to toggle back and forth

So lets say:
english form is form id 2
French form is id 10

On your english form - you'd set up a url button like:
URLRoot() & "db/" & [_TABLE_DBID] & "?a=nwr&dfid=10" //to add a new record in the french form

Then on the french form -
URLRoot() & "db/" & [_TABLE_DBID] & "?a=nwr&dfid=2" //to take you back to the english form if they need

Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base

scottervin · Answer

Makes sense but it is not taking the&nbsp;[_TABLE_DBID] in the formula. It is saying it is not identified.&nbsp; Do I use the table id?&nbsp; like ggttfzrxy?a=q&amp;qid=22?a

chayceduncan2 · Answer

Yes - you are correct. I put in the [_TABLE_ID] as an alias. You would use your actual table ID, or Dbid() would work as well

Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base

scottervin · Answer

It would be really slick if the button could be on the dashboard - click for English or click for French

chayceduncan2 · Answer

If you're opening it up to the internet - my assumption is that they're adding a new entry for you then leaving your system. If thats the case - then you can certainly do this. Just pop both URLs into buttons on the dashboard and you're all set.

On your button in a Dash - click on 'Page' and then 'URL' to paste in whatever URL you want - and then do

https://yourrealm.quickbase.com/db/abc123?a=nwr&dfid=10

Make sure you don't just set the button isn't set to just do 'New Record' - you want to actually enter your own URL

Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base

Forum Discussion

Need to toggle between forms

7 Replies

Related Content

Minimum role permission level needed to toggle/adjust notifications

Prevent save a record - New forms

Switch between forms

Form Rule Question

Add child record through parent form and redirect back to parent form in edit mode