Getting parent records to be related to multiple child record
There is a Master Copy and the Master Copy has a multi select with the master SOP names. I have a document storage app which has a table named Manuals and a table named Supporting Documents. Each has a File Attachment field of the same name. Each Manual has multiple Supporting Documents. This is handled by a standard one to many relationship. I found out today that each Supporting Document could potentially ?support? multiple Manuals. This could be handled by simply uploading the Supporting Document file multiple times, each record being related to a different Manual. Due to storage space and modifications of files I do not want multiple Supporting Document records that contain the same file attachment. I tried to use a multi-select field in the Supporting Documents table that would check off the multiple Manuals, and through a report link field link the Supporting Document to the Manual records. This won?t work because there are over 250 Manual records, and the Multi-select can only handle 100 values and 20 selections. Otherwise it would have worked. I could create a regular text field and manually type in the names of the Manuals that the Supporting Document supports, but I don?t want to do that either. What?s the cleanest way to get one Supporting Document to be able to be related to multiple Manuals?
Mailto showing html formatting in Outlook
Hi everyone, I have a formula url with the following code: "mailto:" & [External Email Addresses] & "?subject=" & URLEncode([Email Subject]) & "&body=" & URLEncode([Email Body]) & "&cc=" & URLEncode([Internal Email List]) The Email Body field is Rich Text Field in Quick Base. When I click on the button with sample data I get the results on the two screenshots included. Any ideas on how to prevent the html from showing? ------------------------------ Ivan Weiss ------------------------------
Hiding Tables in Table Bar
I hide many of my tables from most user roles. However, when I add a new table it defaults to be visible, and I have to manually go through each role and hide the table. Is it possible to default to hide, or to go to the table itself and choose that option? In the table settings, I know I can set access per role, but only permissions, I don't see user interface. Can the user interface per role be set from the table settings? ------------------------------ Mike Tamoush ------------------------------Capture date modified if reference field changes
Hi Everyone , I am currently in a project where i need to give data changes which has happened from past 1 week . Initially it looked easy as we have date modified in each and every table. But the catch is in almost every table there are reference field ( table to table relationship) . If those column changes then the reference table date modified does not change. For Eg . If in Table A , table B is being referenced the changes happens in table B get reflected to table A but date modified does not change. Any advise please
User Lookup Fields Display in Red - WHY??
Does anyone know why my users listed in my list-user field that is a lookup from another table display in red? Usually the red means the selection is not a valid option, but since this is a lookup field, that shouldn't apply. I noticed this a long time ago in a different app and it's always bugged me, but when it just came up again, I had to ask! Thanks! ------------------------------ Brittany Zane ------------------------------
Removing Add New button from table home page
Is it possible to remove the green "Add New" on a table home page? I don't want to take away the privilege all together, but more so force a user to create new records in that table using "Add New" buttons created within other tables and reports. ------------------------------ Chris Swirtz ------------------------------Copy an address
If I have a lookup field that is an address, can I use a button to copy that field to another address field? Or do I need to look up each component (street, city, state, zip, etc) and then copy each component to each corresponding component? ------------------------------ Mike Tamoush ------------------------------
