Lookup
Hi. I have two tables: Table A: "Field1" Character Unique "Field2" Numeric not unique etc... TableB: "Field1" Character Not unique "Field2" Numeric Not unique etc... Naturally the two fields in table A together form a unique key. The two fields in TableB together form a unique key. I wish to create a view where using the two fields in table A the required row is read off table B. TableB has a whole set of identical "Field1" rows and the value of "Field2" indicates which row is required. This is a
Open a record-summary with an openurl statement?
Is it possible to open a record-summary with an openurl statement? I would like to do this from a decision box on a form. I want it to popup over the form and when it is closed come back to the form. Is it possible to automatically bypass the browser from blocking this as a popup?
how to localize system menu?
hi need localize system menu.
Mail merge from filtered list
Hi. I have a database that records pallets in and out of our warehouse. I need to create a mail merge or other method of printing pallet labels which contain some of the fields for each record in a filtered list. Ideally I need to create an A4 label for each record which print when selected without the need to export the data to .csv files and merge with another office program. Can this be done from within Zoho Creator. Thanks.
Calculate number of marked responses in a form
Hi I am trying to find a quick way to automatically calculate the number of responses a user marks (true/ correct) on a form and then calculate the overall percentage score. Below is an example. I am using the decision boxes where the user will mark each response they feel is true. Any ideas would be appreciated. Ian
MultiLine Field in Pivot Tbl
Hi, would like to create a Pivot report which will include 2 MulitLine Fields/TextAreas, however, I am only able to use 1 multiline field in my Pivot report. Thank you.
Image in html view using publish url
Hi, I have one HTML page name is Welcome and one report name is Image Report. I want to fetch the image from Image report and displayed in Welcome page. Finally i want to embed Welcome page in my website. how to get a image src link in (Image report) publish url? Thanks Satya NHM
Delete record from a Form and Insert the deleted record to another form
Hi, I am trying to figure out script that delete a record from FormA and insert the same deleted record to another formB Below is sample what I am using to delete the record if (input.Update_Sub01 != null) { if (chan_count1 < 1) { delete from Chanel_Database[ (CD_tvId == input.Update_TVID && CD_channel_NO == input.Update_channelNo01)]; } } I want to insert the above deleted record to another form - FormB Could anyone please help me ? Thanks Arfater
Change dynamically radio button values in a subform which are related to a lookup field
Dear All, I have the following subform which consists of a lookup field (Excursions) and a radio button (Radio). The excursions are loaded in the on load action when I open the form. I would like when I select the Radio (Full Day in that case) in the 1st row then to show the 'Full Day' automatically in the 2nd row (because they have the same Excursions Selection). When I select 'Half Day' in the 3rd row then to show 'Half Day' in the following 2 rows (4th-5th) etc. In other words, if I have the same
how to localize buttons?
hi just made localized text on buttons in form. but when open entry - there is text in english how to localize it correctly?
Verify Records exist in one form that are in another form
I want to verify that records exist in more than one form. FormA and FormB I want to verify that records exist in FormA that are in FormB ( I would like to count the number of records not in FormA)
Drop down list - auto fill other text field
Hi Sorry - I think I have already posted this question in the incorrect area on the forum. My question is: I have 2 forms - Form 1 - 'Memorial Branch Details' Fields: - Branch Name - Email address - Telephone number Form 2 - 'Warehouse list' In this form I want to have a drop down list which contains the various 'Branch Names' from Form 1. Once the 'Branch Name' has been selected, I would like a text box in Form 2 to auto fill the corresponding branch email
Disable subform fields one by one
Dear All, I would like to ask you if it is possible via deluge code to disable only some fields - cells in a subform. In the following example I would like to disable the fields one by one. Is it possible? If yes, do you have a short example to show me?
Two time stamps in a single form
I am looking for a way to measure the amount of time it takes for a user to complete a form, where the user can start and stop the clock. I see this working as having 2 time stamps and a 3rd calculation field Step 1 - Time stamp 1 - Record Start Time Step 2 - Time stamp 2 - Record End Time Step 3 - Formula Calculation - Time taken ( End time minus Start time) is this possible using the current creator functions?
insert new record based on data called in a subform
Have a button on a subform, and when I select it I want to insert a new record into a separate form. I am having trouble.
Error while inserting data
Hi, I'm trying to add data from Form A to Form B, I have added the script in Form A "on edit - on success". Form name explanation: Form A = To_Do_Form url - https://creator.zoho.com/appbuilder/piju2111/penta-crm-11/form/To_Do_Form/workflow/edit Form B = P_L url https://creator.zoho.com/appbuilder/piju2111/penta-crm-11/form/P_L/Sales_Ticket/workflow/edit Script in Form A: insert into P_L [ Purchase_Date = input.Closed_Date Purchase_Ticket = input.Ticket_No
How to get IOS data for a single contact into a ZC client form
In many cases the basic date already exists as a Contact in in the IOS Contacts app. Is there any way now with the new Apple extensions to transfer the contact data directly into the ZC client form? For example the app Docusign can now immediately access the IOS contact on the Ipad and use the data. This is very very useful and eliminates constant duplication of data entry.
Custom filter - filter records older than a specified time
Hi I am sure that there is a very simple answer to this - I just can't seem to figure it out! I want to create a custom filter that will display all records in my database that are older than 6 months. What is the best way to do this? Ideally I would like to set up a number of filters, so that I can show; - records that have been in the database for 6-12 weeks - records that have been in the database for 12-18 weeks - records that have been in the database for 18-24 weeks Any help
Get Zoho Support Record by ID
Hi, I have to build a scheduled task to get a record from Zoho Support and check its ticket status on a periodic basis. I can use zoho.support.getRecords(), but it returns multiple records which is not what I need. Is there a function I can use to fetch a single Zoho Support record by id that is equivalent to Zoho CRM integration function zoho.crm.getRecordById()? Thank you.
Concatenating 2 fields from different tables and showing them?
Hi there I have Contact Header (eg; Companies) and Contacts (people working at that company) = so far that is good. I then want a Leads/Projects that is linked to Contacts. So ideally I'd like to be able to see a list of Contacts and Companies for the user to select from. Example: (Contacts combined with Companies) Abby (Internet Spotters) Tony (Freds Emporium) Will (Angus Traders) So when the user creates a new Project then the user would auto-type/select from a drop down list of Contacts. The reason
Error in script when sending emails
Hi my script has always worked but now I was trying to modify it and I could not save the new script. I got this error message: In cases where From: address is not a zoho.adminuserid or zoho.loginuserid, the To: address can only be zoho.adminuserid and the sendmail task cannot have any CC: or BCC: address. The script sends an email from the address of a specific Zoho user (USER@rossatogroup.com) according to the selected county ("Provincia") in the form. Each county ("Provincia") is associated to
consecultive date entry in subform
dear all, I created a sub-form for people to input their working/education experience. Since it is required to have a consecutive date record, so we have to make sure the "start date" in the next entry are one day after the "end date" in previous entry. for example. the "end date" in first record is 20/01/2001, then the "start date" in second record must be 21/01/2001. I am not sure if in zoho can do coding on it and realize it. If anyone can shed some lights that would be much appreciated thanks
Update more than one selected records ?
Hi experts, How to update Status = "Paid" where Invoice_No = "test" ? BTW, I managed to update 1 instead of 3 records using the script below: Please advise, many thanks. :) // Assume rec = "test" rec = Invoice[ID == input.Invoice].Invoice_No; for each sel in Delivery_Order[Invoice_No == rec] { UpdateStatus = Delivery_Order[Invoice_No == rec]; UpdateStatus.Status="Paid"; } Delivery_Order
Drop Downs
I made a drop down box with 3 choices to pick from. Each of the 3 choices has drop downs to choice from. I don't want to show the other 2 choice drop downs. Example This is under the drop down called Equipment. If I remove the 2nd IF statement. It works like it should. if ( (input.Equipment == input.Tractor) ) { } show Tractor; if ( (input.Equipment == input.Harvester) ) { } show Harvester
Mail Merge with Creator
Hi I am very new to Zoho Creator. We are looking to use Creator to store a database of information. We wanted to be able to use this information in a Word mail merge. Specifically to print labels and create documents that use specific information from individual records. Is this possible? Thank you.
Update data from multi check List
Please see the explanation below: 1. Select "Supplier 1" from dropdown list. 2. Select 3 records which are DO0003, DO0004 and DO0005 (Lookup from Delivery Order Table). 3. Click Submit. 4. How to update the status from "Pending" to "Ready" for the selected records which are DO0003, DO0004 and DO0005 ?
how to close a stateless form
I have a stateless form that popups up on a condition. one of the buttons is to close the form. it dose not close. what am I missing.. openUrl("#Script:dialog.close", "same window");
OT - Creator is really good - but not well explained... (not complaining as such)
I do really like Creator and it has a lot of depth but some of it is quite buried. This is not a complaint - just a concern. Example; the "Pages" can (if I knew) really customise the look / feel of an application and I have been reading through the documentation and I think it is all there - but just a case of working through it all... I mean in Pages there is a little tiny icon in the upper right where it shows all the fields you can embed into your page. And in Reports there is a whole report writer
Can you change a selection of dropdown list to affect another?
I am creating a School List, and when i select a certain school i want a second drop to give me the name of the classrooms at that school. For Example: i choose Diamond Elementary i want the second drop down to give me AM and PM selection but if i choose Lincoln i want it to give me the selection of 12AM, 12PM and 15AM, 15PM is that possible?
drop downs
I have a drop down that has Tractors and Harvesters for a choice. When they pick tractors. Then I show the tractor drop down. That works fine. But when they pick harvesters. It then shows the tractor drop down list. I used script build on the main drop down called eguipment. If they only pick tractors I can make that work. But when I add the Harvester then it shows both drop downs with tractor disable. Please help if ( (input.Equipment == input.Tractor) ) { } show Tractor; if ( (input.Equipment
Reports disappeared from Creator iPhone app
Very strange the other day when loading up the ZC app to discover that all but the form and one report had vanished from the app menu. They're all there when logging on to the web version and am wondering if anyone else has encountered this problem or has an answer to the problem?!
How do I populate an email by clicking a URL in a mobile view
I would like users of the mobile version of my application to be able to click a link within a record that invokes an email to be sent to pre-selected email addresses and includes inputs from the record in the body of the email. Example: A record is created by an administrator that represents one step from a checklist describing how to install software. In that record, 4 contacts with email addresses are assigned using a multiselect lookup dropdown. They are support personnel for that step. A user
HTML special Characters
Hi All, I want to include the up arrow ↑ and down arrow ↓ html special characters as part of a text string for a field value. However, when I try to add the html entity name, the string just shows the characters and not the symbol. Perhaps special characters are not supported in field values? Thanks in advance for any help.
Deluge script
Hi I am new to creator and deluge script and would like some guidance. I am trying to create a rule that automatically enters a defined value in a field based on users selection. The User selects a measure The required volume field is populated. Any help would be appreciated.
Sendmail Custom Action
Hi All, I'm very new to Zoho and coding in general. I'm looking to create a custom action that will allow the user to select a record or multiple records and email it to an email address they specify (or at least to themselves if that's not possible). Is this possible? Can I email the record using a record summary template? Tim
Schedule Report Not Showing Images
How can I get images to show on a scheduled report? I have selected a report as an attachment on a daily schedule. It is only showing hyperlink addresses. I have shared and published the report and associated reports. Is this not possible? I need to get this fixed ASAP.
How can I put a message on a screen that is dependent on the combination my form inputs
I'm struggling to create my first application and would appreciate some guidance. I want o create a small 'expert system' that displays a different answer based on different combinations on inputs. I can create an entry form easily enough. But I'm lost to know what to do next? thanks
Pivot chart creation
Hi, Is there any way to make the following chart from Zoho Creator? . Thanks Satya NHM
Hide/Show Logic for Form Buttons in Stateless Forms
I've come across a number of situations with stateless forms where it sure would simplify things to have hide/show logic for the submit button. Essentially this takes the place of form validation rules for a full form. Cheers, John Whitney
Radio or Dropdown for number
Hi. i would like to gather public opinion by providing radio or dropdown button and in the end it sum up their feed to give feedback. But the problem is the radio is string only. How do i performance mathematic to the feedback. Thanks
Next Page