Hello friends,
I am almost in goal with my app now, just 1 last thing remaining before it works as it should.
I have a maintable (Inspection table) , with a ref to a subtable. The subtable is โBedroomโ, and contains all collums needed for bedroom.
My problem is that when i make an entry from inspections table โBedroom 1โ โBedroom2โ will show. But then when i make a new entry in inspections table, those two will still be there from the prevous entry. Anyone know how i can connect the Inspection entry together with those specific Bedroom Entries?
Here is praveens answer for a solution, but i havnt manage to get it to work properlyโฆ I used a Concentate formula with UniqueID and BedroomID (Bedroom 1, Bedroom 2, etc) But then when i put in bathroom 2, bathroom 1 no longer showed in the inspections table after.
โSo try to get this to work first for just Inspections and Bedrooms. The Bedroom table should have a Ref column (letโs call it Inspection) to the Inspections table. Automatically, each time you add an Inspection, youโll get the option to add multiple Bedrooms. Each Bedroom row must have a unique key value. I would recommend that you have an Enum column called BedroomId with values Bedroom1, Bedroom2, etc. Then add a composite key for the Bedrooms table that is CONCATENATE([BedroomId], โ:โ, [Inspection])โ
Help is most appriciated Have a nice weekend!
Is it possible that you have the reference in a wrong way? Do you have a ref type column in your Bedroom table? And that ref fieldโs option โReferencedTableNameโ is your โInspection tableโ?
I might of haveโฆ >:P
The reference to the other table is like this:
The Inspection table has a collum called โBedroomโ. And in the same google sheet i have a sheet tab called Bedroom, thats how it referenced. I dont know if this is correct?
Thank you aleksi for answer.
I will create a sample so you could find out the structure.
That would be amazingly amazing if you couldโฆ would be very gratefull for that. Thank you Aleksi!!
It should be in your email
Thank you Aleksi, i will go trough all of the information and see if i can make it work. This is more than helpfull!!!
Amazing support and help by the Appsheet team. Thank you for the help!
Okayโฆ the order is not correct. Remove that Bedroom field and add a column InspectionID into the Bedroom table. That would be a ref column to your Inspection table.
Hmm. i tried that now. And then it doesnt make any connections.
My app is like this;
When i have a checkout of an apartment, i
will check Bathrooms, Kitchen, bedrooms etc.
Each room must have specific collums that i need to check, for example walls, floor, doors, kabinets, lamps, etc. This will vary on what kind of room it is.
For this i have:
I have 1 table named โInspectionsโ - Here i want all the records for inspections.
Then i have a worksheet that is named
โBedroomโ With all the collums required for me to do a inspection in the bedroom.
Sorry i never worked with this ref collums, and difficult. Thank you for taking time to help Aleksi.
What is your app name and account ID? I can check the app if thatโs okay for you.
thank you sir. name is
Bedrift 193436
the tabs are Inspeksjon and Soverom (bedroom)
May I ask this firstโฆ I believe you are inspecting more than just bedrooms. In your Enum field you have Bedroom1, Bedroom2 etc. Would it be possible to add other rooms with the same table so you wonโt need to add tables for every type of rooms? Are you able to handdle all types with the same form/fields?
And btwโฆ Norway is not far a way from Finland
I need to have different collums for different rooms, because different things i need to check.
My plan was to have 1 main table (Inspection) and then 1 table for bedroom, 1 table for Kitchen, 1 table for livingroom etcโฆ Idk if that is a good idea? That way i can have multiple of each rooms if needed.
Thank you again for answer Aleksi
My idea was that you could just add few options into that Enum list like Bedroom, Living room, Kitchen etc. If thatโs not a key column, you can add as many bedrooms as you need. If you group the Inline view, you would see them separately on Inspection detail view. Would it be possible for your workflow?
But would that make 1 report in the inspection table? The idea was that when you ref a collum, it will give the possibility for โnewโ entry. But idk if that is possible. maybe same as u suggest? The picture show how i wish it to be, but its currently not functioning, as the entrys in โsoveromโ would not connect with the main table, and would still be there when i make a new entry in the main table.
User | Count |
---|---|
40 | |
36 | |
33 | |
23 | |
17 |