Edit data on stateless connected forms
Hi, I have five forms connected using Stateless Master form. I am able to submit the data on all the forms and submit it. Now, how can i make the data submitted on Form 1 be editable if i navigate to Form 1 from Form 2 using the "Next" "Previous" functionality. Is there a way i can autopopulate the Form 1 using some ID? Also note that I have not yet completely submitted the entire application (from Form 5). Thank you.
Assign unique identifier from pool of identifiers across different forms
I'm setting up a title database for a publisher. It was originally set up in Filemaker. There's one form with information about each title (title, subtitle, series name, series number etc) and I need to assign multiple ISBNs (identification number) to each title depending on format (hardback, paperback, ebook, audio etc). I've got hundreds of ISBNs in a CSV to import, so I put these into one form. The title information is in another. I tried assigning them with a lookup, but have run into issues
App auto-refresh
i have created an App which i would like to share between 5 users. the thing is that i would like the dashboard to auto-refresh every 5 to 10 seconds to make sure that all users are synchronised with no delays. how can i do this ?
Share data on the web
Hi, I have a fairly simple database in Access that is for my family - total family members 200. It contains names, addresses, phone numbers, birthdates, divorced, etc.. I would like for family members to search the database - read only, but be able to edit their own record. Although there are 200 people I would doubt that more than 50 would ever use it to edit. I have also been learning Filemaker but I am not seeing how to do that without paying a lot of money. Is there a way to do this with with
Get Drop Down List From Zoho CRM with matching condition
Getting this option value based on matching condition from zoho crm account records Some thing like this <select> <option value="account_id1">account_name</option> <option value="account_id2">account_name</option> <option value="account_id3">account_name</option> </select> Here my code getSupplierRecords = zoho.crm.getRecords("Accounts"); for each getSupplierRecord in getSupplierRecords { if(getSupplierRecord.get("Tipo de Entidade") == "Fornecedor") { input.Select_Supplier:ui.add(getSupplierRecord.get("Account
if null use another field
Hello, I currently have a formula with the expression - ((Sale_Price - Estimated_UK_Price - Estimated_Cost_of_Work) / 1.2) What I would like to do is if 'Estimated_UK_Price' = NULL then use field 'UK_Landed_Cost' Is this possible? Thanks
add subtotal to currency
hey guys i have a form that i need a total box at thr bottom and need it to add each of the other currency boxes. what i have is all our denominations for instance $100 $50 $ 20 etc and when i type how much we need of each i want there to be a running total at the bottom how do i do this please
Unable to add fields in a form.
Hi. I evaluating Zoho Creator for our use and while trying to build a form I am unable to add more fields to the form. The editor stays stuck with just a message saying "Adding...". I doubled check my internet connection and everything on my end looks fine. I've attached the screenshot with this message here. it'd be really useful if someone can point me in the right direction. Thanks...
Multipage forms
Hi Guys, I'm try to make some multipage forms, but could really use an example. There is a sample app at: https://creator.zoho.com/sampleapps/next-previous/#View:All_Data Could you please share this app so that I can import it into my account and look at the backend scripting? Thank you so much!
How to create scheduled push notification?
Hi everyone, I want to get the number of new records every hour in the phone notification bar. But I can't find a way to do it. Can someone tell me how doing it? Thanks.
Please Help with add new formВ from lookup field in formA
I have bideraction lookup with FormA and FormB. And want to add new FormB from lookup field in formA. After saving (or when i creating it), i want to fill some field. I use script (in formB) on Add --> on Success: "docs = FormA [ FormB == input.ID ]; for each rec in docs { insert into addSprava [ promizhnuyRezult = rec.sender_field ] }" But it doesn't work. Please help me with this issue.
Temperature Probe Integration into Zoho Creator
As anyone used zoho creator to integrate temperature readings from a wireless temperature probe into a zoho creator application. I have developed a Food Safety reporting system and I am looking to use a wireless probe to check temperatures and display in the application
Graphs Based on zoho.loginuser
Hello all, Is zoho.loginuser available anywhere for graph reports. I know that it is possible to add a criteria for a regular report (list), but I don't see it anywhere for graphs. Again, I want all users to see graphs, but only for records assigned to them. Lastly, they are NOT record creators, but only record owners. Any help would be appreciated. Thank you. Cheers, David Bergaz
How to setup a document workflow that requires more than one validation?
Hello, I´m building an invoice validation app and i would like to to know what is the best practice to setup the system, that needs to support, for example, two users to validate the same invoice/record, because only when the two validate, the invoice status changes to payment ready. Any help? Thank you.
newbie help - Solved
Hi This is my first day trying to learn Zoho, I've got a good database going for our volunteer group for Search and Rescue but I'm beating my head against a wall with the Workflow Scripts. I can get Zoho to send a message on "update" with a single message such as "Test" but I want it to show the updated records in the email. I did the tutorial and I though i was suppose to use the 'info" expression but it always tells me I'm missing a ; or the expression is incomplete. Can anyone just give a pointer
Add a button in CRM/Case to create a new Work Order(my app in creator)
Maybe I am doing this wrong as I am new to doing this but this is what I am trying to accomplish. I want to create a Work Order (I have created it it Creator. Should I add it as a module in CRM?) We are a field service company and want need to have a customer Work Order. I want create the work order from a case. When it is created I would like the case number, account, contact and other fields that I may need. I would love to know how to do this and the best way to do so. Thank you so much in advance!!!!!
Adding multiple records - Zoho Creator
Hi, I want to give option to my user to add multiple records and the same to be printed which I am trying to achieve using Record Summary. I tried to add Sub-form and give option for user to add multiple records. When I tried to print it using record summary, it is merging the fields into one sub-form and print it than showing one block after another. Attached the sample fyr. Kindly let me know how to address this. Regards Janaki
How to create a consolidated stock report?
I have Product form with Product Name, SKU and Unit. I have Stock form with Product, Warehouse, Stock.The stock form will have stock for each warehouse like this. Product Warehouse Stock A W1 10 A W2 20 B W1 1 B W2 10 I need to generate a consolidated stock report showing the sum of all stocks for each product. Product Name Sku Stock Unit A AX1
how to fetch data from the uploaded file?
Hi, I want to access the data which is present inside the file uploaded in the form. I want to fetch the data from the uploaded file (say the uploaded file is the excel sheet contains 100 records) and insert it into the another form. thanks
Development landscape
If I am developing apps for a client , how do I deal with the system landscape? How do I make changes from the development instance to the production instance? Where can I get this kind of information and training ? Thanks.
Select records based on value in a multiselect list field
Is there a way to filter records in a count() statement by searching for an integer ID value in a multiselect field? Zoho is giving me trouble on this. Here's the use case: - Form "Asset" has a multiselect lookup field, "Tags", that holds record ID values from a related form, "Tag_List". Various string tags can be assigned to each Asset to describe it, e.g. Asset "Sales brochure" might get tags "sales" and "collateral". The Tag_List form is the master list of all tags. - I want to create a simple
How To Create Report Based on User Selection?
Hi All I have a report that shows all the products added. I want to make it so a user can select all the products they want via the checkboxes (see screenshot) Then click a button that says "generate report/page" and have it display all the selected products on a temporary report/page (see 2nd attachment) which they can then save/print. How would I go about doing this? Thanks
Record Summary - long process to get the print screen
Hi, When once the design is done in Record Summary is there a way I can introduce it to the end user with just one click and the button takes to the record summary. Right now what I am doing is, I am entering the data. Then go to the reports. Click on a record - > Print as -> Record Summary - > print or pdf Also I want to save the document in word format in addition to pdf. This option is not to be seen. Is there a short cut for this where customer just clicks on Print or Save button and the
Record Summary - to customize the blocks size
Hi, I am trying to create a frame work where I enter the details and trying to take the print out using Record Summary. However, in record summary formats, how to alter the block sizes. Example: I insert Paragraph it is sitting in the whole width of the window. I want the paragraph to sit in one part of the window. I tried to select section instead of block, however here also the section sits to the full width of the window instead of just one part of it. Regards Janaki
Summing up quantity of product sold in Purchase order form and displaying the same number in the Products form
Hello All, Actually i have a main form-Purchase Order and a subform in it-Purchase_subform which includes Products,Price,Quantity and Total field. Now i am entering the products in the subform alongwith the price and quantity for multiple products. I want to calculate the total quantity of each and every product sold in the subform in this month for all the Purchase Order records of this month. I need to store it in a field 'No of units sold' in the Products form. I am unable to figure out the solution.
Problem with dynamic lists
This is my query :- I have 3 forms So what I am trying to accomplish in this form is to select a building then Select ONLY a Floor that belongs the that building then Enter a Location I have tried this filter But I am getting an error. Any help would be appreciated
Mailchimp Webhook
Hello Guys, I want to receive the mailchimp webhook call at a public zoho creator html page but the parameters that the webhook sends to zoho are in array format like that: data[email] data[web_id] data[merges][LNAME] data[ip_opt] I think that zoho creator pages only receives single variable parameters like (x , y, a, b). So, how can I make that happen?
Creating a formula from excel land rounding it to a percentage
=ROUND(IF(H6>=4.999%,F6*0.04,IF(H6>=4%,F6*0.035,IF(H6>=3%,F6*0.03,IF(H6<=3%,F6*H6)))),2) Trying to create a formula to calculate the employer retirement match for an employee based on the above formula. Above is the Excel format. I want to round to .01,.02,.03,.035, or .04 The "H6" would be Employee_Deferral_Percentage. The "F6" would be the Employee_Salary.
Archiving Records
Hi I have a preschool app that includes a Child Registration Form and Attendance Register. The Register includes a look up field of the children's names to be selected from. I want to hide the names of the children who have left the service from this look up field (whilst keeping the original records). I added a radio button with 2016/17 and 2017/18 options so it is possible to filter the records but this doesn't hide the names in the look up field. How can I only include current pupils in the look
Fetch records from a sub form and fill dropdown field
I have a Product form with Product and Price for various sizes. Please see the attachment pic1.png. I have a estimate form to select the Product. Once I choose the product, it should show available sizes in the dropdown. When size is selected, it should calculate the cost of the product. Please see the attachment pic2.png. 1. How do I fill the dropdown the sizes based on the product selected? 2. How do I get the price when the size selected?
populate field automatically based on certain criteria
Hi There, I'm trying to populate a multi line field based on certain criteria matches from another form. I have Form A which has a selection list of skills (via a dropdown). On Form B (which is a capture new employee form), I have the same skills dropdown selection available. Once Form B is completed, i want the user to go to Form A and select a skill via the dropdown. Once the Selection has been made, i want a multiline field to populate only with Employee names that have the required skill. Could
Standard Deviation in a subform
Hi, I have a subform (named Samples) in order to add multiple rows with Total_Weight and Number_of_Samples. I would like to calculate the Standard Deviation of the samples and display it in the form (the parent one) I worked an script that use On user Input of Total_Weight and Number_of_Samples. Nevertheless it requires a huge amount of iterations, then I would like to do the calculation just one time (when the people fills all the rows or something like that) Do you know what is the more efficient
SelectAll or DeselectAll from a function
For a multi-select lookup field is there a method to SelectAll or DeselectAll from a function? These statements are available in the code sections of the form. For example I have a lookup field that shows all available skills. On the form I can use Skills_List_lookup.selectall() to check all of the boxes. But this statement is not allowed in a function.
Syntax Error with Multiple IF and Else if statements
I'm pretty new at this, and I can't figure out why I keep getting the "improper statement" error. I've taken out the specific field names and text, but i've left the structure completely in tact. Any ideas? (the error starts at the beginning of the "If" statement and is an improper statement error. Status1 = "<TEXT1>"; Status2 = "<TEXT2>"; Status3 = "<TEXT3>"; Status4 = "<TEXT4>"; Status5 = "<TEXT5>"; if ( Field 1 != null || Field 2 != null || Field 3 != null ) { Bid_Status == Status4
OpenURL in a function not maintaining navigation framing
We have a record review form opening in a popup for a user to complete a task allocation, which is defined in a custom workflow form. On submit it redirects from the popup to the edit form for the associated record, but in doing so "removes" all of the navigation and tab header controls in the process, presumably due to the "New Window" parameter in the openURL statement in the function, causing just the report URL to load at the top of the Window DOM in edit mode. There is no longer any zoho creator
Calculating Employment Duration
Hi All, I struggled to find a solution that would calculate an employment duration based on a user selected date and Publish the result to a field as follows : 2 Years 4 Months 5 Days as an example. Here is the solution i could come up with and works (I hope this helps for anyone reading this): CurrentDayEmployment = input.Employment_Start_Date.getDay(); // Gets the selected employment Days of the year I.E 01-02-2017 would produce 1 CurrentYearEmployement = input.Employment_Start_Date.getYear();
Extracting usefull data from South African ID number
I want my client to be able to input their RSA ID number (it's a bit like the American social security number) into a field, and have the information in the number used to autocomplete other fields in the same form. South African ID numbers contain info on: Date of Birth (and therefore age) as well as gender. If one of you Zoho Creator Superstars can show me how to have the Date of Birth field autocompleted after the client fills in his RSA ID number; I'm sure I can do the rest myself. The first
Sorry, we are unable to load the form.
a message appear when loading a form : " sorry we are unable to load the form " the below form cannot load usually this form didn't have any issue with me any ideas? https://creator.zoho.com/shehabcorpservice/service-status/#Form:visit_records
How to show/hide fields in Form B based on value selected in Form A
Hi, Say I have a multi-form app. The user will start at Form A and when he/she clicks submit is redirected to Form B. I am trying to show/hide fields in Form B based on a value selected in Form A. For example, if it were a Deluge script, it would be something like this: Form B's on load: if ([variable from form A] == "true") { hide Variable1; } Is this possible? Thanks, Isaac
Zoho Creator header in printouts
Hi, I configured the print option. Whenever I print the document, it is printing with Zoho Creator - invoice creator header and the https link as footer. How to remove that. I just want the invoice I created to be printed as company invoice. Regards Janaki
Next Page